Calc/Performance/CellStylesOfOoxML
If there are a lot of cell styles in MS 2007 .xlsx file, when loading the file in Aoo, it will take about 20 seconds to create the cell styles. After analyze the sample file, there are lots of duplicated cell style items in the original file,and such file maybe created by script or other tools. So a method must be used to get rid of the duplicated unused cell styles.
Here is the result data by the rational purify. Calls: 178,325 F+D: 25,128,429 Calls: 4,268 F+D: 24,404,739 1) ScCellRangesBase::setPropertyValues Calls: 45,336 F+D: 13,999,231 2) ScCellRangesBase::setPropertyValue Calls: 36,334 F+D: 8,745,959 3) ScStyleObj::setPropertyValues Calls: 28,282 F+D: 10,547,312 1)oox::xls::OoxSheetDataContext::onCreatContext 1) oox::xls::OoxSheetDataContext::importRow
oox::xls::WorksheetData::writeXfldRowRangeProperties oox::xls::StylesBuffer::writeCellXfToPropertySet
oox::xls::StylesBuffer::writeFontToProperSet oox::xls::StylesBuffer::writeBorderToProperSet oox::xls::Allignment::writeToPropertySet oox::xls::StylesBuffer::writeFillToPropertySet 4) ScStyleObj::setPropertyValue Calls: 36,334 F+D: 8,745,959 Calls:178,308 F+D: 5,538,047 Calls: 158,771 F+D: 4,810,522 1) ScCellRangesBase::setPropertyValues 2) ScCellRangesBase::setPropertyValue 3) ScStyleObj::setPropertyValues 2)oox::xls::OoxSheetDataContext::onEndElement 1) oox::xls::WorksheetHelper::setCellFormat
oox::xls::WorksheetData::writeXfldRowRangeProperties oox::xls::StylesBuffer::writeCellXfToPropertySet
oox::xls::StylesBuffer::writeFontToProperSet oox::xls::StylesBuffer::writeBorderToProperSet oox::xls::Allignment::writeToPropertySet oox::xls::StylesBuffer::writeFillToPropertySet 4) ScStyleObj::setPropertyValue Calls: 1 F+D: 21,475,924 Calls: 14,234 F+D: 21,419,377 1) ScCellRangesBase::setPropertyValues 2) ScCellRangesBase::setPropertyValue 3) ScStyleObj::setPropertyValues 3)oox::xls::OoxStylesFragement::finalizeImport 1) oox::xls::CellStyle::createStyle
oox::xls::StylesBuffer::writeStylesXfToPropertySet oox::xls::StylesBuffer::writeFontToProperSet oox::xls::StylesBuffer::writeBorderToProperSet oox::xls::Allignment::writeToPropertySet
oox::xls::StylesBuffer::writeFillToPropertySet 4) ScStyleObj::setPropertyValue
The oox::xls::CellStyle::createStyle is called 14,234 times, and the F+D: 21,419,377