[Libreoffice-bugs] [Bug 140411] New: Calc constantly re-calculating (bug in the sheet?)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140411
           Summary: Calc constantly re-calculating (bug in the sheet?)
           Product: LibreOffice
           Version: 7.1.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: the.d4ni3l at gmail.com

Description:
He there,

I am a newbie in LibreOffice and use it for a stocks handling with
Financials-Extension https://github.com/cmallwitz/Financials-Extension, this
extension is collecting realtime data from financial services (also asking for
adding this useful extension to the official extension list instead of outdated
SMF Extension on Libreoffice extensions catalog).

So, the problem is, I have a sheet with stocks (not so many) and different
formulas. 

If AutoCalculate is ON and I modify any unrelated to formulas or empty cell
Calc starts recalculating all the data including financial-extension data,
which takes a lot of time for the extension (about 40 seconds). To modify 10
cells I need spend 7 minutes...

If I create new sheet and put manually some formulas for the extension, all
works fine! No excessive re-calculatings. But if I copy-paste all the data to
the new shet, it works the same bad.

Cant understand whats wrong with this sheet. Looks like some bug inside.

Steps to Reproduce:
0a. install pip for python
0b. make command "c:\Program Files\LibreOffice\program\python.exe" -m pip
install python-dateutil pytz pyparsing
0c. install financial-extension
https://github.com/cmallwitz/Financials-Extension
1. open the example sheet
2. modify random empty cell
3. wait for 40 seconds
4. ?
5. profit

Actual Results:
Calc re-calculating all data in all cells after modyfing any empty cell, which
spends a lot of time.

Expected Results:
Calc will re-calculate only cells related to modified cell.
Calc will not re-calculate cells which is not related to modified cell.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

-- 
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/20210214/3d2be7cc/attachment-0001.htm>