https://issues.apache.org/ooo/show_bug.cgi?id=122399
Rob Weir <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |needmoreinfo --- Comment #1 from Rob Weir <[email protected]> --- 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.
