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
