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.
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 6.3.0.1 (release candidate) at the time of writing.
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.
the only “way to avoid this experience”
Well, not only. Export to XLS instead.
@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).
Of course. Provided, however, the problem is on our side