<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc chart loses number formatting on bars when pasted in Writer doc wher shows all decimal parts instead of using original format setting"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142108">142108</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc chart loses number formatting on bars when pasted in Writer doc wher shows all decimal parts instead of using original format setting
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.1.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86 (IA32)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Writer
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>gstr1234@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Pasted bar-chart bar in
Writer shows 4.12345678 while its original in
Calc shows 4.12
A chart which has decimal values shown on bars loses cell level formatting and
shows all decimals in Writer (seems like 4.123456768) instead showing the value
in the original format which was set in Calc (like 4.12) It worked different
way in previous versions.
- In 6.2.0.3 if I have copy pasted a chart from Calc to Writer, decimal value
formatting was the same in Writer. (4.00 was correct too)
- In 6.4.7 the whole numbers are shown without any decimal part but decimal
numbers are shown the same way as they are formatted in Calc.
The correct way would be to show values exactly the same format.
if in Calc
the source value is 4 and value shown on bar is 4.00 Writer must show 4.00
the source value is 4.1234 and value shown on bar is 4.12 Writer must show 4.12
Steps to Reproduce:
1. create a table like this in Calc
col1 col2
row1 4 4.12345678912345
2 format BOTH cells with numeric values to show exactly 2 decimals
(format cells, category "number" options Decimal places: 2)
you should see 4.00 and 4.12
3. create bar chart from data in point 1)
4. right click on chart /EDIT
5. right click on any bar in chart /Insert Data Labels (to show values on bars)
6. click out from chart to leave edit mode
7. copy bar chart to clipboard
8. open new text document from file/New/text document menu
9. paste Chart from clipboard to the text document
Actual Results:
in Writer's text document bar chart bars show "4" and "4.12345678912345"
Expected Results:
to show exactly the same format as it was in Calc on bar chart:
"4.00" and "4.12"
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.1.2.2 (x86) / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
I was informed about this error from other 3 people who could not use my charts
due to this error. I could reproduce it after that on my machine.
I used portable version for error reporting because I need to use the installed
version 6.2.0.3 daily, which does not have this error.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>