https://bugs.documentfoundation.org/show_bug.cgi?id=112891
--- Comment #9 from Daniel <d.nogu...@hotmail.com> ---
(In reply to Xavier Van Wijmeersch from comment #8)
> @Daniel
>
> =SUM(A1/A2)&"%" this can help ==> about your question in comment5 or you can
> use cell formatting
Formating cells sucks with percent because it doesn't reduce decimals up to get
1 or 2.
The formula that I have in the percent cell is:
=100-(H29*100/K29) that gives me the percent number (without the percent sign).
That result is 25,25 if I add to the formula 100-(H29*100/K29)&"%" it gives me
25,2513275617276% which is not practical at all, so the temporal solution that
I'm using is to write in the right cell the % sign and align to the left, but
that's not profesional at all.
you can check that it's impossible to delete a decimal if you press the button
delete decimals, and also in formatting cells.
I'm still waiting a nice solution :(
--
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