I’ll read an old copy from backup and see whether I can find any differences.

In the document the cell shows as : ooow:=SUM() The only time “ooow” is mentioned inside content.xml (and style.xml) : xmlns:ooow='' But looking at its content.xml, the formulas do not look that bad: Unfortunately I cannot share the document here. I suppose that the problem might not be in reading that file, but that a problem occurred during the save. Tried to open it with LibreOffice 4.0.3 from Wheezy-Backports and with Apache OpenOffice 3.4.1 - same result. The “Display Formulas” checkbox has no effect. The formulas are still there, in theory I could enter them all again, but that would be a pain. Editing and saving worked when I open it now, I only see “ooow:” formulas. It’s still in SXC format, I didn’t see any need to change. Make sure you use 'Regular Expressions' (hit More):Īfter that you'll find your numbers are really numbers and that there's no apostrophe ' in front of them.Same sxc problem here: With LibreOffice Calc from Debian Wheezy (I think it was the normal version, 3.5.4) I opened a file that I have been occasionally editing since several years. Just do a find and replace but don't choose 'Current selection only', because the cells in the selection don't show it so it will say 'Search key not found'. *Easy solution with regular expression searches within the whole Calc sheet There is supposedly some work around involving changing the default language or something, this bug has been around for years and the devs would rather flame the users than even acknowledge and fix it. I don't have time for this, I've read belligerent comments in the OpenOffice forums from what seems like a dev who refuses to admit this is a bug. You can't even do a standard search and replace since it's a weird bug that ony shows itself when you click an individual cell that is affected. This is typical OpenSource software that keeps introducing bugs into the simplest of operations and tasks. The only solution is search and replace ' to blank but it's ridiculous. If I change it to be currency it still does the same thing! What a stupid bug in Calc/Openoffice. I notice when I click the cell there is an invisible ' in front of the number:Ĭalc imported my CSV and decided to add a ' in front of the numeric currency values!!!*Actually the problem occurs when you right click the cells and change the type from text to number, no matter what format you choose. I right clicked all applicable cells and chose 'number' but that's enough.

Openoffice calc sum not working