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
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!)
Reproducible. Version: 5.5.0.0.alpha0+ 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 Version: 5.5.0.0.alpha0+ 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! Warm Regards, QA Team MassPing-UntouchedBug
Dear john4070, 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 https://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! Warm Regards, QA Team MassPing-UntouchedBug
Dear john4070, 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 https://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://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Hi all I can confirm that even the newest version of Libreoffice has the bug which is very annoying, at the moment a conditional formating changes the format of a cell all dates/percentages/currency settings are gone so it is impossible to us conditional formatting in your cheets. Please have a look at this bug. I have a example cheet where you can easily see the problem.
Created attachment 194657 [details] conditional formating removing date / curency / percentage from existing fields
*** Bug 161510 has been marked as a duplicate of this bug. ***
Created attachment 194674 [details] very work intensive workarround adding for every type (percentage/date/currancy and the rest) a style and then use it in the appropriate column made it work, but it is very work intensive. I could work with this workaround when Conditional Formatting rules could be copied. see what I mean in the next picture
Created attachment 194675 [details] Example to add copy for Conditional formating