https://bugs.documentfoundation.org/show_bug.cgi?id=99093
--- Comment #7 from raal <[email protected]> --- (In reply to Igor Yankovskiy from comment #4) > Created attachment 124088 [details] > data validation that references a cell on the same row, to the left > > (In reply to Tor Lillqvist from comment #3) > > I wonder if there is a similar issue for data validation that references a > > cell on the same row, to the left? Igor, could you please try in Excel 2010 > > to put in cell D5 the same data validation referring to C5, and again save > > as Excel 97-2003 Workbook, and check what Calc says about the D5 validation. > > OK. > C5 value = "55" > D5 validation - Whole number, less than C5. > Save as .xls > > In LibreOffice get Sheet1.IY5 (Sheet1!RC[255]), not Sheet1.C5. > Example in attachment (Refer left.xls). I see D5 = Sheet1.IY5. Igor, see menu Tools> Options> Calc > Formula > formula syntax (mine is "calc A1) -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
