Public bug reported: Binary package hint: openoffice.org
OpenOffice Calc 3.0 (build 3.0.0-6) from PPA <http://ppa.launchpad.net /openoffice-pkgs/ubuntu> uses commas to separate fields in formulas, rather than the OpenOffice default semi-colon. 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. ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New -- OpenOffice 3.0 from PPA [Intrepid] uses comma formula field separators instead of semi-colons https://bugs.launchpad.net/bugs/306602 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
