[Bug 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 Buovjaga changed: What|Removed |Added Status|NEW |UNCONFIRMED CC||ilmari.lauhakangas@libreoff ||ice.org Ever confirmed|1 |0 --- Comment #11 from Buovjaga --- Back to unconfirmed as wontfix was proposed. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 BogdanB changed: What|Removed |Added Blocks||108252 CC||buzea.bog...@libreoffice.or ||g Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108252 [Bug 108252] [META] Cell-related bugs and enhancements (including formatting) -- You are receiving this mail because: You are the assignee for the bug.
[Bug 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 Armondo Lopez changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #10 from Armondo Lopez --- Thank you for reporting the bug. I can confirm that the bug is present in Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded as well as Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 --- Comment #9 from Mike Kaganski --- The user-visible problem is: having a number like 0.001; formatting it as a number with two decimals, would show "0.00", while formatting is as a currency, would show -$0.00. But the formatting code is completely different. And this is the correct behavior. The format string used for "number with two decimals" is "0.00", which uses a single section (sub-format) for all cases. In this case, the code is able to do the magic - find out how many decimals to show from the subformat, round, find out the sign of the rounded result, and display it. The format string used for "currency" is like "[$$-409]#,##0.00;[RED]-[$$-409]#,##0.00". And it uses two sections: one for positive numbers, and one for negative numbers. Since there are two sub-formats without explicit conditions, the code has to decide which sub-format to use *before* processing the number: because nothing prevents a user to use, say, 10 decimals in negative sub-format, but only 2 decimals in positive. So it checks the sign of the *original* number (not of rounded-to-number-of-decimals); and after that, no rounding result can affect the choice of the sub-format again - it will use the "[RED]-[$$-409]#,##0.00" format string for the rounded result of 0. The format code like "[>-0.005][$$-409]#,##0.00;[RED]-[$$-409]#,##0.00" could do the job. But I think that making such a string as a default is not good. WONTFIX IMO. https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 --- Comment #8 from Robert Lacroix --- (In reply to Jean-Baptiste Faure from comment #7) > I reproduce, but I prefer, in your steps to reproduce, the behavior for > currency to the behavior for general numbers. -0,00€ shows that the value is > not strictly equal to zero, where 0,00 does not. The minus sign make easier > to understand why, if you multiply this zero value by 1, you get a non > zero value. > > Best regards. JBF A sign debugging tool would be a good undertaking, but to be useful and consistent, positive numbers displaying as 0 should also show their sign as well, i.e. display as +0,00. If I want a debugging tool in my spreadsheet, I prefer that this be a controllable option. Furthermore, do not confound the debugging tool with a display convention for signed numbers. I suggest appending the sign debugging indicator on the right side of 0, so 0- or 0+. If the sign debugging tool is off, just display 0 without a sign as the title suggests, as this might be a report published for public consumption. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 Jean-Baptiste Faure changed: What|Removed |Added Severity|normal |enhancement -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 Jean-Baptiste Faure changed: What|Removed |Added CC||jbfa...@libreoffice.org --- Comment #7 from Jean-Baptiste Faure --- I reproduce, but I prefer, in your steps to reproduce, the behavior for currency to the behavior for general numbers. -0,00€ shows that the value is not strictly equal to zero, where 0,00 does not. The minus sign make easier to understand why, if you multiply this zero value by 1, you get a non zero value. Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 Xisco Faulí changed: What|Removed |Added CC||er...@redhat.com, ||xiscofa...@libreoffice.org --- Comment #6 from Xisco Faulí --- @Eike, I thought you might be interested in this issue -- 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 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 --- Comment #5 from Robert Lacroix --- re: can someone tell me in which universe "calculation precision as displayed" would even be desirable to use with currency formatting? I might be able to answer my own question. Stock trading platforms carry prices to hundredths of cents so if you want to match the settlement amounts with a spreadsheet then you might want to set the calculation precision to round at 4 decimals, rather than use the ROUND(). Still that's a global setting. I might want that to use that in one or two spreadsheets, but certainly not for all of them unless I happen to be a stock broker. -- 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 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 --- Comment #4 from Robert Lacroix --- (In reply to m.a.riosv from comment #2) > The only approximation it's to set up the option: > Menu/Tools/LibreOffiace calc/Calculate - General calculation - Precision as > show. > So you can avoid the ROUND() function. That's an interesting suggestion, but it doesn't work: -.0001 still displays as -$0.00 in currency format. What's more, the proposed cure is worse than the disease. With 2 decimals of calculation precision, apportioning a $10,000.00 expense into parts rounds the parts to the nearest $100.00 And "calculation: precision as shown" is a global setting, not a file setting. This suggestion would be pretty deleterious to a beginner and it's a sneaky way to damage a bunch of financial spreadsheets. Good thing I've got > 40 years professional experience with computers. I can understand this as a misguided attempt to help Engineers work with significant figures, but can someone tell me in which universe this setting would even be desirable to use with currency formatting? I am not trying to avoid using the ROUND() function where it's appropriate. I want calculations to use full machine precision for multiplication and addition, and to round values for display purposes. I think someone did not read the title. It says the format should DISPLAY a -$0.00 value without a minus sign. ROUND() is just a workaround for this display artifact. -- 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 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 --- Comment #3 from Robert Lacroix --- (In reply to Uwe Auer from comment #1) > The whole request is in fact requesting a change of values by formatting and > as a user I'd completely disagree with such approach. I agree that a change of values an unreasonable request, which is why I did not request a change of values. I requested a change of formatting to be consistent with the way Format as Number works. The number does not change. Multiplying a small number (displaying as zero due to formatting) by a large number produces a nonzero value when the product becomes larger than a value which rounds to zero. I am just saying to ditch the minus sign when the result displays as zero in currency format with whatever number of decimals you choose. -- 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 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- The only approximation it's to set up the option: Menu/Tools/LibreOffiace calc/Calculate - General calculation - Precision as show. So you can avoid the ROUND() function. -- 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 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
https://bugs.documentfoundation.org/show_bug.cgi?id=138872 --- Comment #1 from Uwe Auer --- The whole request is in fact requesting a change of values by formatting and as a user I'd completely disagree with such approach. -- 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