https://bugs.freedesktop.org/show_bug.cgi?id=55071
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected] Ever Confirmed|0 |1 --- Comment #1 from GerardF <[email protected]> 2012-09-19 10:11:38 UTC --- Since 3.6.0 there is a change with INDIRECT function syntax. You can no longer use formula like =ROW(INDIRECT("1:"&ROWS(range))) but you may write complete adresses =ROW(INDIRECT("A1:A"&ROWS(range))) unles you change the option in : Tools > Options > LO Calc > Formula > Detail calculation setting Custom : "Excel A1" instead of "use formula syntax". I set it to NEW (not WORKSFORME) because i don't know why this change and if this change is really usefull. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
