https://bugs.documentfoundation.org/show_bug.cgi?id=153214
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Mike Kaganski <[email protected]> --- In Excel, the formula in cell =IF(ISNUMBER(A1); AND(INT(A1)=A1; A1 >= 10; A1 <= 20); COUNTIF({"NC";"ND"}; A1)>0) gives error at entry time: > There's a problem with this formula. > > Not trying to type a formula? > When first character is an equal ("=") or minus ("-") sign, ... and you simply can't have it, until you replace the {"NC";"ND"} with a range reference like C1:C2. Saving a document with such a validation and a cell formula as XLSX from Calc, and trying to open in Excel, gives a warning first: > We found a problem with some content in 'Countif.xlsx'. > Do you want us to try to recover as much as we can? and is confirmed, then > Excel was able to open the file by repairing or removing the unreadable > content. > Removed Feature: Data validation from /xl/worksheets/sheet1.xml part > Removed Records: Formula from /xl/worksheets/sheet1.xml part So it looks like an inherent Excel limitation, and indeed a limitation of its file format. However, it is unclear if the export in this form is satisfactory: it looks like the result is considered invalid - so maybe we need to do something to make it valid (even if this means "to drop content")? -- You are receiving this mail because: You are the assignee for the bug.
