Bug 128382 (xlsx-aggressive-competitors) - [META] XLSX: Bugs brought up by OnlyOffice in competitive comparison
Summary: [META] XLSX: Bugs brought up by OnlyOffice in competitive comparison
Status: NEW
Alias: xlsx-aggressive-competitors
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL: https://www.onlyoffice.com/best-libre...
Whiteboard:
Keywords:
Depends on: 60469 122472 128384 91476 128385
Blocks: XLSX 154391
  Show dependency tree / graph
 
Reported: 2019-10-25 08:58 UTC by Xisco Faulí
Modified: 2024-08-22 06:07 UTC (History)
11 users (show)

See Also:
Crash report or crash signature:

Attachments
Document used in their comparison (1.75 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-10-25 08:58 UTC, Xisco Faulí 		Details
OnlyOffice's sample XLSX as of 2024-04-02 (1.97 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-04-02 01:25 UTC, Stéphane Guillou (stragu) 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Xisco Faulí 2019-10-25 08:58:07 UTC 
Created attachment 155296 [details]
Document used in their comparison

This metabug is created after a chat with mmeeks in IRC.
it seems OnlyOffice has a website where the compare their xlsx compatibility with LibreOffice's one < https://www.onlyoffice.com/best-collabora-alternative.aspx >

I'll split the different problem we have right now with the document attached and will report it in different issues ( or check if they are already reported )
Comment 1 Julien Nabet 2019-10-25 09:12:13 UTC Comment hidden (obsolete)
Comment 2 Xisco Faulí 2019-10-25 09:17:27 UTC 
(In reply to Julien Nabet from comment #1)
> Are there so much bugs that we need to split Meta in sub metas?
> Soon, there'll be more METAs than real bugs! Aren't Search feature and
> related sufficient for lots of cases?

well, metabugs are useful for tracking related issues. This was more a personal request, but I also share the need of having it for this particular case...
Comment 3 m_a_riosv 2019-10-25 21:05:39 UTC Comment hidden (off-topic)
Comment 4 Buovjaga 2019-10-26 08:35:02 UTC 
(In reply to m.a.riosv from comment #3)
> Added tdf#76047 an old and severe bug about broken links between
> spreadsheets.

It is not being used by an aggressive competitor, though, so let's remove
Comment 5 Rizal Muttaqin 2020-03-14 14:32:57 UTC 
I like this METABUG and thanks for the competitors who has been actively report bug indirectly. And what I see latest fresh release now has better interopability. Such a good work.

*I'm not ODF worshipper of course. :)
Comment 6 Stéphane Guillou (stragu) 2024-04-02 01:25:57 UTC 
Created attachment 193430 [details]
OnlyOffice's sample XLSX as of 2024-04-02

The spreadsheet was updated by OnlyOffice. In this version the pivot table is not recognised by LO.
Also, the gif is now actually a gif (it wasn't one in the previous version).

I don't understand why it looks like about half of the sample they show in the website's export is missing from the file.
Comment 7 m_a_riosv 2024-04-02 02:54:46 UTC 
Experimenting a bit with OnlyOffice sample, the data source is an Excel table, maybe this is not cached by LO.
Copying the data in a new range and modifying the data source for the PT, then it is imported in LO.
Comment 8 Stéphane Guillou (stragu) 2024-08-22 06:07:10 UTC 
(changing the summary to match bug 128194)