https://bugs.documentfoundation.org/show_bug.cgi?id=153380
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Pasting attribute table |Pasting table copied from |copied from QGIS makes |QGIS (as HTML) freezes |LibreOffice freeze because |because of large values in |of large values in WKT |WKT column (comment 24) |column (steps in comment | |20) | --- Comment #24 from Stéphane Guillou (stragu) <[email protected]> --- There's a lot of comments, so here's a summary: Steps to reproduce: 1. load the attachment 186147 geojson as a layer in QGIS 2. copy all the features with Ctrl + A and Ctrl + C (can also be done in the attribute table, opened with F6) 3. paste in Calc, click "OK" in Import Options dialog. Result: QGIS copies the attribute table with a WKT column that contains very long strings defining the geometries. The default clipboard target used in LO is HTML. In my test (using LO 7.5.2.2, QGIS 3.22.16, Ubuntu 20.04, the default paste target), pasting locks up LO at 100% of one core for more than 6 minutes until content is pasted. Opening the resulting ~5-MB ODS takes the same amount of time. Once the data is in LO (207 rows of data + headings, which matches data in QGIS), working with the data frequently freezes LO again for anything between a few seconds to several minutes, 1 core at 100%, making it impossible to work with it. (For example: select all, align to top: frozen for more than 20 minutes at 100% of 1 core, 2.4 GB of memory used, then crashed.) In LO, the resulting WKT column's contain strings up to 184,545 characters. Rows have very large heights, which might be related to the slowdowns. Workarounds: - in QGIS: Settings > Options > Data sources > Copy features as: plain text, no geometry. Only the attributes are pasted (but no spatial data is lost). - or, in LO: Edit > Paste Special > Paste unformatted text. WKT is included and paste is near-instant, but data is _silently_ truncated to 65,535 characters per cell. So a dataloss issue here. Expected result: If the number of characters per cell is too much to handle, LO should paste HTML tables similarly to text file imports: gracefully truncating the data to a sensible limit _while warning the user that data will be lost_. But it looks like LO _can_ have more than 65,535 characters per cell, and this example paste has the same order of magnitude, so why is it struggling so much? -- You are receiving this mail because: You are the assignee for the bug.
