Ask Your Question

Is there any way to avoid this experience?.

asked 2019-07-12 08:24:53 +0200

Sugi gravatar image

updated 2020-08-20 01:55:59 +0200

Alex Kemp gravatar image

I created invoice using libre calc with the extension xlsx. I have this experience when I open it on microsoft excel. Is there any way to avoid this experience?. My client using microsoft excel. Thanks. image description image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-12 08:50:53 +0200

What you see is an interoperability bug. It means that at least sometimes LibreOffice generates content not fitting MS Excel's expectations.

The funny thing is that it's not even guaranteed to be LibreOffice's bug: we've met some cases when MS Office apps don't follow own format specs, and apply restrictions absent in the standards. Still, usually we opt to treat all such cases as things to be changed in LibreOffice: if needed, we include workarounds for MS Office quirks.

As with any bug, the only "way to avoid this experience" is to fix the bug; and to do that, a bug report must be filed, with clear steps how to reproduce the problem: e.g., how to produce such a file (which data is required there to give that error? I assure you that not every XLSX document generated by LibreOffice gives that). Before filing that, it's good to check if the problem exists in the latest version of LibreOffice, which is (release candidate) at the time of writing.

edit flag offensive delete link more


This looks like Office365 version (so always up to date): They seem to have problems even with their own old files. I do experience this at the moment with xlsx files created with "older" versions.

I guess: simply wait a month and they do fix it again.

Dennis R. gravatar imageDennis R. ( 2019-07-12 09:53:37 +0200 )edit

the only "way to avoid this experience"

Well, not only. Export to XLS instead.

gabix gravatar imagegabix ( 2019-07-12 10:00:46 +0200 )edit

@gabix: heh, you're right :-) - that "only" was meant to be "the only proper way" (and then again, "proper" in the eyes of a community member interested in improving LibreOffice).

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-12 10:17:08 +0200 )edit

Of course. Provided, however, the problem is on our side :-)

gabix gravatar imagegabix ( 2019-07-12 11:11:04 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-12 08:24:53 +0200

Seen: 113 times

Last updated: Jul 12 '19