[Libreoffice-bugs] [Bug 116308] issue with percent format
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Fri Mar 9 21:51:43 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=116308
Daniel <d.noguero at hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |UNCONFIRMED
Resolution|NOTABUG |---
Ever confirmed|1 |0
--- Comment #6 from Daniel <d.noguero at hotmail.com> ---
(In reply to m.a.riosv from comment #5)
> With that format code #"%" is normal having zero not visible, # is exactly
> to hide zeroes.
Please don't close the issue. I need a solution. This issue is related with
other one that I opened a time ago.
I need to put the "%" sign in a cell. This cell contains a formula to calculate
the percent of a value, i can't declarate the cell as % because it recalculate
my value. So the only solution is to format the cell with this value -> #"%" to
add the % sign.
Maybe sounds stupid that you don't want to see the value of 0 in a percent but
in that cell I calculate the benefit of something, so if the value is 0, I need
to see the 0%.
If you consider is not a bug, please I really apreciate if you could tell me
what steps should I follow to see the 0 value with the percent sign without
recalculate the value, and without decimals.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180309/3a02b2d6/attachment.html>
More information about the Libreoffice-bugs
mailing list