[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