- Dec 15, 2009
I have been sent Libre Office .ods documents. Excel opens them, but without formulas. Why?
Thanks Keebellah, I think the problem is on the sender side; I downloaded Libre Office and opened the document. Still no data.Did you check the links, maybe there is information there.
If you have a sample with some dummy data you could attach it
Thank you Dave. After doing a bit of experimentation, I think you may well be spot on! Formulas don't work unless the Libre Office spreadsheet is 'Saved as' an Excel 2010 spreadsheet. Open Data Format simply doesn't work in Excel 2010.I was under the impression that Formulae have never been successfully portable between Excel and Calc. especially if they use any functions.
Certainly I have never been able to do it with any that I've tried.
Even getting some formula to work properly between versions of Excel can be impossible.
hi, Dave,Even using save as does not always work.
I have a spreadsheet set up for my wife that charts the results of her breathing tests so she can control mild asthma without drugs.
I set it up in Excel 2003. It does not work, and cannot be made to work in Excel 2010 let alone Calc.
It does NOT use any clever code, but I can not get it to print correctly in later Excels and it does not even work in CALC.
Hi, Dave,So have I and believe me, there is no way to get it to print the chart to fill a single side of A4
The problem is that they removed the PRINT TO FIT PAGE option
No, this is the actual print. I have printed it on one page. It is legible, if small. I've sent you a screenshot of the ribbon control that does it.I can do screen shots of print preview where it shows as working and printing on one page, but the actual print runs over.
It is not worth spending time on it since I have changed it so that it does work under later versions now. It just annoyed me that I HAD to when MS advertises backward compatibility.
Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.
If you're not already familiar with forums, watch our Welcome Guide to get started.
Join over 807,865 other people just like you!