When opening an excel file made under windows in Libreoffice Calc things will not be as it is in original excel file. Fonts are larger and different, borders are much thinker, hidden rows or columns are not accessed but shown as corrupted area in the sheet, and filters are not functioning not appearing ! Is there away to simply use Libreoffice without the need to go and use Ms office?
XLS(X) is a proprietary format. LibO developers are doing their best for compatibility with MS Office formats. But some problems may occur. If you have so many troubles with your files, please report a bug https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice with detailed description, LibO, MSO and OS versions, example files and screenshots (if available).
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-10-30 18:49:32 +0200
Seen: 1,481 times
Last updated: Oct 31 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
I can't see how the fact that XLS export is not perfect relates to your question (can I use LO alone?). You should point out which functionalities you can't find in LO, so we can help you and find them. But as a general answer, I would say : yes, of course, you can use LO alone (as I do).
hyogapag ( 2012-10-31 09:48:29 +0200 )editSure you can use LO alone, but as long as you are not exchanging files with windows platforms. If you need to send a file or receive a file from any windows user then I'm pretty sure you will face a frustrating results that makes you think twice before trying it again.
Ibrahim Hammad ( 2012-11-10 09:37:12 +0200 )editDoes this mean you are under Linux? If yes, the problem can be that you don't have the right fonts (eg : Times New Roman), but you can install them. Under Ubuntu, the package is ttf-mscorefonts-installer. I exchange files with lots of people under Windows, I have never been frustrated but once.
hyogapag ( 2012-11-10 10:32:05 +0200 )editYes,I'm Under Linux and trying more than hard not to shift back. I thought of the fonts, but the basic fonts are there.The problem is when I open old excel files built in windows, it will be very bad.This goes with writer as well.I tried to file a bug more than once, nothing happened.can u help pls?
Ibrahim Hammad ( 2012-11-10 18:33:37 +0200 )editThis is not the first time. I've filed two bugs 56960 & 56961. one for spreadsheet and one for writer, but this time I did not attach screenshots as I was doing before.
Ibrahim Hammad ( 2012-11-10 19:32:56 +0200 )editI looked at the bug 56960. I don't know how your file should look like, but I can guarantee the five sheets are there at least using LO 3.6.2 (Summary, Contact, Pipeline Opportunity details, Action).
hyogapag ( 2012-11-10 23:52:09 +0200 )editCurrent status of fdo#56960 is NEEDINFO
Current status of fdo#56961 is NEW
qubit ( 2013-02-01 17:01:17 +0200 )edit