Ask Your Question
0

Compatibility with Ms Excel [closed]

asked 2012-10-30 18:49:32 +0100

Ibrahim Hammad gravatar image

updated 2015-08-29 21:39:22 +0100

Alex Kemp gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-14 16:11:36.405107

Comments

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 gravatar imagehyogapag ( 2012-10-31 09:48:29 +0100 )edit

Sure 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 gravatar imageIbrahim Hammad ( 2012-11-10 09:37:12 +0100 )edit

Does 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 gravatar imagehyogapag ( 2012-11-10 10:32:05 +0100 )edit

Yes,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 gravatar imageIbrahim Hammad ( 2012-11-10 18:33:37 +0100 )edit

This 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 gravatar imageIbrahim Hammad ( 2012-11-10 19:32:56 +0100 )edit

I 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 gravatar imagehyogapag ( 2012-11-10 23:52:09 +0100 )edit

Current status of fdo#56960 is NEEDINFO

Current status of fdo#56961 is NEW

qubit gravatar imagequbit ( 2013-02-01 17:01:17 +0100 )edit

2 Answers

Sort by » oldest newest most voted
2

answered 2012-10-31 05:57:10 +0100

Timon gravatar image

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).

edit flag offensive delete link more

Comments

XLS might be a proprietary format, but XLSX is based on Office Open XML which is described by standards ECMA-376 and ISO/IEC 29500.

Cristian Ciupitu gravatar imageCristian Ciupitu ( 2015-09-01 15:54:03 +0100 )edit
0

answered 2013-11-18 07:58:34 +0100

dotancohen gravatar image

Each of the problems that you mention are separate issues unto themselves. If there is no proprietary information in the spreadsheet, then please post it on a file-sharing website and post a link. I will look at the document and help identify all the individual issues which we will solve one-by-one. Perhaps we will file bugs to help improve LO in the future as well.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-10-30 18:49:32 +0100

Seen: 21,103 times

Last updated: Nov 18 '13