Bug 163751 - FILESAVE Save as .xlsx does not save Data Sort Sort Options Headers setting
Summary: FILESAVE Save as .xlsx does not save Data Sort Sort Options Headers setting
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Sorting
  Show dependency tree / graph
 
Reported: 2024-11-03 14:24 UTC by gktcgcvqci
Modified: 2024-11-26 06:46 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample Spreadsheet Where Bug Occurs (112.54 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-11-04 00:47 UTC, gktcgcvqci 		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 gktcgcvqci 2024-11-03 14:24:17 UTC 
Save as... (*.xlsx) does not save Data Sort Sort Options Headers setting of "Range Contains Column Labels".  Must re-select every time Calc file is opened.
Comment 1 m_a_riosv 2024-11-03 22:10:35 UTC 
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Comment 2 gktcgcvqci 2024-11-04 00:47:35 UTC 
Created attachment 197382 [details]
Sample Spreadsheet Where Bug Occurs

Open Sample.xlsx

On "Full Club" Sheet Sort Selected Columns by "Last Name" with "Range Contains Column Names" checked.

Save (Select Use 2007-365 Format)

Close

Reopen

"Range Contains Column Names" Check no longer there.
Comment 3 m_a_riosv 2024-11-04 12:15:33 UTC 
Reproducible
Version: 24.8.3.1 (X86_64) / LibreOffice Community
Build ID: 65412f067af443213e726c93f137ccc85c9a1e06
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 4 raal 2024-11-04 16:26:44 UTC 
Repro Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)