Bug 39479 - FILESAVE, can't save cell borders width
Summary: FILESAVE, can't save cell borders width
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.2 RC1
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-07-22 10:22 UTC by Oleksandr Kalyniak
Modified: 2012-04-02 18:48 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
1.xlsx (14.93 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2011-07-22 10:22 UTC, Oleksandr Kalyniak 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Oleksandr Kalyniak 2011-07-22 10:22:58 UTC 
Created attachment 49433 [details]
1.xlsx

I have a file (see attachment) and can't to save cells border width.
Steps:
1. File -> Open (1.xlsx);
2. Select cells (A1:L54)
3. Right click -> Format Cells
4. On "Borders" page change "Width" from 2.50pt to 2.00pt.
5. Hit "OK" button.
6. File -> Save.

7. File -> Open (1.xlsx);
8. Select cells (A1:L54);
9. Right click -> Format Cells;
10. On "Borders" page "Width" is still 2.50pt.

P.S.
I'm using LO 3.4.2 RC2 on Windows 7 Ultimate x64.
Comment 1 noname 2011-07-24 07:30:30 UTC 
Confirmed with [Win2K LibreOffice 3.4.2 OOO340m1 (Build:202)].
Happens with Microsoft 2007 XML and Openoffice XML.

Not only is the width gone, but the rest too. Including 'Line Arrangement', 'Style', 'Color', 'Shadow style position' and 'Distance' (some more ?).
Comment 2 Jeffrey 2011-07-24 19:59:53 UTC 
Reproduced on LibreOffice 3.4  340m1(Build:103) for OpenSuse Linux. I tried to reproduce this under an .ods file created originally in calc and there were no problems. When downloading the attachment and reproducing the errors, it seems like the borders problem persists. 

So from my guess this problem has to do with importing an excel file into calc, in which case the format settings are not changed.
Comment 3 Björn Michaelsen 2011-12-23 12:20:40 UTC 
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 4 Oleksandr Kalyniak 2011-12-27 07:53:11 UTC 
LibreOffice 3.5.0 beta2

The bug still persists.
Comment 5 Markus Mohrhard 2012-04-01 17:12:03 UTC 
Can you check with a master build. It should be gone there.
Comment 6 Markus Mohrhard 2012-04-02 18:48:23 UTC 
It is even more easy.

This is not a bug because xls and xlsx only support a limited range of border types. Hair, thin, medium and thick. So saving the border like that means that we need to map our more complex border types to the limited functionality offered by xls/xlsx.