[upstream] OOo 3.0 uses comma formula field separators instead of semi-colons
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenOffice |
In Progress
|
Unknown
|
|||
openoffice.org (Ubuntu) |
Won't Fix
|
Low
|
Unassigned |
Bug Description
Binary package hint: openoffice.org
OpenOffice Calc 3.0 (build 3.0.0-6) from PPA <http://
After entering a formula for a range of cells using commas, I cannot go back and properly change the Relative/Absolute references of cell references in the formula. If I try to lock just one cell reference and hit Enter, all of the cell references in the formula get locked. Cell references that are "touching" a comma separator will not change at all with Shift-F4.
To get around this problem, I have to enter the formula using semi-colons, adjust the Relative/Absolute references to what I want, and then change the semi-colon back to a comma. If the semi-colon is left in, Calc gives an "Err: 508" in the cell. It also appears to work fine if I leave spaces before and after every comma in the formula.
Calc should be set to use the OpenOffice default of semi-colons for all field separators. This is also the standard for ODF 1.2 documents.
Changed in openoffice: | |
status: | Unknown → In Progress |
Changed in openoffice.org: | |
importance: | Undecided → Low |
status: | Incomplete → Triaged |
Changed in openoffice.org (Ubuntu): | |
status: | Triaged → Won't Fix |
If I understand the upstream bug report that I have attached this is intended behavior for localization of the way it is entered but should still be stored in the file correctly I presume.
Can you attach an example document that shows the problem you are having and I can make certain whether it is actually intended behavior?
Thanks,
Chris