[Libreoffice-bugs] [Bug 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #20 from chiappini  ---
Thank you gentlemen for your help, this time I understood.
cordially
Jean Pierre

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

Mike Kaganski  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #19 from Mike Kaganski  ---
Please don't change the status unless you can confirm that it doesn't work in
the versions that we tested. I was talking about master towards 6.1, and Xavier
mentioned both master and 6.0.0.1.0+ - it means, the one *after* RC1 available
for download.

So yes, the 6.0.0.1 does show the problem; but the problem is fixed in a
*later* builds.

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

chiappini  changed:

   What|Removed |Added

 Status|RESOLVED|UNCONFIRMED
 Resolution|WORKSFORME  |---

--- Comment #18 from chiappini  ---
Unconfirmed

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #17 from chiappini  ---
Created attachment 138646
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138646=edit
LibreOffice Version 6

File for test

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #16 from chiappini  ---
Created attachment 138645
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138645=edit
capture d'ecran

Hello,
Please excuse my bad English, I'm using Google Translator.
I installed version 6 and unfortunately it's the same thing see attached image
and attached file.
I add that on my machine the function (Ctrl-Alt-F9) does not work.
  To do the tests, open the file and save it under another name, then close it.
After open this new file and see if LibreOffice calculates? I think not.

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

Mike Kaganski  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #15 from Mike Kaganski  ---
(In reply to chiappini from comment #13)

This is indeed a bug.

As Xavier Van Wijmeersch have mentioned in comment 14, this problem is not
present in latest development versions (I confirm this with Version:
6.1.0.0.alpha0+ (x64)
Build ID: ab0b2b44f53652590eb290f6f4adf2ddde5a700d
CPU threads: 4; OS: Windows 10.0; UI render: GL; 
Locale: ru-RU (ru_RU); Calc: CL).

So - closing this as WORKSFORME (which means that it has been fixed, but
specific commit is unknown).

Wrt your question from comment 11 ("I wonder if there is a button to
recalculate everything in the original file"): the answer was given in comment
10 - please use Ctrl+Shift+F9 several times.

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #14 from Xavier Van Wijmeersch  ---
Merry Christmas to all

row10 is ok
column AB => AG all #div/0
can reproduce with

Version: 5.3.1.2
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout
Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 5.4.5.0.0+
Build ID: a61f45499856aad9910d82af1312a163504c15c2
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

but not with

Version: 6.0.0.1.0+
Build ID: 4ca94f24995c8d7b854e2d98fd7ff8fa7b9e2157
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.1.0.0.alpha0+
Build ID: 86a939d5fd93173949447337738fa0625803ec92
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2017-12-25_09:06:24
Locale: nl-BE (en_US.UTF-8); Calc: group 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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #13 from chiappini  ---
So, is this a bug or is there a solution?

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #12 from chiappini  ---
I'm sorry I have to leave.
I will return tomorrow.

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #11 from chiappini  ---
If I copy a line to a new file, LibreOffice Calc works fine.
I wonder if there is a button to recalculate everything in the original file
(87000 lines).

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

Mike Kaganski  changed:

   What|Removed |Added

 CC||er...@redhat.com

--- Comment #10 from Mike Kaganski  ---
Well, actually I can see that it takes several (3?) full recalcs
(Ctrl+Shift+F9) to refresh all the values...

Eike, could you please tell it this normal?

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #9 from chiappini  ---
Created attachment 138628
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138628=edit
line 10

For line 4 # DIV / 0 is correct. But not for the other lines.
See example line 10

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #8 from Mike Kaganski  ---
Ok; so which cell contains the wrong #DIV/0? or all of those cells with #DIV/0
are wrong?

Specifically: I4 is equal to T4; their difference is zero; so #DIV/0 in row 4
(starting with W4 and X4, where the divisor is (I4-T4)) are correct.

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #7 from chiappini  ---
for V stuart Foote
This is exactly the same problem in file.ods version

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #6 from chiappini  ---
Created attachment 138627
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138627=edit
Reduced file

here is the reduced file

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #5 from V Stuart Foote  ---
Round trip to .xls binary?  Any better if you save to native ODF .ods format?

Also, 5.1.6.2 is rather dated/unsupported, perhaps move to 5.3.7.2, 5.4.4.2 or
even the 6.0.0 rc1.

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #4 from Mike Kaganski  ---
Well, could you provide just a small part of it, with most data removed, only
some rows that take part in calculations of one failing value?

Otherwise, you could try using some public sharing service, like Dropbox.

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

chiappini  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #3 from chiappini  ---
How do you communicate the file.xls of more than 30 000ko, it is 52.7 MB

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

--- Comment #2 from chiappini  ---
The file size is too big for the posted
how do you communicate it?

-- 
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 114680] LibreOffice Calc does not calculate

[bugzilla-daemon]

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

Mike Kaganski  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #1 from Mike Kaganski  ---
Hi,

thanks for the report. Unfortunately, it's impossible to do anything useful
based on the PNG you've attached. Please provide a sample spreadsheet, where
the problem is reproducible. Please reset the status back to UNCONFIRMED after
attaching the required data.

-- 
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