[Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #15 from Laban --- Created attachment 194675 --> https://bugs.documentfoundation.org/attachment.cgi?id=194675&action=edit Example to add copy for Conditional formating -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #14 from Laban --- Created attachment 194674 --> https://bugs.documentfoundation.org/attachment.cgi?id=194674&action=edit 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 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 m_a_riosv changed: What|Removed |Added CC||davidkno...@icloud.com --- Comment #13 from m_a_riosv --- *** Bug 161510 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #12 from Laban --- Created attachment 194657 --> https://bugs.documentfoundation.org/attachment.cgi?id=194657&action=edit conditional formating removing date / curency / percentage from existing fields -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #11 from Laban --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #10 from QA Administrators --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #9 from QA Administrators --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #8 from QA Administrators --- ** 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 Eike Rathke changed: What|Removed |Added CC||markus.mohrhard@googlemail. ||com --- Comment #7 from Eike Rathke --- 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.. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #6 from Xavier Van Wijmeersch --- Created attachment 133926 --> https://bugs.documentfoundation.org/attachment.cgi?id=133926&action=edit 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #5 from john4070 --- 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! -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #4 from Xavier Van Wijmeersch --- Created attachment 133903 --> https://bugs.documentfoundation.org/attachment.cgi?id=133903&action=edit decimal and currency with conditional formatting -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 --- Comment #3 from Xavier Van Wijmeersch --- Created attachment 133899 --> https://bugs.documentfoundation.org/attachment.cgi?id=133899&action=edit 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 --- Comment #2 from m.a.riosv --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 108373] Conditional formatting changes format of dates and numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=108373 john4070 changed: What|Removed |Added CC||jbk4...@gmail.com --- Comment #1 from john4070 --- Created attachment 133879 --> https://bugs.documentfoundation.org/attachment.cgi?id=133879&action=edit 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!) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
