[Libreoffice-bugs] [Bug 131312] New: calc: funny / odd / wrong display of value in scientific format

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131312
           Summary: calc: funny / odd / wrong display of value in
                    scientific format
           Product: LibreOffice
           Version: 6.2.8.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
while playing around with floating point values i stumbled upon a funny display
problem, it looks as if the value is correct, but in display with 14+ decimal
places it's displayed as 

10,00000000000000E+00 instead of - correct - 

 1,00000000000000E+00

the error dosn't survice save-load but is reproducible, just follow steps
below, 

don't think over the formula etc., it's an unfinished version, 

the error can be copied by ctrl-c ctrl-shift-v to other cells, copy text,
numbers, date&time, 

Steps to Reproduce:
1. open attached file (if not in this description see next comment)
2. observe cell BO2, reg. save-load it'll display 1,00000000000000E+00 
2a. same for cell BO4, which is two step copy of BO2 
3. click on cell BO2 
4. F2
5. ctrl-a
6. ctrl-c
7. ctrl-v - enter
8. observe BO2 now displaying 10,00000000000000E+00,that's 10 times too much, 
8a. same for BO4 
8b. BO3 not affected 
9. shrink display of BO2 to 13 decimals
10. observe display now 1,0000000000000E+00
11. enrich display to 14 decimals or more 
12. observe value shown as 10,00... istead of 1,00... 
13. observe cell BO3, formula '=BO2', displaying 1,00000... regardless of wrong
display for BO2, 
14. observe cell BO4 having the same 'illness' as BO2, wrong display up from 14
decimals, 
15. play around as you like, the error occured only for specific mantissae all
zeros ending on ...110 or ...101, sometimes you don't need to paste BO2 but
it's sufficient to change the last two bits of the mantissa ... the behaviour
is a little different with a different formula, copy e.g. BO8 to BO2, have fun
... 

Actual Results:
cells displayed with 10 times too high value and 'ill' formatting up from 14
decimal places, 

Expected Results:
correct results, 


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: 

actual 7.0.0.0.a0+ fails too ...

-- 
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/20200312/34eaa330/attachment-0001.htm>