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!
Not reproduced. I named A1 as baz_begin and A2 as baz_end. =SUM(baz_begin:baz_end) remains in the correct form. Maybe test with 5.0.2 to be sure. Win 7 Pro 64-bit, Version: 5.0.2.2 (x64) Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe Locale: fi-FI (fi_FI)
Sorry for taking a bit of your time, but I mistaked my example, the last valid address with 3 letters seems to be AMJ, so please can you try with anything below amj_.*, SUM(abz_begin:abz_end) per example? Let me know if you can't reproduce it with a valid cell address, and I'll try in LO 5.0.2 as soon as it commes in debian testing.
Thanks, now I could repro :) If you want to repay the wasted time: https://wiki.documentfoundation.org/QA/Triage_For_Beginners :P
Works OK in oldest, latest range in bibisect-win32-5.0, latest:Version: 5.0.0.0.alpha1+ Build ID: ab465b90f6c6da5595393a0ba73f33a1e71a2b65
This seems to have begun at the below commit. Adding Cc: to erack@redhat.com ; Could you possibly take a look at this one? Thanks ~/bibisect-win32-5.1: e4eebfbc852f48890e13dca6a2aecd9e27c731d6 is the first bad commit commit e4eebfbc852f48890e13dca6a2aecd9e27c731d6 Author: Norbert Thiebaud <nthiebaud@gmail.com> Date: Wed Jul 22 16:30:49 2015 -0700 source 0c8778ce1df92ca3bc2a8dd2f64568fb257e9e39 source 0c8778ce1df92ca3bc2a8dd2f64568fb257e9e39 :040000 040000 406f68a85a5b57cbd018badcaf94928815b10424 eb1e540dc0196ce0b54cc66533deeff10d0cf6e3 M instdir author Eike Rathke <erack@redhat.com> 2015-06-26 13:12:46 (GMT) committer Eike Rathke <erack@redhat.com> 2015-06-26 13:19:52 (GMT) commit 0c8778ce1df92ca3bc2a8dd2f64568fb257e9e39 (patch) tdf#44419 allow A:A and 1:1 references also in Calc A1 and ODF syntax
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=14bb562b4a8776974391641adcc62ded013ffd2f Resolves: tdf#94514 more restrictive check on end of column specifier It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/19359 for 5-0 https://gerrit.libreoffice.org/19360 for 5-0-3
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=25d385b4f4429b5d079dae6ba8770603e011456d&h=libreoffice-5-0 Resolves: tdf#94514 more restrictive check on end of column specifier It will be available in 5.0.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f10d88b436383beebf5cbc7387fa23f6e7d8f919 unit test for tdf#94514 It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-0-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5430d2a2a642038c149c29350c86f1bee3a4e650&h=libreoffice-5-0-3 Resolves: tdf#94514 more restrictive check on end of column specifier It will be available in 5.0.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Problem solved for me. Thanks a lot!
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]