To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=41334
Issue #:|41334
Summary:|Named ranges (areas) reaching beyond 32000 rows badly
|converted to .sxc format
Component:|Spreadsheet
Version:|680m69
Platform:|PC
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|save-export
Assigned to:|spreadsheet
Reported by:|sakitc
------- Additional comments from [EMAIL PROTECTED] Wed Jan 26 00:06:49 -0800
2005 -------
If a range of cells reaching beyond the row 32000 is given a name (using the
Name Box or Insert - Names - Define), any formula using the name of the range
will produce an error when the spreadsheet is saved as "OpenOffice.org 1.0
Spreadsheet (.sxc)" type in OpenOffice.org 1.9.69.
The expected behaviour would be converting any number greater than 32000 to
32000 when saving in .sxc format.
Steps to reproduce the issue:
1. Create a new OpenOffice.org 1.9.69 spreadsheet
2. Select a column (column "A" in the attached files)
3. Enter a range name in the Name Box (e.g. "Range1")
4. Enter some numbers in any cells in the named column
5. Enter a formula such as "=MAX(Range1)" in a cell outside the named range
(cell "B1" in the attached files)
6. Save the spreadsheet as type "OpenOffice.org 1.0 Spreadsheet (.sxc)"
7. Open the saved spreadsheet in OpenOffice.org 1.1.4 (any 1.x would probably
behave the same). In the cell where you entered the formula (cell "B1" in the
attached files) you will see the "#NAME?" error message.
Workaround:
You can do this either before saving in .sxc format or after, i.e. either in
OpenOffice.org 1.9.69 or in OpenOffice.org 1.x:
1. Open the spreadsheet
2. Insert - Names - Define...
3. Select the range name ("Range1" in the attached files)
4. In "Assigned to" box change 65536 to 32000
5. Press the "Modify" button
6. Press "OK"
As the workaround is not trivial for casual users, I think it would be good to
fix the issue as it affects the backwards compatibility.
Another workaround would be to save in MS Excel format and open the .xls file in
OpenOffice.org 1.x, but I don't think that would be an acceptable solution.
Note that OpenOffice.org 1.1.4 (and probably any 1.x) converts 65536 (or any
number greater than 32000) to 32000 in named ranges when importing MS Excel
spreadsheets, exactly as a user would expect it to.
---------------------------------------------------------------------
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]
