Issue 127644 - data->validity - criteria - sort checkbox will not saved after reopen
Summary: data->validity - criteria - sort checkbox will not saved after reopen
Status: CLOSED DUPLICATE of issue 26928
Alias: None
Product: Calc
Classification: Application
Component: configuration (show other issues)
Version: 4.1.5
Hardware: PC All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-04 10:49 UTC by algroeschel
Modified: 2018-01-05 17:26 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
screenshot of validity dialog (11.84 KB, image/png)
2018-01-04 10:49 UTC, algroeschel 		no flags Details
Excample where sort will not saved. Doc is in Format Excel 97/2000/XP. If this doc will be saved as .ods, the error disappear. (6.50 KB, application/x-ole-storage)
2018-01-05 07:57 UTC, algroeschel 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description algroeschel 2018-01-04 10:49:36 UTC 
Created attachment 86304 [details]
screenshot of validity dialog

Hello,

the check box "sort entries ascending" will not saved after reopen document or restart calc.

Config:
"Allow": Cell range
"Allow empty celles": checked
"Show selection list": checked
"Sort entries ascending": checked but unchecked after reopen of document
                          or restart of calc and open the doc.
"Source": selection of fields eg. B33:B62

Language german, englisch;
OS: XP, W7

It would be fine to fix this issue. After a reopen of the doc I have to set this checkbox on 65 fields bevore I can work with this doc proper.

Best regards,
Andreas
Comment 1 oooforum (fr) 2018-01-04 16:41:26 UTC 
I don't reproduce with AOO 4.1.5 and Win7 x64 Pro
Note that source must contain valid field with sheetname.

Could you provide a sample document?
Comment 2 algroeschel 2018-01-05 07:57:23 UTC 
Created attachment 86305 [details]
Excample where sort will not saved. Doc is in Format Excel 97/2000/XP. If this doc will be saved as .ods, the error disappear.
Comment 3 algroeschel 2018-01-05 08:05:19 UTC 
Hello, it seems that the issue comes with the file fomat Excel 97/2000/XP!
I tried this with my original doc and a brand new sheet with the same result:
   with "Excel 97/2000/XP" format the error is here
   with ".ods" format, the error disappear
For me, I'll change the format to .ods. The Excel format was because of history.
Anyhow, it would be fine when this behaviour will be fixed.
Comment 4 oooforum (fr) 2018-01-05 16:42:45 UTC 
MS interop already reported

*** This issue has been marked as a duplicate of issue 26928 ***