[Libreoffice-bugs] [Bug 122398] New: UI: Cannot specify date in axis scale

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122398

            Bug ID: 122398
           Summary: UI: Cannot specify date in axis scale
           Product: LibreOffice
           Version: 6.2.0.1 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kyrimis at alumni.princeton.edu

Created attachment 147914
  --> https://bugs.documentfoundation.org/attachment.cgi?id=147914&action=edit
Spreadsheet with a chart showing the problem

Version: 6.2.0.1
Build ID: 0412ee99e862f384c1106d0841a950c4cfaa9df1
CPU threads: 2; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: el-GR (en_US.UTF-8); UI-Language: en-US
Calc: threaded

In a chart that contains an axis with a date datatype, the UI does not allow
specifying a minimum or maximum value greater than 09/04/1900 (i.e., April 9,
1900).

E.g., see attached chart.ods. If I uncheck the minimum or maximum value of the
X axis, the corresponding input field will show 09/04/1900, and the spinner
controls will only allow decreasing that value. If I enter a later date by
hand, e.g., 01/01/2019, and hit tab, that date will be changed to 09/04/1900.

This seems to be a UI only issue. If I unpack the ods file, edit the
corresponding content.xml file by hand, adjust chart:minimum to an appropriate
value (e.g., 43466 for 1/1/2019), and repack, the chart scale appears correct,
though LibreOffice still shows 09/04/1900 in the Format Axis dialog, and still
does not allow entering higher values. The same goes for charts that had been
created with previous versions of LibreOffice.

The problem appears with both the gtk and the kde UI.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190101/0dd9e403/attachment-0001.html>