Description: If you want to delete a format template (right side panel, the buttons shows an "A" with a brush) you can do it with [right click -> delete] or by pressing the [delete] key. You can only do this one by one though. You can not select multiple templates and delete them all at once. Steps to Reproduce: 1. Have an Excel file with quite a few conditional formats 2. Check the format presets 3. Actual Results: You can not select more than one format preset at a time Expected Results: You can select more than one format preset at a time Reproducible: Always User Profile Reset: No Additional Info: This problem was discovered when an Excel file from work was edited where conditional formating was used quite heavily. Since there seems to be no format template like there is on LibreOffice, ever condition got it's own format. The count says 25'283 templates (YES, over twenty-five THOUSAND - see image). When I want to clean this file and import it into LibreOffice there is no quick way to get rid of them all at once. Two thoughts: - It would be a neat feature if you could replace all formats in one go with an existing template or one that you create. The chosen template would get applied to all uses of that format template - It should tell you how many templates you are about to delete. If there are more than like 10 it should ask you to avoid killing 25'000 templates by accident.
Created attachment 181300 [details] Format template of xlsx file The file from my work. The heavy use of conditional formating created >25'000 different templates even there are only two: [green cell background + white text] and [red cell background + white text]. When I want to delete them it would be a long day.
Created attachment 191695 [details] 27485 leftover MS Excel style templates.png My company finally switched from Microsoft Office to LibreOffice. However, they just copied one of the most important Excel tables and saved it with LibreOffice as ods. There are now over 27'000 (YES, > 27k) style templates that I would have to delete one by one with the current system.