• flypig's avatar
    [calligra] Add optimisations for importing readonly XLSX docs. Contributes to JB#13262 · 957e6021
    flypig authored
    This adds a number of optimisations when importing readonly XLSX format
    speadsheets.
    
    1. Use the pre-calculated cell content values rather than performing a
    full recalculation using the cell formulae.
    
    2. Calculate a minimal containing rectangle around the cells with
    content and import only those cells + a fixed border (5 cells by
    default). Cells with only a background colour are ignored. This avoids
    having to import large areas of empty cells (which are a common
    occurrence in Excel files, since they're generate if the user selects an
    entire column/row and applies a style to it).
    
    The following additional compile-time cmake flags are also added.
    
    MSOOXML_MAX_SPREADSHEET_COLS=<integer>
    
    Controls the maximum number of columns to import. Defaults to 0x7FFF,
    the maximum supported by Calligra.
    
    MSOOXML_MAX_SPREADSHEET_ROWS=<integer>
    
    Controls the maximum number of rows to import. Defaults to 0xFFFFF, the
    maximum supported by Calligra.
    
    MSOOXML_SPREADSHEET_CONTENT_BORDER=<integer>
    
    The size of border to add around the minimal containing rectangle for
    read only documents. Defaults to 5.
    957e6021
Name
Last commit
Last update
kcodecs @ 34e0340b Loading commit data...
kcompletion @ 961b47ba Loading commit data...
kconfig @ f2ef40c9 Loading commit data...
kconfigwidgets @ aba32e69 Loading commit data...
kcoreaddons @ f6ac8a61 Loading commit data...
kdbusaddons @ 4205752c Loading commit data...
kdiagram @ d3602e2a Loading commit data...
kguiaddons @ 8affe0c9 Loading commit data...
ki18n @ 4ffbb684 Loading commit data...
kiconthemes @ 49104a7d Loading commit data...
kio @ b5dc0de3 Loading commit data...
kitemviews @ e10c2d3a Loading commit data...
kservice @ 8ad05648 Loading commit data...
kwidgetsaddons @ 3cb008f3 Loading commit data...
kxmlgui @ 8fed1286 Loading commit data...
rpm Loading commit data...
upstream @ 5fcc0368 Loading commit data...
.gitmodules Loading commit data...