Bug 117409 - Graph zero displayed as exponential notation (2,2E-16) if Y-axis is formatted to have max scale of 0,8
Summary: Graph zero displayed as exponential notation (2,2E-16) if Y-axis is formatted...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2018-05-03 12:57 UTC by heiko
Modified: 2023-03-21 08:54 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
zero bug (26.08 KB, image/png)
2018-05-03 12:58 UTC, heiko
Details
ods file with zero bug (99.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-05-04 06:18 UTC, heiko
Details
chart View on Windows 7 (34.04 KB, image/png)
2018-05-04 06:56 UTC, Jacques Guilleron
Details
zero bug (only one graph) (29.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-06-11 06:35 UTC, heiko
Details
zero bug (new graph 5.5 6.0 6.1) (69.83 KB, image/png)
2018-06-11 07:42 UTC, heiko
Details
ods file with zero bug (3th version) (35.51 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-06-11 07:48 UTC, heiko
Details
zero bug (libreoffice 7.1.1.2) (70.62 KB, image/png)
2021-03-20 21:02 UTC, heiko
Details
Zero bug with Version 7.4.5.1 (102.14 KB, image/png)
2023-03-21 08:54 UTC, heiko
Details

Note You need to log in before you can comment on or make changes to this bug.
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