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!
I'll be happy to email my sample sheet if you'll let me know how and where.
See above. Dates should not change their format. Numbers also.
User Profile Reset: No - - - and your instructions, below, do not work!
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
Created attachment 133879 [details]
Sample ledgers. Formatted area on left includes check Number, sample on right does not.
Change date differences in yellow cell L30 and see the date formats go back and forth.
(I'm sure I'm doing something wrong but what is it? This does not happen in Excel - and I'm not using Excel for this app!)
Build ID: 6b2b689e944be554f7882b349332686755ce6c4b
CPU threads: 4; OS: Windows 6.19; UI render: GL;
TinderBox: Win-x86@42, Branch:master, Time: 2017-06-01_06:25:09
Locale: es-ES (es_ES); Calc: CL
Created attachment 133899 [details]
changing column B to C
I confirm the behavior with conditional formatting3
but changing column B to C then there is a normal result see attachment
Build ID: ddf8539d97ce044b7df8d51d6ec72ec864b40fb8
CPU threads: 2; OS: Linux 4.9; UI render: default; VCL: kde4;
TinderBox: Linux-rpm_deb-x86@71-TDF, Branch:master, Time: 2017-06-04_22:00:43
Locale: nl-BE (en_US.UTF-8); Calc: group
Created attachment 133903 [details]
decimal and currency with conditional formatting
I knew that changing the date and check number columns would work but I use the check number in lookups elsewhere and need to preseerve its location as the leftmost column.
I see that changing to pounds from dollars makes a difference but my funds are all in dollars.
As indicated, this works fine in Excel. No problem. I do want to do this in LO however!
Created attachment 133926 [details]
working conditional formatting
you did not tel the check number was with a vlookup
so i used your first example and made it work with us dollar
its not a bug, there some forums where you can ask help like
ask.libreoffice or forum openoffice
these volunteers can help you for a solution like yours
Nevertheless it *is* a bug. As soon as the content of a cell in column B is deleted, the neighbouring cell in the same row in column C gets displayed correctly.
@moggi: you might be interested in this one..
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword
Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!