Issue 97758 - Can't save autoformat settings for cell ranges in Calc
Summary: Can't save autoformat settings for cell ranges in Calc
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: DEV300m37
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Blocks: 84405
  Show dependency tree
Reported: 2009-01-05 05:53 UTC by amy2008
Modified: 2013-01-29 21:49 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description amy2008 2009-01-05 05:53:23 UTC
Can reproduce it with DEV300m37 on WinXP and Fedora

How to reproduce it
1 Open a new Calc document
2 Select cell ranges more than 3*3, e.g. B1:E10, Format - Autoformat, AutoFormat
  dialog opens, select any format except 'Default', e.g. 'Green' format, OK
3 Select B1:E10 again, File - AutoFormat, look at 'AutoFormat' dialog

'Default' format is selected

'Green' format should be selected in Format box
Comment 1 Regina Henschel 2009-01-06 00:17:44 UTC
I think, that it is the correct behavior, because it is a hard (direct)
formatting of the single cells and not a style for a range. There exists no
object which has a property to contain the autoformat name. 
Comment 2 amy2008 2009-07-22 07:12:51 UTC
meiying to regina,
If I define a data range for B1:E10 named db, then Format - Autotext - Green - OK,
select the data range db, then Format - Autotext, find "default" format is selected.
So, IMO, it is a bug. Pls check
Comment 3 Regina Henschel 2009-07-22 21:40:31 UTC
There exists no style property in a database range. So there is nothing that can
be "saved" in any form. Format - Autoformat applies a hard formatting to the
single cells. If you want a style for a database range (or for other named
ranges) that would be an entire new feature.