Bug 163216 - [FILESAVE] The position of split view in CALC into 4 panes near a cell is lost when the file is saved as .xlsx and re-opened.
Summary: [FILESAVE] The position of split view in CALC into 4 panes near a cell is los...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.2.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-09-30 12:23 UTC by Savio da Rocha Lobo
Modified: 2025-02-06 12:54 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Savio da Rocha Lobo 2024-09-30 12:23:36 UTC
Description:
I am presently using LibreOffice 24.8.2.1

I have noticed that when using View-Split Window (single horizontal split, single vertical split or double/cross split wingow view) in LibreOfficeCALC it works perfectly, but the problem arises when you save and close the CALC document and re-open the same saved CALC file at a later time, the position SPLIT WINDOW lines is not exactly the way it was, having th split lines in the same cell position when the CALC document was closed earlier. This is noticed more in the double/cross split window view.

Could an adjustment be please made to ensure that a user can see the SAME Split Window position in exactly the same place/cells when re-opening a CALC file ?

This will be of great help. Thank you.

Steps to Reproduce:
1. Choose a cell in an open CALC file
2. Go to VIEW - SPLIT, and the page will show 4 nos. panes after split
3. Save this file and exit.

Actual Results:
When you re-open this saved CALC file, you will see that the position of both the horizintal and vertical split lines are now not around the original cell (as that earlier saved).  They have both moved to some other new position, leaving the user to MANALLY re-align them in the earlier saved lopcation of the split view.

Expected Results:
Once the saved CALC file is re-opened afresh, it is required that the original position of the SPLIT WINDOW lines should be found as exactly the way it was when the CALC filewas earlier saved and closed :- having th split lines in the same cell position when the CALC document was closed earlier. 


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-IN (en_IN); UI: en-GB
Calc: CL threaded
Comment 1 LeroyG 2024-09-30 16:17:54 UTC
I see no problems with:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded

(In reply to Savio da Rocha Lobo from comment #0)
> I am presently using LibreOffice 24.8.2.1

Have you set your first name or last name in the User Data dialog? See in menu Tools - Options - LibreOffice.
Comment 2 BogdanB 2024-09-30 16:34:23 UTC
I can not reproduce on Linux
Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

But should be tested by someone else on Windows, I remember I had a similar problem on Windows, but I am not sure if it was split OR freeze rows/columns.
Comment 3 ady 2024-09-30 18:39:17 UTC
No repro saving as ods on:

Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c3c29d31d77ff93aa50634cfd51c62d12dc0f6ec
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (es_AR); UI: en-US
Calc: threaded

There might be some specific action or factor that might influence the behavior. With the info provided (i.e. nothing specific other than splitting the main area of the spreadsheet), I do not reproduce the behavior with the alpha version I tested.
Comment 4 LeroyG 2024-09-30 19:52:01 UTC
(In reply to Savio da Rocha Lobo from comment #0)
> itthe problem arises when you save and close the CALC

Are you saving as .ods or in another format.
Comment 5 Savio da Rocha Lobo 2024-10-01 06:13:22 UTC
When closing the CALC file, it is saved as an *.xlxs (MS-Excel) format worksheet file.
Comment 6 Savio da Rocha Lobo 2024-10-01 06:21:53 UTC
Sorry that should have read (Excel 2007-365) *.xlsx format
Comment 7 ady 2024-10-01 16:31:36 UTC
No repro when saving as xlsx either.
Comment 8 BogdanB 2024-10-01 19:27:27 UTC
I tried to reset the user profile, I tried to remove my name from Options. I tried saving as XLSX or ODT. No problem.

Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 9 Timur 2025-02-06 12:54:17 UTC
Savio, can you attach sample document? 
Saved XLSX would be good to show the issue, but if you have source ODS that was basis for saving that XLSX, then more likely it can be fixed.