<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128975">bug 128975</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>WORK: EDIT: issues left in fixing shared-formula / autocalculate problems?
</td>
<td>WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128975#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128975">bug 128975</a>
from <span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>