ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
https://www.onlyoffice.com
Other
2.77k stars 320 forks source link

Spreadsheet: Y-axis shifts to the right of graph when `Values in reverse order` is checked. #1150

Closed HectorB-2020 closed 1 year ago

HectorB-2020 commented 1 year ago

This issue is unique.

Operating System

Windows 10 / 8.1 / 7

Version information

7.2.1.36

Expected Behavior

I'm accustomed to behaviour when Y-axis always stays on the left side even after I've checked 'Values in reverse order'.

Actual Behavior

Was that a wrong assumption to expect the vertical axis to be on the left side of graphs? I apologies for submitting this issue if this is "by design". Anyway, when I choose 'Values in reverse order',

OO-V-axis2

the Y-axis moves to the right:

OO-V-axis1

Reproduction Steps

No response

Additional information

No response

VladimirProkofiev52 commented 1 year ago

Hello!, @HectorB-2020 The behavior you describe is normal. The zero points of the X-axis and the Y-axis must converge in one place. If you apply 'Values in reverse order' to the X-axis only while leaving the Y-axis on the left. You get two zero marks: at the beginning and end of the X axis - This will be an error.

For example, in the MS Excel, the behavior is similar to ours editor.

HectorB-2020 commented 1 year ago

Thanks very much for checking! In this case I don't see a reason to keep this issue open any longer.