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
