https://bugs.documentfoundation.org/show_bug.cgi?id=169691
Bug ID: 169691
Summary: Better way of axis scaling in diagrams in LibreOffice
Calc
Product: LibreOffice
Version: 25.8.3.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When you want to chose the scaling of the x and y axis manually in a diagram
using LibreOffice Calc you can only enter a number as minimum and maximum
value. My idea would be adding the ability to use a minimum and maximum number
that is in already entered a cell in the sheet similar to what you do when you
add a new set of data.
F.e. instead of writing 171 as maximum number for the x axis directly you have
a cell where the maximum number of 171 is standing so you would put in
=$'Sheet1'.$A$4. That way you could change the scaling easier without having to
go in the diagram and the axis scaling menu.
That feature would be useful since i'm working a lot with statistical
distribution functions f(n) where n is the number of tries with 2 parameters
being the number of successes k and the hitting probability p. That way it
would automatically scale the x axis depending on k and p so that the maximum
aka the expected value is centered on the x axis of the diagram.
Coding wise the interface should look similar to when you're editing a set of
data.
Steps to Reproduce:
1. Have a diagram of a function in Libreoffice Calc and also have the minimum
and maximum values of both x and y axis in cells in the same sheet
2. Make sure automatic scaling is turned off
3. Go in the axis scaling menu and try to enter the cell instead of the number
under minumum or maximum value. F.e. instead of 171 you enter =$'Sheet1'.$A$4
since in 'Sheet1' cell A4 you entered 171
Actual Results:
After you type =$'Sheet1'.$A$4 and leave the field with the cursor it goes back
to the number it had before since it can't work with that.
Expected Results:
It should read the number entered in 'Sheet1' cell A4 and use that as the
scaling number. If there is not a number in the cell it should give out an
error.
Reproducible: Always
User Profile Reset: No
Additional Info:
None
--
You are receiving this mail because:
You are the assignee for the bug.
