Created attachment 132095 [details]
Validity check missing from A4:A5
I created the attached test XLSX file in LO 5.3.1 on Win7.
First, I set up a few values to choose from in E1:E3.
Then I set up a validity check in A1, to allow a cell range, for worksheet1!E1:E3 as source. Other settings were left on default.
I extended the content of A1 downwards until A5.
After saving and reopening in LO - and in Excel 2013 as well - the validity check is present in A1:A3 but not in A4 and A5.
Created attachment 132096 [details]
The test file in LO 5.3.1 before saving
Could you please attach the document saved as .odt too?
Created attachment 132100 [details]
Same file saved as ods
Sure, in ods the A4, A5 cells can be saved and opened just fine - it opens correctly even in Excel :).
Build ID: 1670cc25bc2771e87f7956a4b0dd634abaa4128b
CPU threads: 4; OS: Linux 4.8; UI render: default; VCL: gtk3;
Locale: ca-ES (ca_ES.UTF-8); Calc: group
The bug seems to be in XclExpCellTable::XclExpCellTable( const XclExpRoot& rRoot ).
This is where validation data is collected:
if( ScfTools::CheckItem( rItemSet, ATTR_VALIDDATA, false ) )
However, the large loop in that function ends with the last row where there's data, and in this case there's no more data in rows 4-5, so they aren't considered: the application exits the loop before being able to take care of the validation data there.
*** This bug has been marked as a duplicate of bug 41425 ***