[Libreoffice-bugs] [Bug 52578] New: Incorrect Cell Border Width After FILESAVE/Reload Via .xlsx Format

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Fri Jul 27 11:49:14 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=52578

             Bug #: 52578
           Summary: Incorrect Cell Border Width After FILESAVE/Reload Via
                    .xlsx Format
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.4 release
          Platform: x86 (IA32)
        OS/Version: Windows (All)
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: DaveJakeman at hotmail.com


When a cell border width is set to a non-default value, that value is botched
via a Microsoft XML (.xlsx) filesave/reload.  When ODF format is used, the
border width value is properly preserved.

To reproduce: create a new spreadsheet, set a cell border to a non-default
width, save and reload via MS XML format:

1.  Create a new spreadsheet
2.  Right-click a cell and select "Format cells..."
3.  Click on the "Border" tab
4.  Click on a Line Arrangement button to give the cell some border lines
5.  Click the up-arrow at the right of the "Width" field to give the border a
non-default width.  The value will change from 0.05pt to 0.30pt
6.  Click "OK"
7.  Save the spreadsheet as "Microsoft Excel 2007/2010 XML (.xlsx)" format
8.  Close the spreadsheet
9.  Re-load the spreadsheet

The border width of the cell will now be 1.00pt, not the intended 0.30pt.  With
each successive filesave/reload, the border width increases, up to a maximum of
4.00pt: 0.30pt -> 1.00pt -> 2.50pt -> 4.00pt.

Applying a border width of the default value (0.05pt) gives correct behaviour
after an MS XML filesave/reload.

Following steps 1-9 but using "ODF Spreadsheet (.ods)" format gives correct
behaviour, whatever the width value.

This may be related to Bug 52257.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list