How can I import from Excel without the cruft that slows down Calc?

asked 2017-05-22 00:14:38 +0200

dandv gravatar image

updated 2017-05-28 23:40:24 +0200

I have an .xlsm with about 10,000 rows, many of which have colors. The formulas are very simple - SUM and SUMIFS. No conditional formatting.

If I import that into an ODS, it's so slow I filed a bug against Calc. I've removed all macros, but the imported file is still very slow to open.

Is there a way to import that Excel spreadsheet without whatever cruft causes the slowness? If I copy/paste just the values, without formatting, the ODS opens fast, but I need to keep the colors.

edit retag flag offensive close merge delete