Description: Using calc I can't just add the sign percent without calcule the new number. Steps to Reproduce: 1. Write a decimal number 2. Try to add % sign (in all ways) 3. it always add 2 more decimals Actual Results: it add always 2 decimals, but I just stablish that cell with percent format, not to calculate new operation. Expected Results: Should have an option to not modify the decimals and just add the % sign I tried in format cell section with not results I tried in deleting decimals button when Percent button is activated, nothing. If I select that cells as percent format, at least, should remove the decimals, but I can't or just add the % sign without to do anymore. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:56.0) Gecko/20100101 Firefox/56.0
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone else confirms it.
(In reply to Xisco Faulí from comment #1) > You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone > else confirms it. sorry, my bad, it's the first time I use bugzilla
reproduce with Version: 6.0.0.0.alpha0+ Build ID: 141fe1c5e7fbf67a083b34e49e19b6ea78a0eb2b CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 5.4.3.0.0+ Build ID: cc70f137cd853bc22281edb94f15ebe48da871e7 CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 5.3.8.0.0+ Build ID: a0fae00a2d52960eebbb14f08d2de251e0a8ff3f CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:libreoffice-5-3, Time: 2017-10-05_05:58:12 Locale: nl-BE (en_US.UTF-8); Calc: group Version: 5.3.1.2 Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2 CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; Locale: nl-BE (en_US.UTF-8); Calc: group
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3db8059cd92545a618e6ec349b090b569c60847d Resolves: tdf#112891 give restart dialog a parent It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I just tried, it works if you put a normal number in a cell and you add the % sign, but it doesn't if in this cell there is a function before. So imagine there is a SUM in B2 which I want to put that number in percent, but I don't want to calculate the percent of that, because that value is the percent itself and I just want to add the % sign. Any solution?
Hi Caoĺán, Is your commit intended to fix this issue or is it just a typo in the commit message ?
Hello! I am a newbie in bug fixing, Can please help me in fixing this bug?
@Daniel =SUM(A1/A2)&"%" this can help ==> about your question in comment5 or you can use cell formatting
(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 :(
Created attachment 139224 [details] screenshot user defined cell formatting @Daniel Ok the solution i provided is not a good one, but with direct cell formatting you can have the result you want. Select a cell and ctrl+1. You will the have the format cell dialog. On the tab number in category number and select the options decimal places, set 2. In the format code place something like #,##" %". See the screenshot.
(In reply to Daniel from comment #9) > =100-(H29*100/K29) that gives me the percent number (without the percent > sign). That result is 25,25 To only display that number with an appended percent sign you can use a number format such as 0,00"%" or #,##" %" as indicated by Xavier. Note the enquoted percent sign which makes it a string without Otherwise change your calculations to actually calculate in percentages by simply adding the % percent operator, so =(100-(H29*100/K29))% which divides the result by 100 and if the cell has the General format also automatically applies the percent number format
Thank you Xavier, that answer worked perfect for me. (Sorry for not have answered before, I'm having problem with the notifications despite I've indicated not to mark them as spam) Is it possible to add this solution prefixed to the formating cell window? It would be more comfortable for other users, instead of writing the format code.