LibreOffice 6.0 Released With A Ton Of Open-Source Office Suite Improvements

[reavertm]

I would deliberately grow and obfuscate the spreadsheet to the point where even Excel won't open it. Perhaps that will get management's attention and clue them in that they're using the wrong tool for the job and instead need to hire a DBA.

Don't underestimate desktop version of Excel. It can really take almost anything you throw at it.
Finest minds at Microsoft were working on it. It's a pinnacle of Microsoft technology, appreciated by almost everyone, regardless the occupation
Besides, it would only temporarily freeze the operation of one business line in certain huge, multinational company, workaround would be swiftly introduced

(I heard some move to JIRA is planned, eventually)

[torsionbar28]

Where I work, product backlog is kept in network shared, over 10MiB, feature-abused Excel file with over hundred or two foldable (groups) columns, macros, colors and lots of rows, obviously. Only standalone, desktop version of Microsoft Excel manages to open it. Anything else (which includes Libreoffice and online version of Excel, from Office365) either crash of just fail reading it. I keep remote VM with Windows for the sole purpose of accessing that file.

"People do".

I would deliberately grow and obfuscate the spreadsheet to the point where even Excel won't open it. Perhaps that will get management's attention and clue them in that they're using the wrong tool for the job and instead need to hire a DBA.

[Royi]

I wish they used LaTeX syntax for the Math support.
The current implementation is really bad.

[ua=42]

Similar situation here. its awful

It's probably not LibreOffice... its LibreOffice's file converter that's choking. I don't know which version of Excel you use, or how well Excel export features work, but if you Save As the ods format, Libreoffice might be able to read that monstrosity. (Last I heard though... Microsoft Office sucks with the open document format)

[cj.wijtmans]

Where I work, product backlog is kept in network shared, over 10MiB, feature-abused Excel file with over hundred or two foldable (groups) columns, macros, colors and lots of rows, obviously. Only standalone, desktop version of Microsoft Excel manages to open it. Anything else (which includes Libreoffice and online version of Excel, from Office365) either crash of just fail reading it. I keep remote VM with Windows for the sole purpose of accessing that file.

"People do".

Similar situation here. its awful

[reavertm]

Perhaps, but its just true. But then again who the heck puts 100k rows in a spreadsheet.

Where I work, product backlog is kept in network shared, over 10MiB, feature-abused Excel file with over hundred or two foldable (groups) columns, macros, colors and lots of rows, obviously. Only standalone, desktop version of Microsoft Excel manages to open it. Anything else (which includes Libreoffice and online version of Excel, from Office365) either crash of just fail reading it. I keep remote VM with Windows for the sole purpose of accessing that file.

"People do".

[cj.wijtmans]

now you're just being an ass

Perhaps, but its just true. But then again who the heck puts 100k rows in a spreadsheet.

[quikee]

opens fine with excel. Calc* is just a piece of trash that cant load shit.

now you're just being an ass

[cj.wijtmans]

Never saw the document, so I guess there is nothing needed to be fix.

opens fine with excel. Calc* is just a piece of trash that cant load shit.

[quikee]

100k rows dozens of columns an lots of colors. (originally a ms office document) Wont open

Never saw the document, so I guess there is nothing needed to be fix.