[Libreoffice-bugs] [Bug 108373] New: Conditional formatting changes format of dates and numbers

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108373

            Bug ID: 108373
           Summary: Conditional formatting changes format of dates and
                    numbers
           Product: LibreOffice
           Version: 5.2.7.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jbk4070 at gmail.com

Description:
I have a sample ledger with columns B through H as Check No., Date, FirstName,
LastName, Income, Expense, and Balance.  I want odd months to be shaded (light
blue).  Date format:  6/6/17; numbers are all with 2 decimal places.
Conditional format using "=ISODD(MONTH($C6))" where C6 is the top date, makes
all odd month rows light blue BUT CHANGES THE FORMAT OF DATES to their date
number AND changes most whole numbers deleting their decimals (67.00 becomes
67, etc.)
I can change the number days between dates at will to help demonstrate the
problem.
This does not happen in Excel - I had to check!

Steps to Reproduce:
1.Removing the conditional formatting OR changing the difference in dates to
make more or fewer bands makes those dates changed to colorless (even months)
back to their normal date format, 06/06/17, etc. AND number regain their
decimal places!
2.
3.

Actual Results:  
I'll be happy to email my sample sheet if you'll let me know how and where.  

Expected Results:
See above.  Dates should not change their format.  Numbers also.


Reproducible: Always

User Profile Reset: No - - - and your instructions, below, do not work!  

Additional Info:
I can't believe others haven't run into this problem!


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170606/8f414930/attachment-0001.html>