https://bugs.documentfoundation.org/show_bug.cgi?id=94514
Bug ID: 94514 Summary: Using cell names in fonctions does'nt work if name begin with 3 letters and an underscore Product: LibreOffice Version: 5.0.1.2 release Hardware: x86-64 (AMD64) OS: Linux (All) Status: UNCONFIRMED Severity: major Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: harrycovert...@hotmail.fr When using a cell name beginning with same letters than a real cell address followed by an underscore (ie. matching "[a-zA-Z]{1,3}_.*", "abz_foo1" per example) in a fonction, it's seen as the cell matching the beginning (as "ABZ" per example): "=SUM(baz_begin:baz_end)" is seen as "=SUM(BAZ:BAZ)" (I know that one can name a range directly, I use a simple case for example). It probably worth to notice that if using the cell name directly in a formula it works correctly: "= baz_begin + baz_end" is doing the job. I put severity as major, because the problem did'nt exist in v4.4, and this can be a problem for who want to migrate, and a bigger one for who already have. Anyway, a possible workaround is to prefix cell names with an underscore before migration, if not to much cell names nor files. Hope you'll understand what I meant, as I'm not a native english speaker and the problem is not so simple to explain… Thanks for care! And mainly thanks for all the great jobs done on LO! Greetings! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs