https://bugs.documentfoundation.org/show_bug.cgi?id=149166
Bug ID: 149166
Summary: Improve speed of importing HTML tables with images
from clipboard and subsequent saving
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mattmil...@googlemail.com
Description:
Copying a modern 13,000+ row HTML table with multiple divs per cell for styling
and inclusion of images, results in the copy taking multiple hours and save
also taking an hour.
The issue appears to be related to the images, because editing the fods file in
Notepad++ and removing the <table:shapes> element solves the performance issue.
Perhaps the default HTML table paste should remove images, with an option to
either embed the images within the document as base64 data, or use an image
cache/multi-threaded URI resolver?
Steps to Reproduce:
--Only attempt when you don't need LibreOffice for the next several hours--
1. Launch Microsoft Edge and navigate to CoinGecko "All Cryptocurrencies" list
- https://www.coingecko.com/en/coins/all
2. Click "Show More" approximately 50 times, because modern websites are
counterintuitive.
3. Highlight all Rows and click copy
4. Select A1 and paste
--Note: notice that the icons are also no longer embedded within the cells, but
rather floated to coordinates approximately inline with the row--
5. Save and wait for another hour, for a (compressed)/53MB (uncompressed) file
--Note: Autosave is the devil-incarnate, banish it before attempting--
Actual Results:
Mind-numbing slowness
Expected Results:
Not mind-numbing slowness
Reproducible: Always
User Profile Reset: No
Additional Info:
By comparison opening the uncompressed fods file into Notepad++ and resaving it
to a new file took approximately 10 seconds to write to the new file.
--
You are receiving this mail because:
You are the assignee for the bug.
