Issue 97758 - Can't save autoformat settings for cell ranges in Calc
Summary: Can't save autoformat settings for cell ranges in Calc
Status: CONFIRMED
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:
URL:
Keywords:
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: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

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

Result
'Default' format is selected

Expectation
'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.