Bug 99306 - Spacing to contents reset when saving XLS
Summary: Spacing to contents reset when saving XLS
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks:
 
Reported: 2016-04-14 18:44 UTC by foxtrot
Modified: 2018-06-27 12:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
file with that problem (6.50 KB, application/vnd.ms-excel)
2016-04-18 18:04 UTC, foxtrot 		Details
another one... (6.50 KB, application/vnd.ms-excel)
2016-04-23 08:22 UTC, foxtrot 		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 foxtrot 2016-04-14 18:44:11 UTC 
cell spacing is set to 0,71mm automatically at some actions - that might be just moving cells by drag&drop.
It doesn't happen in a new file I just created for tests - of course... I can provide a file, if necessary

Most interestingly, the left/ source cells after moving cells get this format, not the target cells!

It is a rather new phenomenon to me, maybe just some months.

Possible influences: usually I use .xls format to be able to open it on a PC with MS Office with minimum problems, and I edit the files there usually as well.

I see similar bug reports (but not really solutions there), so maybe this is another piece to the whole picture to finally solve it...
Comment 1 Call_me_Tom 2016-04-17 19:41:21 UTC 
(In reply to foxtrot from comment #0)
> cell spacing is set to 0,71mm automatically at some actions - that might be
> just moving cells by drag&drop.
> It doesn't happen in a new file I just created for tests - of course... I
> can provide a file, if necessary
> 
> Most interestingly, the left/ source cells after moving cells get this
> format, not the target cells!
> 
> It is a rather new phenomenon to me, maybe just some months.
> 
> Possible influences: usually I use .xls format to be able to open it on a PC
> with MS Office with minimum problems, and I edit the files there usually as
> well.
> 
> I see similar bug reports (but not really solutions there), so maybe this is
> another piece to the whole picture to finally solve it...

Can you provide a screenshot and the file?
Comment 2 raal 2016-04-18 15:00:24 UTC Comment hidden (obsolete)
Comment 3 foxtrot 2016-04-18 18:04:23 UTC 
Created attachment 124474 [details]
file with that problem
Comment 4 foxtrot 2016-04-18 18:06:58 UTC 
see attached a file with that problem. (there is nothing confidential in it - just some tips for nice restaurants around here ;)

It appears that all xls-files I just tried have that problem (and all of them I might have edited in MS Office), but not an ODS file I just tried.
Comment 5 foxtrot 2016-04-23 08:22:16 UTC 
Created attachment 124585 [details]
another one...

in this file, I just transferred the format from one cell to another, and the target line got more height
Comment 6 Buovjaga 2016-05-03 10:55:21 UTC 
(In reply to foxtrot from comment #3)
> Created attachment 124474 [details]
> file with that problem

So what should we do with this? The cell spacing is already 0,71mm in all the cells.
I do notice when selecting cells and dragging and dropping them somewhere, the source cells somehow refresh, like they were not displaying the 0,71mm spacing before.

64-bit, KDE Plasma 5
Build ID: 5.1.2.2 Arch Linux build-1
CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Comment 7 foxtrot 2016-05-03 14:50:23 UTC 
Hello Buovjaga!

Thank you for that hint. As you ask, what you should do: set the spacing to 0,5, save and reopen - it will be 0,71 again. That's the problem.
Comment 8 Buovjaga 2016-05-04 07:09:15 UTC 
Ah, I thought we had to drag and drop something.

Now I reproduce with the file.

Win 7 Pro 64-bit Version: 5.2.0.0.alpha1+
Build ID: e76d458422b0f0f713cc17bf47ca94c33ac570a7
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-05-03_06:32:27
Locale: fi-FI (fi_FI)

LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Comment 9 foxtrot 2016-05-05 09:20:26 UTC 
now, knowing this effect better (it doesn't need drag&drop, that just triggers the refresh), I just created a new file, saved it as xls, reopened it, and voila - 0,71mm. Not the same with ods. It's not necessary to edit it on a PC in MS-office, it's right in Libreoffice.

I seem to forgot to mention that i work on Mac - don't know if this is relevant here...
Comment 10 QA Administrators 2017-05-22 13:39:07 UTC Comment hidden (obsolete)
Comment 11 foxtrot 2017-05-22 17:18:32 UTC 
Hi there!

The problem changed a little:
Now (version 5.0.x and 5.3.3) the cell spacing is now 0,45cm (standard) when I open the file. When I edit something (e.g. move contents) the source line is changed to 0,52cm. That is still only in xls-files, not in ods and not in xlsx.
(but xls is still the format with the least compatibility problems...)

Mac OS X 10.9.5

Best regards,
foxtrot
Comment 12 QA Administrators 2018-05-23 02:35:33 UTC Comment hidden (obsolete)
Comment 13 Buovjaga 2018-06-27 12:52:34 UTC 
In bug 118245 the reporter came back to inform that Excel's formats are limited regarding this and there is nothing we can do. Thus closing.