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

             Bug #: 44550
           Summary: FILEOPEN: Cell double boders are lost after save and
                    reopen spreadsheet
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.0 Beta2
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: [email protected]
        ReportedBy: [email protected]


Created attachment 55244
  --> https://bugs.freedesktop.org/attachment.cgi?id=55244
A screen capture of the two cells with double-border, at zoom level 115%

Problem description: 
Cell borders with double lines are lost after saving and reopening the
document.
The problem is reproducible also in Libreoffice 3.4.4 (Ubuntu)

Steps to reproduce:
1. Start a new speadsheet
2. Select a cell (e.g. B2), write some text in it (to easily find later in
content.xml) 
3. Select Format, Cells in menu and Borders tab
4. Set the properties exactly in this order (*):
   Line arrangement: Set all four borders,
   Line: Width=1,0pt
   Line: Style: select the 2nd double line (6th entry in the combo box)
5. Press OK
6. Save the file in ods format (test.ods)
7. Close the file
8. Check the content.xml:
   (copy the test.ods to test.zip, open the zip file, find content.xml in
test.zip)
   In content.xml: everything seems OK. The automatic style declaration exists: 
   <style:style style:name="ce1" style:family="table-cell"
style:parent-style-name="Default">
      <style:table-cell-properties fo:border="0.99pt double #000000"
style:border-line-width="0.026cm 0.035cm 0.035cm"/>
   </style:style>

   and the cell (in <office:body>)  refers the style:
   <table:table-cell table:style-name="ce1" office:value-type="string"> 

   So, I think that not the saving but the loading has a bug.

9. Open the file: the cell borders do no exist.
10. Select File, Save As and save into a new file (test2.ods)
11. Check the content.xml in the new file:
   (copy the test2.ods to test2.zip, open the zip file, find content.xml in
test2.zip)
    You will notice there are no border declarations:
    <style:style style:name="ce1" style:family="table-cell"
style:parent-style-name="Default">
      <style:table-cell-properties fo:border="none"/>
      <style:text-properties style:text-position=""/>
    </style:style>


(*) Maybe it is a different problem (but connected to this). If you Set the
properties in this order (in step 4):
   Line arrangement Set all four borders,
   Line: Style: select the 2nd double line (6th entry in the combo box)
   Line: Width=1,0pt
You will notice that with 115% zoom you will see a single-lined border (with
more zoom you will see it's double border - maybe cannot displayed correctly)
but if you save and reopen the file the formatting will remain the same (single
line border) in the content.xml.

See attached image:
Borders of C4 created this way (set style then set width), but C7 created like
Step 4 (set width then set style).
After save, close, reopen the formatting is lost only for C7.


Current behavior:
1. Setting cell border's to the same parameters in different order get
different results (fist line style, then width or first line width then line
style)
2. In the reopened file there is no double border around the cell (if you have
set like in step 4.)

Expected behavior:
1. Setting cell border's to the same parameters should give the same result
2. After reopening all formatting should be the same as when it was saved.


Platform (if different from the browser): 
Linux x86_64 (Ubuntu 11.10) + LO3.5.0beta2;
also tested on Windows 7 (hun) + LO3.5.0beta2

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to