[Libreoffice-bugs] [Bug 132486] New: FILESAVE XLSX Date type X axis columns position appears shifted in Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132486
           Summary: FILESAVE XLSX Date type X axis columns position
                    appears shifted in Excel
           Product: LibreOffice
           Version: 7.0.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: regression
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: balazs.varga991 at gmail.com, nemeth at numbertext.org
            Blocks: 75057

Created attachment 160018
  --> https://bugs.documentfoundation.org/attachment.cgi?id=160018&action=edit
Example file from Excel

If the X axis of a column chart in an Excel-made chart is of Date type, saving
with Calc to XLSX makes the columns appear on the tickmarks instead of between
them.

Steps to reproduce:
    1. Open attached document and save it as XLSX
    2. Reopen the saved document in Excel

Actual results:
Columns are shifted, X axis setting of Axis placement is On tick marks instead
of Between tick marks.

Expected results:
Same appearance as before the roundtrip.

LibreOffice details:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: 60fcd4427231e8c48cd3bf8307e280fd3a13a84f
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL

Started to happen after bug #132076 was fixed.

Adding CC to: Balázs Varga


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=75057
[Bug 75057] [META] OOXML Chart object issues
-- 
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/20200428/e02f95e8/attachment.htm>