[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128975

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|WORK: EDIT: issues left in  |WORK: EDIT: issues left in
                   |fixing shared-formula /     |fixing shared-formula /
                   |autocalculate problems?     |autocalculate problems? -
                   |                            |edge case

--- Comment #3 from b. <newbie-02 at gmx.de> ---
looks like a not handeled 'edge case' ... 

simplest failing sheet: 

' simple test for edge case fail
A2: '1', 
B2: '=SUM(A1:A2)'
copy A2:B2 to A1:B1

observe: 

#REF! in B1 - correct, cell above A1 is not defined, 

'1' in B2 - wrong, sum(A1:A2) should be 2, 

changes in A1:A2 don't affect the result in B2, 

'=(A1:A2)' fails similar but slightly different, but it's results are funny
anyhow, 

'=A1+A2' works better, 

'=PRODUCT(A1:A2)' fails on changes of A1 or A2, you need higher values than 1
in A1 or A2 to show it, 

A1: '2', 
A2: '4', 
B2: '=A1*A2', 
copy A2:B2, 
paste in A1:B1

fails in updating B2 at copying and subsequent changes in A1, 

assumption: ranges fail, single references handeled correctly, does not hold, 

from a little playing around: crossing the top or bottom border with the
referenced area of a copied 'range-formula' blocks autocalculate for the same
formula in the cell above or below the 'border crossing cell', crossing the
left or right border with similar 'transponsed' groups does'nt harm? 

to check: effects when other circumstances invalidate values in referenced
ranges or result of a formula in a shared group. 

once it's ok in simple calculations ... how does it work cascaded as Budi B L's
sample? 

above tests performed with 6.2.8.2 win(x64), 

short look into the future: 

Version: 6.5.0.0.alpha0+ (x64)
Build ID: 0c4736a3e6b6e641579f517cf134ce2fd89fe132
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: 

fails too 

(too hard? apes in writing a bible: you need plenty of apes, plenty of
typewriters, and much time to check the results ... there is a small
statistical chance to finish before universe ends ... changed concept: add some
mandarins checking the results, triaging in "your's i can read so far, go
ahead" and "unreadable - start over" will save time and enhance efficiency, may
be there are better concepts, mankind proves success is! possible, unproven if
by chance, luck or knowledge.) 

reg. 



b.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191129/d9ea0fbf/attachment.html>