[Libreoffice-bugs] [Bug 131524] Date format in a cell with conditional formatting turns to money
https://bugs.documentfoundation.org/show_bug.cgi?id=131524 Oliver Brinzing changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||1717 -- 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 131524] Date format in a cell with conditional formatting turns to money
https://bugs.documentfoundation.org/show_bug.cgi?id=131524 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- 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 131524] Date format in a cell with conditional formatting turns to money
https://bugs.documentfoundation.org/show_bug.cgi?id=131524 Eike Rathke changed: What|Removed |Added Resolution|--- |NOTABUG Status|NEW |RESOLVED --- Comment #6 from Eike Rathke --- The style 'zapłacone' that is applied in the conditional format has the number format set to [$£-809]#,##0.00;-[$£-809]#,##0.00 so that is exactly what is applied. There's nothing wrong. To apply a date format instead, create a style inherited from 'zapłacone' (to inherit for example the green background) and set the desired date format, then in the conditional format manager remove the column F ranges from the currently applied ranges for style 'zapłacone' and create a new conditional format with the same formula that applies the newly created style for dates to column F ranges. -- 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 131524] Date format in a cell with conditional formatting turns to money
https://bugs.documentfoundation.org/show_bug.cgi?id=131524 Oliver Brinzing changed: What|Removed |Added Ever confirmed|0 |1 See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||7715 CC||er...@redhat.com Blocks||87351 Status|UNCONFIRMED |NEW --- Comment #5 from Oliver Brinzing --- reproducible with: Version: 6.3.5.2 (x64) Build-ID: dd0751754f11728f69b42ee2af66670068624673 CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc: but *not* reproducible with: Version: 6.2.8.2 (x64) Build-ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc: setting to "NEW" but I think, this issue is a duplicate of: Bug 117715 - Settings from Conditional formatting should overwrite direct formatting cause cell F3 has a hard cell number format: DD.MM.YY and conditional format: apply cell style "zapłacone" if $I3=0 -> number format: [$£-809]#.##0,00;-[$£-809]#.##0,00 -> background:green with $I3=0 LO 6.2.8.2: green background and DD.MM.YY LO 6.3.5.2: green background and £ https://bugs.documentfoundation.org/show_bug.cgi?id=117715#c12 > So the only solution for consistency seems to be to effectively > revert the fix for 93300 and have all conditional formatting take precedence. > This might be what the majority expects Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=87351 [Bug 87351] [META] Conditional formatting bugs and enhancements -- 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 131524] Date format in a cell with conditional formatting turns to money
https://bugs.documentfoundation.org/show_bug.cgi?id=131524 Maciej changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #4 from Maciej --- As requested mor data to analyze. -- 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 131524] Date format in a cell with conditional formatting turns to money
https://bugs.documentfoundation.org/show_bug.cgi?id=131524 --- Comment #3 from Maciej --- Created attachment 159002 --> https://bugs.documentfoundation.org/attachment.cgi?id=159002=edit spreadsheet for three months Here is part of spreadsheet for three months -- 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 131524] Date format in a cell with conditional formatting turns to money
https://bugs.documentfoundation.org/show_bug.cgi?id=131524 --- Comment #2 from Maciej --- Created attachment 159001 --> https://bugs.documentfoundation.org/attachment.cgi?id=159001=edit spreadsheet for three months Now you can see how it works for three months. I have this file for almost 15 years, never before had problems like that. -- 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 131524] Date format in a cell with conditional formatting turns to money
https://bugs.documentfoundation.org/show_bug.cgi?id=131524 Oliver Brinzing changed: What|Removed |Added Ever confirmed|0 |1 CC||oliver.brinz...@gmx.de Status|UNCONFIRMED |NEEDINFO --- Comment #1 from Oliver Brinzing --- Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. -- 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
