To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=55201
                  Issue #:|55201
                  Summary:|Conditional formatting saved as xls is not applied
                          |after 256 rows
                Component:|Spreadsheet
                  Version:|OOo 1.1.4
                 Platform:|All
                      URL:|
               OS/Version:|All
                   Status:|UNCONFIRMED
        Status whiteboard:|
                 Keywords:|
               Resolution:|
               Issue type:|DEFECT
                 Priority:|P3
             Subcomponent:|save-export
              Assigned to:|spreadsheet
              Reported by:|kerneld





------- Additional comments from [EMAIL PROTECTED] Wed Sep 28 10:13:02 -0700 
2005 -------
When using Conditional formatting and saving as an xls file, the conditional
formatting is only applied to the first 256 rows when the file is opened with
excel 2003 or gnumeric 1.5.90.

In excel, the conditional formatting is set correctly if you select the area
with conditional formating, and edit the conditional formatting. Hitting OK then
applies the formatting correctly, but not until that time.

I can supply a sample file of you want, but it is easy to reproduce.

1) Select a column (EG: Column 1)
2) apply a conditional format with the formula:
 ROW(A1)>0
3) apply a format with a background color or something else easy to see.

4) Save as Excel

5) Open in any of Gnumeric 1.5.90, excel 2003, excel viewer 2003
* The formatting appears to have only been applied to the first 256 rows.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to