https://bz.apache.org/bugzilla/show_bug.cgi?id=58260
--- Comment #17 from Javen ONeal <[email protected]> --- Spreadsheets that use naive style creation end up with very large styles tables with duplicate entries. Perhaps the root cause here is we don't have a great way to do either of the following: 1) Make a function to query the styles table if for a given style. The problem here is that you can't create a style to query the styles table without necessarily adding that style to the style table. If I want to start with an existing style, and slightly modify it (say, change the font to bold), I don't have a great way to see if there is another style that is bold in the styles table. Out of laziness for writing my own code that can compare styles, I just create a new style. Do this in a for loop and you've got problems. 2) when saving a workbook or calling a function on-demand, find all duplicate styles in the styles table and deduplicate them, updating all cell references to the deduplicated style. Microsoft Excel seems to deduplucate styles on workbook save. I can open up a new bug if these fixes would help prevent issues like seen in this bug. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
