[Bug 122399] Can't calculate formula

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=122399

Rob Weir <ro...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needmoreinfo

--- Comment #1 from Rob Weir <ro...@apache.org> ---
Your sheet gives me an error when loaded into Excel 2013.  I'm prompted to
repair the sheet and when I do the formulas are lost.

In OpenOffice the tilde is the reference concatenation operator, used to
express complex (not contiguous) ranges.  See:

http://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Creating_formulas


Something like "=L6-(-4~3)" is treated as a syntax error in OpenOffice.

If I enter the same formula into Excel 2013 it is also treated as an error.

Could this be a localization error, where you are using the ~ on your keyboard
to express a basic spreadsheet operator?  What does ~ mean in your spreadsheet?
 What operator is it?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.