Oct 9, 2007 at 12:40 AM
In working with the ExcelPackage library, I found working with named styles to be burdensome. I know that several libraries work this way, where you create a style and then apply the name to a cell. I was thinking it would be useful to have something kind of the reverse. You have a .Style property on a cell which allows you to modify the style for that cell, then when the workbook is saved you could compress (remove duplicate) styles and apply random names. The nice part of this would be if you have an error style, for instance, but then the column you are currently in needs different borders from the normal "error" style. I do this sort of thing all the time and end up with styles named "error-bordertop-bold" for just two different style elements. I'm sure this would probably slow things down a bit, but usability would be much better.

Any thoughts?