[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 b. changed: What|Removed |Added CC||newbie...@gmx.de --- Comment #19 from b.

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 andis.lazd...@gmail.com changed: What|Removed |Added Status|NEW |RESOLVED

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #17 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #16 from Bill Babb mobil...@gmail.com --- After many tests I've found that the problem seems related to the position of the SUM function in the expression. When I place SUM as the first term in the expression the result of the

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #13 from Bill Babb mobil...@gmail.com --- Comment on attachment 113375 -- https://bugs.documentfoundation.org/attachment.cgi?id=113375 Example of calculation approach What's wrong with this: =B3+B4+F3+F4+F7+F8+F9+F19, all

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #14 from Bill Babb mobil...@gmail.com --- Comment on attachment 113401 -- https://bugs.documentfoundation.org/attachment.cgi?id=113401 Updated version of example with repeatable error Your problem confirms what I suspected:

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #15 from m.a.riosv miguelange...@libreoffice.org --- Please Bill what is the issue in your attached files? -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #11 from andis.lazd...@gmail.com --- Hello! The problem has gone after hard recalc [Shif+Ctrl+F9]. However, after saving and reopening I got the same result as before [Shif+Ctrl+F9]. Simple recalculation of cell content [f9]

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added Status|NEEDINFO|NEW ---

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #10 from LeMoyne Castle lemoyne.cas...@gmail.com --- Just a note in support of this report. If confirmed, this bug may deserve a higher priority /or severity. It is possible that a linked cell's current value is being taken

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #9 from m.a.riosv mari...@miguelangel.mobi --- Forgive me, I didn't mention. Shortcut = [Shif+Ctrl+F9] It forces to recalculate all cells. https://help.libreoffice.org/Calc/Recalculate

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 k...@cox.net changed: What|Removed |Added Status|RESOLVED|REOPENED

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #5 from andis.lazd...@gmail.com --- Created attachment 113401 -- https://bugs.documentfoundation.org/attachment.cgi?id=113401action=edit Updated version of example with repeatable error -- You are receiving this mail

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #6 from andis.lazd...@gmail.com --- Hello! It's funny, but when I tried to reconstruct formulas in example file using another worksheet instead of linked file, I was able to repeat the error. Result of the experiments is

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added Status|REOPENED|NEEDINFO ---

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #8 from andis.lazd...@gmail.com --- (In reply to m.a.riosv from comment #7) Hi @andis have you tried with a hard recalc?. Please can you confirm. What is hard recalc? -- You are receiving this mail because: You are the

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #2 from andis.lazd...@gmail.com --- Thank you for response! The problem is actually unexpected behaviour of newer version of the program. Our greenhouse gas inventory is built of libreoffice calc and it's predecessor

[Libreoffice-bugs] [Bug 89373] Strange behaviour of sum() function in linked or complex spreadsheet

https://bugs.documentfoundation.org/show_bug.cgi?id=89373 --- Comment #3 from m.a.riosv mari...@miguelangel.mobi --- But if with the sample file alone, issue can't be verified, no way to find what the issue begin. Without a minimal sample files where to see the different behaviour between