Apache OpenOffice (AOO) Bugzilla – Issue 122399
Can't calculate formula
Last modified: 2017-05-20 09:54:51 UTC
Created attachment 80740 [details] Can't calculate formula in column M AOO can't calculate this formula: =L6-(-4~3) Why? For example MSO and LO calculate this formula. Look on column M in attached file.
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?
Created attachment 80741 [details] oryginal file
Hallo Rob Thanks for your help. I get file from my friend, and I cut section from him in LO and save as xlsx. That is why you probably can not unlock him in MSO 2013. So now I attached original file "measure.xlsx". Try open him. "What does ~ mean in your spreadsheet? What operator is it?" - I don't know why he use "~" instead of "," but if I open this file "measure.xlsx" on LO all is right. On the margin: Do you use MSO 2013? Why? You don't like AOO? I am disappointed. ;-( I greet PS: Sorry for my English. I don't know him, but try all explain.
Measure.xslx gives me an error in Excel 2013 also. So something is wrong in the original file. Also, the same formula, entered into a new Excel spreadsheet also gives an error. I don't know what LO is doing here, but whatever it is, it is not compatible with Excel or OpenOffice. It would help if you can find out what "4~3" represents.
Created attachment 80753 [details] AOO4.0-bulid_1487177
Created attachment 80754 [details] EXCEL2010
Created attachment 80755 [details] LO4.0.3
Hello Rob 1. I attached screen shot from MSO 2010, LO and AOO. "It would help if you can find out what "4~3" represents." - I don't know what means, but if MSO 2010 open this file as "repairs mode" maybe AOO should be open this file in "repairs mode"? What you fink about this? 2. The question from the different border cell. Rob I new to formating border cell use settings center borders, but in AOO I don't find him. Look et MSO 2003, 2007, 2010 or 2013 then you understand me. In MSO formating cell border he is more intuitive. Please correct this. 3. If I using my file long time in AOO then the AOO slows down then- hi is like the mud -it's very difficult. I want only help for you to cerate very good office, so don't be angry to me.
So in your Excel 2010 image it shows that Excel stripped the formula. So I think the formula is not valid. There could be a bug also in LO that it is not reporting the bad formula. For other questions on borders, etc., please post to the community support forums here: http://forum.openoffice.org/ We want to use Bugzilla for bug reports only.