autocalc - shared formula fail? would like a recheck

asked 2021-04-14 14:43:43 +0200

newbie-02 gravatar image

hi @ all,

had a little surprise, would like test's by others before filing a bug to rule out 'special settings' or whatever,

reproduce:
1. System Xeon and Win7, don't know if others affected, 2. calc ver. 7.2.0.0.a0+, don't know if others affected,
3. key 1,2 in cell A1,
4. copy that cell with ctrl-c,
5. mark whole column A (i did by shift-ctrl-cursor-down),
6. paste the value from clipboard, ctrl-v,
7. enter cell B2 and input '=A1+A2', i did by keying '=', cursoring to A1, keying '+', cursoring to A2, hitting enter,
8. copy that cell with ctrl-c,
9. mark cells B3:B1048576, (i did by shift-ctrl-cursor-down),
10. paste the formula by ctrl-v,
11. observe cells at the bottom of the column '0',
12. observe cells B2:B1001 correct result '2,4', from B1002 downwards '0',
13. think 'wrong'??

problem could be reproduced several times ...

edit retag flag offensive close merge delete

Comments

what is column '0' mentioned in step 11?

Mike Kaganski gravatar imageMike Kaganski ( 2021-04-14 16:42:21 +0200 )edit

@Mike Kaganski: value in the cells instead of 2,4

newbie-02 gravatar imagenewbie-02 ( 2021-04-14 17:03:53 +0200 )edit

I am confused then why is there step 11, that tells to look at "cells at the bottom of the column '0'", and then step 12, telling to see that "cells B2:B1001 correct result '2,4', from B1002 downwards '0'". What is the difference?

Mike Kaganski gravatar imageMike Kaganski ( 2021-04-14 17:11:21 +0200 )edit

@Mike Kaganski: i don't know if there is a difference, for me both look as wrong results, mentioned in that order as: 1. historically grown, 2. when pasting in col. B is finished the focus will likely be at the bottom cells, 3. for not to assume all results are wrong it's meaningful to look at the upper cells too, 4. when going up the user might miss the point where the results change, 5. if the results change at another point for other users it might say something about options running 'til 1000 on my system ... it's as often with bugs, i don't know what's important and what isn't, thus described in a manner that other users can try a identical rerun ...

newbie-02 gravatar imagenewbie-02 ( 2021-04-14 19:23:39 +0200 )edit

No problem here with Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: a48a03152b35ffad5a02a2c446b8f9a4609bf98e CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL

Trying to file bugs about 7.2 is way too early. Absolutely no sense. Don't do that unless you also see the problem in a released or beta version (7.2 now is pre-alpha).

Mike Kaganski gravatar imageMike Kaganski ( 2021-04-14 19:31:45 +0200 )edit

@Mike Kaganski: no repro with versions up to 7.1.0.0.a0+, repro with 7.2 dev from today: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 6e6e531b564cdc9d5b25287c215cdc5a1fcbb346 CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: CL

newbie-02 gravatar imagenewbie-02 ( 2021-04-15 09:52:44 +0200 )edit