[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

Bartosz  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |gan...@poczta.onet.pl
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

Bartosz  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

--- Comment #17 from brucehohl  ---
Yet another round trip test using:
Help > About LibreOffice
Version: 5.1.4.2
Build ID: 1:5.1.4-0ubuntu1~trusty1
CPU Threads: 2; OS Version: Linux 3.13; UI Render: default; 
Locale: en-US (en_US.UTF-8)

Columns widths after each save as xlsx then reopen file:
A  B  C  D  E
1.01   2.01   3.01   4.01   5.01  (starting column widths in inches)
1.04   2.07   3.14.14   5.17
1.08   2.13   3.21   4.29   5.34
1.11   2.23.31   4.42   5.52
1.14   2.27   3.43   4.56   5.7
1.17   2.34   3.53   4.71   5.89

Change in size: 
1.0297029703   1.0298507463   1.0299003322   1.0324189526   1.0319361277
1.0384615385   1.0289855072   1.0354838711.0362318841   1.0328820116
1.027778   1.0328638498   1.0311526481.0303030303   1.0337078652
1.0270270271.0318181818   1.0362537764   1.0316742081   1.0326086957
1.0263157895   1.0308370044   1.0291545191.0328947368   1.03

For Winfried the columns decreased slightly in size.  In my case, using the
LibreOffice version noted, the columns increased by about 3% for each save then
reopen.  Regardless, column width is not preserved.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

Winfried Donkers  changed:

   What|Removed |Added

 CC||winfrieddonkers@libreoffice
   ||.org

--- Comment #16 from Winfried Donkers  ---
(In reply to brucehohl from comment #14)
> Comment on attachment 123503 [details]
> Test-Col-Width.xlsx bug example
> 
> Another write-up / example of this bug.
> 
> 1 Create new file
> 
> 2 Add following content:
>   A1 "aaa", B1 "", C1 "ccc55"
>   E1 "aaa", F1 "", G1 "ccc55"
> 
> 3 Auto size columns A-C and set column width on columns E-G to 0.5 IN.
> 
> 4 Note size of each column in the worksheet.
> 
> 5 Save worksheet in XLSX format then close.
> 
> 6 Reopen and note that column width have increased.
> 
> Each time steps 4-6 are repeated the column widths grow.
> An exception was column D which grew, shrunk, grew.

When a new document is created with column A width of 2.00cm and Column B width
of 5.08cm (2 in.), and then repeatedly saved as xlsx, closed and reopened, the
column widths decrease every time:
Column A  B
2.00   5.08
1.96   5.00
1.93   4.95
1.91   4.89
1.88   4.84

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||v.yuzbe...@yandex.ru

--- Comment #15 from m.a.riosv  ---
*** Bug 100982 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

steve -_-  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||0946

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

   Keywords||filter:xlsx

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

--- Comment #14 from brucehohl  ---
Comment on attachment 123503
  --> https://bugs.documentfoundation.org/attachment.cgi?id=123503
Test-Col-Width.xlsx bug example

Another write-up / example of this bug.

1 Create new file

2 Add following content:
  A1 "aaa", B1 "", C1 "ccc55"
  E1 "aaa", F1 "", G1 "ccc55"

3 Auto size columns A-C and set column width on columns E-G to 0.5 IN.

4 Note size of each column in the worksheet.

5 Save worksheet in XLSX format then close.

6 Reopen and note that column width have increased.

Each time steps 4-6 are repeated the column widths grow.
An exception was column D which grew, shrunk, grew.
See attached worksheet.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

--- Comment #13 from brucehohl  ---
Created attachment 123503
  --> https://bugs.documentfoundation.org/attachment.cgi?id=123503=edit
Test-Col-Width.xlsx bug example

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||sander.k1...@kpnmail.nl

--- Comment #12 from m.a.riosv  ---
*** Bug 97216 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

 CC||robe...@madasafish.com

--- Comment #10 from raal  ---
*** Bug 94266 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

--- Comment #9 from Yousuf (Jay) Philips  ---
I have addressed two different bugs in my two bug reports which have been
placed as duplicates to this bug.

Bug 94255 is about the regression in 5.0 where the column width changed from 8
to 7.86, which had the same bibisect result as found in comment 4.

Bug 94257 is inherited from OOo where the column width was at 8 rather than
being 8.43.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 91475] FILESAVE: Column width is not preserved in XLSX / after round trip.

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

 CC||c...@nouenoff.nl
Summary|FILESAVE: Column width is   |FILESAVE: Column width is
   |not preserved after round   |not preserved in XLSX /
   |trip.   |after round trip.
 Whiteboard||bibisected

--- Comment #8 from Cor Nouws  ---
regression?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs