[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case ( steps in comment 4 )
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 Gabor Kelemen (allotropia) changed: What|Removed |Added CC||kelem...@ubuntu.com Regression By||Kohei Yoshida -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case ( steps in comment 4 )
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 Buovjaga changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||1339 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case ( steps in comment 4 )
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 Buovjaga changed: What|Removed |Added Blocks||109324 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109324 [Bug 109324] [META] Calculate bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case ( steps in comment 4 )
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 --- Comment #10 from b. --- @xisco: i'd suggest to change bug / duplicate between 128975 and 129541, 129541 is the simpler shorter sample which will make it easier for dev's to deal with it ... reg. b. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case ( steps in comment 4 )
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 --- Comment #9 from Xisco Faulí --- *** Bug 129541 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case ( steps in comment 4 )
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 Xisco Faulí changed: What|Removed |Added CC||dennisfrancis...@gmail.com Summary|WORK: EDIT: issues left in |WORK: EDIT: issues left in |fixing shared-formula / |fixing shared-formula / |autocalculate problems? - |autocalculate problems? - |edge case |edge case ( steps in ||comment 4 ) --- Comment #8 from Xisco Faulí --- @Dennis, i thought you might be interested in this issue... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 Xisco Faulí changed: What|Removed |Added Keywords|bibisectRequest |bibisected, bisected Version|4.2.0.4 release |4.4 all versions CC||ko...@libreoffice.org --- Comment #7 from Xisco Faulí --- Regression introduced by: https://cgit.freedesktop.org/libreoffice/core/commit/?id=6b4e767cf90e4f384a6b3dd43aa51c09b500b97b author Kohei Yoshida 2014-11-17 17:37:07 -0500 committer Kohei Yoshida 2014-11-18 08:31:57 -0500 commit 6b4e767cf90e4f384a6b3dd43aa51c09b500b97b (patch) treea9a06d522bab185c7df24a6958daf9e59dbefa6a parent 627bfb4e664a3fde23c06aa4dd0809de84ec97c5 (diff) Use group-area listeners during copy & paste if we can. Bisected with: bibisect-44max Adding Cc: to Kohei Yoshida -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 --- Comment #6 from Xisco Faulí --- Also fine in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 Xisco Faulí changed: What|Removed |Added Keywords||bibisectRequest, regression --- Comment #5 from Xisco Faulí --- Not reproducible in LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW CC||xiscofa...@libreoffice.org Whiteboard| QA:needsComment| --- Comment #4 from Xisco Faulí --- (In reply to b. from comment #3) > 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, Reproduced in Version: 7.0.0.0.alpha0+ Build ID: 28d844a589e52abfe62dc66b888e78665221ba28 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 b. changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||9541 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128975] WORK: EDIT: issues left in fixing shared-formula / autocalculate problems? - edge case
https://bugs.documentfoundation.org/show_bug.cgi?id=128975 b. 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. --- 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs