Comment 2 for bug 306602
Revision history for this message
| gkornelson (gkornelson) wrote Re: [upstream] [ppa] OOo 3.0 uses comma formula field separators instead of semi-colons | #2 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
67d34a1
(Get the code!)
I won't be able to send this to you until early January, as I am out of town for the Christmas holidays without access to an Ubuntu box. If you'd like to try it yourself, use a function like SUM to add up some numbers in column A, along with one number in column B. The formula would be something like:
=SUM(A1:A5,B1)
The comma is working fine as the field separator in this case, but if you replace it with a semi-colon, you will get an error. That's not the main problem though. The problem is that if you would like to copy this formula down to more cells, adding up more values in column A with cell B1, you have the change the reference to B1 to an absolute reference (Shift-F4). The formula should look like this for this function:
=SUM(A1:A5,$B$1)
However, with the comma separator, OpenOffice is having trouble changing individual references. Selecting the B1 reference in the first formula and pressing Shift-F4 appears to change it properly, but when you hit enter and then re-examine the formula, it doesn't work. If you now replace the comma with a semi-colon, you will be able to properly change all of the individual cell references from relative to absolute and back, but the formula will produce an error once you are finished editing it. Also, if you put a space before and after the comma in the formula, everything works as it should, but this is rather cumbersome to do. The Windows version of OOo 3.0 does not have this problem, as it uses only the semi-colon for all field separators.