Bug 116308 - issue with percent format
Summary: issue with percent format
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-09 10:12 UTC by Daniel
Modified: 2018-03-10 06:50 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
sample percent issue (8.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-03-09 19:13 UTC, Daniel 		Details
sample percent issue with a formula (9.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-03-09 22:15 UTC, Daniel 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Daniel 2018-03-09 10:12:33 UTC 
Description:
it doesn't show the number if the percent is 0

Steps to Reproduce:
1.write "0" in a cell (without quotation marks)
2.go to cell format
3.use custom format introducing this one: #"%"

Actual Results:  
the result is -> % <-

Expected Results:
it should appear -> 0% <-


Reproducible: Always


User Profile Reset: No



Additional Info:
I can't use a workaround because there is a formula in my cell.


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0
Comment 1 m_a_riosv 2018-03-09 14:41:59 UTC 
Have you disable Menu/Tools/Options/LibreOffice Calc/View - Display - Zero Values?
Comment 2 Daniel 2018-03-09 17:23:01 UTC 
(In reply to m.a.riosv from comment #1)
> Have you disable Menu/Tools/Options/LibreOffice Calc/View - Display - Zero
> Values?

no, that value is active.
Comment 3 m_a_riosv 2018-03-09 18:55:32 UTC 
Then please attach a minimal sample file with the issue.
Comment 4 Daniel 2018-03-09 19:13:54 UTC 
Created attachment 140524 [details]
sample percent issue

here it is
Comment 5 m_a_riosv 2018-03-09 21:16:07 UTC 
With that format code #"%" is normal having zero not visible, # is exactly to hide zeroes.
Comment 6 Daniel 2018-03-09 21:51:43 UTC 
(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.
Comment 7 Daniel 2018-03-09 22:15:30 UTC 
Created attachment 140526 [details]
sample percent issue with a formula

I attach a new simple sample with a formula. Check the result cell.

What steps should I do to get a -> 0% <-
Comment 8 Daniel 2018-03-09 22:37:09 UTC 
ok got it with  0"%" instead of #"%" thanks anyway. you can close the issue.