https://bugs.documentfoundation.org/show_bug.cgi?id=99093
--- Comment #8 from raal <[email protected]> --- (In reply to raal from comment #7) > (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) I misread your comment.. -- 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
