[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.documentfoundation.org/show_bug.cgi?id=82765 --- Comment #11 from bradly --- So we can't actually do anything about this? It's not very intuitive from my point of view. ,https://www.lasvegas.es/ -- 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 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.documentfoundation.org/show_bug.cgi?id=82765 Kevin Suo suokunl...@126.com changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC||suokunl...@126.com Resolution|--- |NOTABUG --- Comment #10 from Kevin Suo suokunl...@126.com --- This is NOTABUG, but is the expected behaviour. For attachment 104815, althrough the Column A is formatted as 0.0, but when you go to Format - Conditional Formatting - Manage - A1:A1048573, you will see that if the condition is met then style Untitled3 is used. Further when you go to style management dialog, you will see that for style Untitled1, numbers are mannually formatted as # ### ### ### ### ##0. Because of this, the numbers should truely be formatted as 0 decimal place. If you set the number format of Untitled1 to General, the decimal places for Column A would be as you expected. Set as NOTABUG. Please set back to UNCONFIRMED is someone disagree. Thanks. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.freedesktop.org/show_bug.cgi?id=82765 --- Comment #8 from Renato Ferreira renato.w...@gmail.com --- I could replicate the behaviour described in the attachment above. My understanding is that non-canonical user-defined styles are, first, identified as number styles, and those are defined in the code by the set: (flag) show thousand separator, (flag) show red negative numbers, (int) precision, (int) leading zeroes. Then when the user tries to edit their strange style (in this case containing spaces, but could be any characters) using the UI selectors, basically those variables get changed accordingly, but a new, canonical style is generated instead (thus without the user-defined features). I propose that, since those strange styles could be really anything, to disable the UI selectors if the user is defining one of those non-canonical styles. That is, a style such as #0mysep.00 can be defined and works, but the user is not led into trying to edit the style using the UI selectors, just to have it broken as described. If, however, the user defines a canonical style such as 0., they still get to edit it using the UI elements normally. I have prepared a patch that causes this behaviour, in case anyone would like to give it a try. The only issue is that I am not sure, at the moment, how to do the same in the sidebar style selector. I looked at the code and it seems very detached from the rest, only receiving a few variables, and it seems not to have access to the format string itself, which would be necessary to induce the same behaviour. If you think this is a good solution, I would welcome directions on how to deal with the sidebar issue. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.freedesktop.org/show_bug.cgi?id=82765 --- Comment #9 from Renato Ferreira renato.w...@gmail.com --- Created attachment 110275 -- https://bugs.freedesktop.org/attachment.cgi?id=110275action=edit Patch with possible behaviour -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.freedesktop.org/show_bug.cgi?id=82765 --- Comment #5 from bugquestcon...@online.de --- I made another test using the same LibO version and OS but could not reproduce the bug I observed first. When I reported the bug it really was bothering me. Now it work almost like I expected. Example is attached. However I observed something with changing of a customized format when increasing the number of decimal places. All is described with screen shots in the attached Writer files. This file also contains thoughts about expectations from my side. But as I don't know the specifications, I cannot make a statement in respect it is a bug or an enhancement request. Please have a look and advice. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.freedesktop.org/show_bug.cgi?id=82765 --- Comment #6 from bugquestcon...@online.de --- Created attachment 106983 -- https://bugs.freedesktop.org/attachment.cgi?id=106983action=edit second example file - bug was not observed -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.freedesktop.org/show_bug.cgi?id=82765 --- Comment #7 from bugquestcon...@online.de --- Created attachment 106984 -- https://bugs.freedesktop.org/attachment.cgi?id=106984action=edit observations about conditional and customized format and decimal places -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.freedesktop.org/show_bug.cgi?id=82765 Markus Mohrhard markus.mohrh...@googlemail.com changed: What|Removed |Added CC||markus.mohrhard@googlemail. ||com --- Comment #4 from Markus Mohrhard markus.mohrh...@googlemail.com --- I don't see a bug here. If the conditional format is applied you get the number format from the CF style. The Format Cells dialog only shows hard formatting (which might be overwritten by conditional formatting). The hierarchy is: conditional formatting, hard formatting, style. The formatting is taken from the first hit and in your case it is the conditional formatting. I have no idea how you think that we should apply the hard formatting despite the conditional formatting (which specifies a number formatting as well) being applied -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.freedesktop.org/show_bug.cgi?id=82765 bugquestcon...@online.de changed: What|Removed |Added Severity|normal |blocker Priority|medium |highest -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.freedesktop.org/show_bug.cgi?id=82765 --- Comment #1 from ign_christian ign_christ...@yahoo.com --- Hi.. I can't reproduce from scratch in LO 4.2.6.2 - Ubuntu 12.04 x86. In your attached file, style used in particular CF is screwed up. For example, style Untitled3 has number format # ### ### ### ### ##0 Could you give steps to repro from scratch? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.freedesktop.org/show_bug.cgi?id=82765 ign_christian ign_christ...@yahoo.com changed: What|Removed |Added Severity|blocker |normal --- Comment #2 from ign_christian ign_christ...@yahoo.com --- Lowering the importance to normal until problem identified -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 82765] FORMATTING: Conditional formatting changes digits behind the decimal point
https://bugs.freedesktop.org/show_bug.cgi?id=82765 --- Comment #3 from bugquestcon...@online.de --- I looked again into the file I attached yesterday and found that in style Untitled 1, 2, and 3 the number format was messed up like you described it (# ### ### ### ### ##0) When I created the attached test file I did the following - Select column - right click select Format cell Numbers - set format to 0.0 - clicked OK - selected column - Format Conditional format conditions - select condition (e. g. greater than) - select New Style Background select ONLY a color OK - added second and third CF the same way - clicked OK I did NOT look into the number format when I created a New Style I only checked Number Format by right clicking to the cell Format cells Numbers and there it was always - even after applying the new style Untitled - as set (0.0) I just repeated the above described procedure again and got the same result. With your hint about the number format in Untitled format I looked into the Untitled Style Modify Numbers Decimal Place = 1 and then all cells with this format show correct format 0.0. For my understanding the bug is now that the number format first applied to a cell remains when it is checked by right clicking to a cell and go Format Cells Numbers but in reality the format from the CF is applied but not visible when checking the applied format directly at the cell by right clicking and go Format Cells Numbers. Side note on importance settings: You have more experience, thus just go ahead. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
