Apache OpenOffice (AOO) Bugzilla – Issue 98014
Validity is broken when pasting sort result with unchecking 'Include formats'
Last modified: 2013-01-29 21:54:10 UTC
Can reproduce it with DEV300m37 on WinXP and Fedora How to reproduce it 1 Open a new Calc document 2 Enter some characters in A1:A3, e.g. test1 test2 test3 and set font styles for the characters 3 Select cells B1:B3, Data - Validity - Allow(Whole Numbers),Data(equal), Value(1) - OK 4 Select A1:A3, Data - Sort, Sort dialog opens, switch to Options tab, uncheck 'Include formats', check 'Copy sort results to' undefined and enter 'B1'; Switch to 'Sort Criteria', Sort by 'Column A' Descending, OK 5 Keep B1:B3 be selected, Data - Validity, pay attention to Ctriteria - Allow Result Validity is broken Expectation Validity stay still when unchecking 'Include formats' Regards Li Meiying