https://bugs.documentfoundation.org/show_bug.cgi?id=89305
Bug ID: 89305 Summary: Formatting Enhacement: Cell Style 'Default' should be empty Product: LibreOffice Version: 4.3.5.1 rc Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Spreadsheet Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: ho...@schottky.eu I have to develop several Calendar sheets with the same functionality in Excel and Calc. The color marking of the weekends I do with conditional formatting. All lines contain different font-styles (narrow and normal fonts) for better readability. The only change for the conditional formatting should be the background color. In Excel this is easy done because the changes of conditional formatting is done by value. In calc this is done by hierarchical cell styles. This is actually a good idea. But because of the 'Default' cell-style, which is the root of all cell-styles, contends a font, this feature makes it impossible to apply a change of only the background-color to a line with several font-styles. Actually I have to convert some Excel-sheets to calc. In the converted sheet the 'Default' cell-style contains several formattings. So the converted ConditionalStyles, which should only change the background-color, can't be shown correct. As a workaround, I edit the styles.xml in the .ods file an delete all formattings in the default cell-style. With this modification most of the converted Excel sheets run out of the box. In spite of this experience there should be made the following changes: 1. The default template of calc should have an empty default cell-style. (I have already changed this on my system with good experience.) Another way to do this could be to make it possible to create cell-styles which are inherited from nothing, like the default style itself. 2. When importing a excel-sheet, the default cell-style should also be empty and all ConditionalStyles should be inherited from this empty style. 3. In the 'modify' dialog of styles there should be the possibility to delete properties. (Actually if I set e.g. a font, I can get rid of it later) -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs