Bug 117409

Summary: Graph zero displayed as exponential notation (2,2E-16) if Y-axis is formatted to have max scale of 0,8
Product: LibreOffice Reporter: heiko
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: minor CC: ilmari.lauhakangas, jalojo, xiscofauli
Priority: medium    
Version: Inherited From OOo   
Hardware: x86-64 (AMD64)   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 90486    
Attachments: zero bug
ods file with zero bug
chart View on Windows 7
zero bug (only one graph)
zero bug (new graph 5.5 6.0 6.1)
ods file with zero bug (3th version)
zero bug (libreoffice 7.1.1.2)
Zero bug with Version 7.4.5.1

Description heiko 2018-05-03 12:57:37 UTC
Description:
The zero is displayed strangely in the graph.

Actual Results:  
2,2E-16


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 5.3.4.2
Build-ID: 5.3.4.2-3.mga6
CPU-Threads: 8; BS-Version: Linux 4.14; UI-Render: Standard; VCL: gtk3; Layout-Engine: neu; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0
Comment 1 heiko 2018-05-03 12:58:48 UTC
Created attachment 141867 [details]
zero bug
Comment 2 Jacques Guilleron 2018-05-03 15:06:35 UTC
Hi heiko,

Would you so kind to provide the test file, to be sure we talc about the same thing?
Thank you.
Comment 3 heiko 2018-05-04 06:18:17 UTC
Created attachment 141884 [details]
ods file with zero bug
Comment 4 Jacques Guilleron 2018-05-04 06:56:43 UTC
Created attachment 141886 [details]
chart View on Windows 7

Thank you Heiko,
I set status back to Unconfirmed, since working on Windows 7 with no such displaying.
Comment 5 Xisco Faulí 2018-06-04 13:28:02 UTC
I can't reproduce it in

Version: 6.1.0.0.beta1+
Build ID: b57819201ff89bbde14b4df8c02a0eb4bea2c2bb
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group threaded

Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 6 heiko 2018-06-06 06:43:36 UTC
I was able to reproduce it in Mageia 6 with a new version:

Version: 5.3.7.2.0+
Build-ID: 5.3.7.2-3.mga6
CPU-Threads: 8; BS-Version: Linux 4.14; UI-Render: Standard; VCL: gtk3; Layout-Engine: neu; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group

I'm still trying the 6.0 version.
Comment 7 heiko 2018-06-06 06:52:21 UTC
I can also reproduce it in the 6 version.

Version: 6.0.4.2
Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: de-DE (de_DE.UTF-8); Calc: group
Comment 8 heiko 2018-06-06 07:12:16 UTC
I can also reproduce it in the 6.1 version.

Version: 6.1.0.0.beta1
Build ID: 8c76dfe1284e211954c30f219b3a38dcdd82f8a0
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: de-DE (de_DE.UTF-8); Calc: group

$ ./scalc
LibreOffice(28708)/kdecore (trader) KServiceTypeTrader::defaultOffers: KServiceTypeTrader: serviceType  "ThumbCreator"  not found 
LibreOffice(28708)/kdecore (trader) KServiceTypeTrader::defaultOffers: KServiceTypeTrader: serviceType  "ThumbCreator"  not found 
LibreOffice(28708)/kdecore (trader) KServiceTypeTrader::defaultOffers: KServiceTypeTrader: serviceType  "ThumbCreator"  not found 
LibreOffice(28708)/kdecore (trader) KServiceTypeTrader::defaultOffers: KServiceTypeTrader: serviceType  "ThumbCreator"  not found 
LibreOffice(28708)/kdecore (trader) KServiceTypeTrader::defaultOffers: KServiceTypeTrader: serviceType  "ThumbCreator"  not found 
LibreOffice(28708)/kdecore (trader) KServiceTypeTrader::defaultOffers: KServiceTypeTrader: serviceType  "ThumbCreator"  not found 
LibreOffice(28708)/kdecore (trader) KServiceTypeTrader::defaultOffers: KServiceTypeTrader: serviceType  "ThumbCreator"  not found 
LibreOffice(28708)/kdecore (K*TimeZone*): KSystemTimeZones: ktimezoned initialize() D-Bus call failed:  "No such object path '/modules/ktimezoned'" 

X Error: BadMatch (invalid parameter attributes) 8
  Major opcode: 42 (X_SetInputFocus)
  Resource id:  0x920aece
X Error: BadMatch (invalid parameter attributes) 8
  Major opcode: 42 (X_SetInputFocus)
  Resource id:  0x920aece
Comment 9 Xisco Faulí 2018-06-07 09:12:08 UTC
I can't reproduce it in

Versión: 6.0.4.2
Id. de compilación: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf
Subprocs. CPU: 1; SO: Windows 6.1; Repres. IU: predet.; 
Configuración regional: es-ES (es_ES); Calc: group

either
Comment 10 Buovjaga 2018-06-08 14:00:48 UTC
I confirm.

Jacques: your attachment 141886 [details] is of the other chart. Of course, the reporter should have removed the other chart to avoid confusion.

However, if I recreate the chart with MNO columns, there is no problem.

Heiko: can you try recreating it with 6.x?

Arch Linux 64-bit
Version: 6.2.0.0.alpha0+
Build ID: 67aaa98600269e6b8fa631146c3649a261369471
CPU threads: 8; OS: Linux 4.16; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on June 7th 2018
Comment 11 heiko 2018-06-11 06:35:57 UTC
Created attachment 142646 [details]
zero bug (only one graph)
Comment 12 Buovjaga 2018-06-11 06:39:30 UTC
(In reply to heiko from comment #11)
> Created attachment 142646 [details]
> zero bug (only one graph)

Heiko: it seems you did not understand me. Please use LibreOffice version 6.0 to re-create the chart from scratch.
When I select columns M,N,O and created a line chart like yours, there was no problem with the zero.
Comment 13 heiko 2018-06-11 07:42:53 UTC
Created attachment 142647 [details]
zero bug (new graph 5.5 6.0 6.1)
Comment 14 heiko 2018-06-11 07:47:38 UTC
I created a new graph in the file for versions 5.4, 6.0 and 6.1. The error still occurs in all.

Therefore I selected the first 3 columns. A new graph is generated and the y-axis is set to the maximum of 0.8.

Now the numbers are even outside the graph.
Comment 15 heiko 2018-06-11 07:48:28 UTC
Created attachment 142648 [details]
ods file with zero bug (3th version)
Comment 16 Buovjaga 2018-06-11 09:29:10 UTC
Ok, now we are getting somewhere. It is dependent on changing the max scale to 0,8.

I found this question and the answer to it shows you the solution how to manually correct this: https://ask.libreoffice.org/en/question/26339/strange-y-axis-scale-in-a-chart/

Arch Linux 64-bit
Version: 6.2.0.0.alpha0+
Build ID: 67aaa98600269e6b8fa631146c3649a261369471
CPU threads: 8; OS: Linux 4.16; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on June 7th 2018

Arch Linux 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 17 QA Administrators 2021-03-20 04:41:32 UTC Comment hidden (obsolete)
Comment 18 heiko 2021-03-20 20:59:02 UTC
Tested with (attachment 142648 [details]):

Version: 7.1.1.2 / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: kf5
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded

Error still occurs (see new attachment).

Best regards,
Heiko
Comment 19 heiko 2021-03-20 21:00:25 UTC Comment hidden (obsolete)
Comment 20 heiko 2021-03-20 21:02:21 UTC
Created attachment 170594 [details]
zero bug (libreoffice 7.1.1.2)
Comment 21 QA Administrators 2023-03-21 03:25:22 UTC Comment hidden (obsolete)
Comment 22 heiko 2023-03-21 08:52:28 UTC
The error can still be found in version:

Version: 7.4.5.1
Build ID: 40(Build:1)
CPU threads: 64; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Even if I create a new chart.
Comment 23 heiko 2023-03-21 08:54:11 UTC
Created attachment 186108 [details]
Zero bug with Version 7.4.5.1