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 :).
Reproduced in Version: 5.4.0.0.alpha0+ Build ID: 1670cc25bc2771e87f7956a4b0dd634abaa4128b CPU threads: 4; OS: Linux 4.8; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group and LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
The bug seems to be in XclExpCellTable::XclExpCellTable( const XclExpRoot& rRoot ). http://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xetable.cxx#2437 This is where validation data is collected: if( ScfTools::CheckItem( rItemSet, ATTR_VALIDDATA, false ) ) http://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xetable.cxx#2641 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 ***