Bug 152580 - Unpredictable behavior of axis automatic scale
Summary: Unpredictable behavior of axis automatic scale
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2022-12-18 17:35 UTC by jeanmarcranger
Modified: 2022-12-18 23:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
bug example (17.28 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-12-18 17:35 UTC, jeanmarcranger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description jeanmarcranger 2022-12-18 17:35:02 UTC
Created attachment 184224 [details]
bug example

Steps to reproduce:
- Starting with the attached autoscale.ods
- Note that the initial y-axis scale goes from 60000 to 90000
- Enter 1 (or alarger number) in the empty B5 cell.
- Note that the y-axis scale is now 0 to 90000

Expected behavior:
- While the current behavior is not "incorrect" (since AFAICT the behavior of "automatic scaling" isn't defined), I wouldn't expect such a small change in the input to affect the graph in a so dramatic fashion. My preference would be to still have the original 60000 to 90000 scale.
- In the original calc sheet on which this bug was detected, the "starting" value (i.e. B2) varies widely, so having to manually set the Y-axis autoscale minimum is not convenient.
Comment 1 m_a_riosv 2022-12-18 23:18:24 UTC
Reproducible, it's an strange behavior calculating the min, also happens modifying other cells. In example, introducing 2000 in B8.

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9b46020c262045aed0beace4708565235c2523cc
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 2 m_a_riosv 2022-12-18 23:20:49 UTC
Also the issue with
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 3 Stéphane Guillou (stragu) 2022-12-18 23:52:22 UTC
Very much related to bug 43983, which looks at improving the documentation.