Bug 60045 - FILEOPEN: split information in xls is not preserved
Summary: FILEOPEN: split information in xls is not preserved
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-30 00:19 UTC by csongor
Modified: 2023-02-03 14:29 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
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 csongor 2013-01-30 00:19:28 UTC 
I get xls files quite often which contain many (>100) columns. Therefore my MS office user colleague splits the window: she can see the column A on the left side of the vertical splitter bar and just after there is column U, V, W, etc. She can scroll the columns B, C, ... in the right pane independently from the left part. 

Unfortunately, if I open such a file in LibreOffice then the split information is not preserved so I have to adjust it manually. Moreover, if I save the file again from LO then the split information is forgotten again. 

It seems that LO can not read the splitting information from an XLS file, although it can from an ODS file. It should read it from the XLS as well.
Comment 1 A (Andy) 2013-03-30 08:14:27 UTC 
Do you maybe also have a sample file to attach it to reproduce this?
Comment 2 Urmas 2013-03-30 15:00:41 UTC 
Cannot reproduce it with XLS format. Although there is a bug when changes in split are not saved except manually.
Comment 3 csongor 2013-03-30 16:11:18 UTC 
Well, I tried it again with my present version (3.6.2.2) and it worked fine. 

Unfortunately I do not remember the old version number so I think the bug has been fixed since that time. Thank You.
Comment 4 A (Andy) 2013-04-09 21:03:34 UTC 
marked as resolved