[Libreoffice-bugs] [Bug 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

--- Comment #12 from Daniel  ---
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.

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

Eike Rathke  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |NOTABUG

--- Comment #11 from Eike Rathke  ---
(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

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

--- Comment #10 from Xavier Van Wijmeersch  ---
Created attachment 139224
  --> https://bugs.documentfoundation.org/attachment.cgi?id=139224=edit
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.

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

--- Comment #9 from Daniel  ---
(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

[Libreoffice-bugs] [Bug 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

--- Comment #8 from Xavier Van Wijmeersch  ---
@Daniel

=SUM(A1/A2)&"%" this can help ==> about your question in comment5 or you can
use cell formatting

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

--- Comment #7 from saran.chava...@gmail.com ---
Hello! I am a newbie in bug fixing, Can please help me in fixing this bug?

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

--- Comment #6 from Xisco Faulí  ---
Hi Caoĺán,
Is your commit intended to fix this issue or is it just a typo in the commit
message ?

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

--- Comment #5 from Daniel  ---
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?

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

--- Comment #4 from Commit Notification 
 ---
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.

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:6.0.0

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

Xisco Faulí  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

--- Comment #3 from Xavier Van Wijmeersch  ---
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

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

--- Comment #2 from Daniel  ---
(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

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

Xisco Faulí  changed:

   What|Removed |Added

 Status|NEW |UNCONFIRMED
 CC||xiscofa...@libreoffice.org
 Ever confirmed|1   |0

--- Comment #1 from Xisco Faulí  ---
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.

-- 
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 112891] Add percent sign to a cell without recalculation

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112891

Daniel  changed:

   What|Removed |Added

Summary|Percent sign without|Add percent sign to a cell
   |operates|without recalculation

-- 
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