Formula disappeared

[Estoguy]

So I was working on my spreadsheet and, well, we have to actually do it with excel, but excel is simply too annoying for me, so every now and then I am checking how my work looks in excel view. Now, I opened my document in excel, made a few a changes, saved, opened it with Calc again and alllllll the formulas, EVERYWHERE are missing, it doesn't have the formula in the cell, it just has numeric values. What on earth happened

I knew I should ve thrown that MS office dvd right out the window...

[FJCC]

What format are you storing the file in? In my Excel (2007), if I save a document in ods format it strips out all of the formulas.

[Estoguy]

I apologise for my...steamy behaviour in the first post - I was simply too angry at the time to think with a cool head.

I saved my work as an ods for backup and then saved as an xls - everything was fine. When I changed things in excel (MS office 2010) and saved it as an excel file, when re opening it with Calc, saving as an ods file, everything disappeared.

For whatever reason, if you people work with Excel and Calc, must have backups made just incase this stuff happens, clearly Openoffice and MS office don't get along on the 1st name basis :/

[Hagar Delest]

Remember that .xls import/export filters have been reverse engineered. The .xls format has not been designed to be compatible with anything else than MS Office. That's the vendor lock-in policy. That's why it's important now to use true open formats like ODF.

But well, such an issue is rather strange anyway.

Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.

[gerard24]

Microsoft claims they are able to use ODF format. That's wrong, they are just able to open an ODF like a PDF wiewer after converting .ods in .pdf.
Lies ! Just save in .xls!

[Hagar Delest]

Indeed. It's even insidious because it converts the formulas to numbers. So you think that there is no problem, until you try to change numbers and no calculation is performed...
Don't know if the bug will still be there for the ODF1.2 support in MS Office.