A Conditional Format to change the background color but keep the Date format

Question

I have and OpenOffice Calc document that has a "table" with Text, Numeric and Date columns. I have a conditional format making every odd row have a different background color so it will be easier to read.

The problem is that the rows which are affected by the conditional format will loose it's other format. In this case the date. If I put a date format in the conditional style then the Numeric cells will become a date...

Is this fixable and if so How?

Answer 1

Select the range and run this macro:

Sub Main
    Dim oCurrentSelection As Variant
    Dim oRows As Variant
    Const nCellBackColor = 15132415 REM # "Blue gray"
    Dim i As Long
    oCurrentSelection = ThisComponent.getCurrentSelection()
    If oCurrentSelection.supportsService("com.sun.star.table.CellRange") Then
        oRows = oCurrentSelection.getRows()
        For i = 0 To oRows.getCount()-1 Step 2
            oRows.getByIndex(i).setPropertyValue("CellBackColor", nCellBackColor)
        Next i
    EndIf
End Sub

Answer 2

You could try to use an extension rather than conditional formatting, this shouldn't change the formatting of the cells (other than the background)

http://extensions.services.openoffice.org/en/project/Color2Rows