[Libreoffice-bugs] [Bug 142108] New: Calc chart loses number formatting on bars when pasted in Writer doc wher shows all decimal parts instead of using original format setting

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142108
           Summary: Calc chart loses number formatting on bars when pasted
                    in Writer doc wher shows all decimal parts instead of
                    using original format setting
           Product: LibreOffice
           Version: 7.1.2.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gstr1234 at gmail.com

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210505/19020924/attachment-0001.htm>