Issue 127644

Summary: data->validity - criteria - sort checkbox will not saved after reopen
Product: Calc Reporter: algroeschel
Component: configurationAssignee: AOO issues mailing list <issues>
Status: CLOSED DUPLICATE QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: knmc, oooforum
Version: 4.1.5   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
screenshot of validity dialog
none
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. none

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 ***