[Libreoffice-bugs] [Bug 125320] combination of autocalculate and shared formulae still broken in 6.3.0.0.alpha1+ with threaded off

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Aug 25 10:17:02 UTC 2019


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

Buovjaga <todventtu at suomi24.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |todventtu at suomi24.fi

--- Comment #2 from Buovjaga <todventtu at suomi24.fi> ---
To check, if you have it enabled: Data - Calculate - Autocalculate

(In reply to b. from comment #0)
> ctrl-shift-F9 corrects the problem, thus *only* 'broken autocalculate', 

https://helponline.libreoffice.org/6.4/en-US/text/scalc/01/06080000.html?DbPAR=CALC#bm_id3157909
Ctrl-Shift-F9 is *hard* recalc, which recalculates *all* formulas in the
document.

(In reply to b. from comment #0)
> i stepped into this while working on 124270 and having err:522 with threaded
> enabled, boiling down and even disabling threaded results in this fault. 

In the summary, you have "with threaded off". The above seems to contradict
this. Is this related to threaded at all?

(In reply to b. from comment #0)
> Steps to Reproduce:
> 1. open file attached with next comment, 
> 2. check results in CG1:CG1105 being '0' despite the formula should result
> in '18', 
> 3. if corrected by recalc on load or other: 
> 4. i copied lines 1:8 from another sheet into this one, 
> 5. expanded A1:CZ5 down to row 1365, 
> 6. filled in some start values in row 1365, 
> 7. checked the results, 
> (autocalculate was! on all the time), 
> 
> a second try overpasting the existing faulty sheet failed - to fail -, a
> third attempt with deleting the contents in the sheet, pasting in 5 rows and
> pulling A1:CZ5 down to 1300 inserting the same values in row 1300 produced
> faulty '0' only in rows 1 to 5.  

I ignored steps 3 and 4 as they did not seem necessary.

After inputting "5" in CC1365, I get err:522 in CC and CG columns from row 1322
upwards. Do I reproduce the bug in your view?

Arch Linux 64-bit
Version: 6.4.0.0.alpha0+
Build ID: b9a776837462eeb6d50d0decc42604c0c3008eb1
CPU threads: 8; OS: Linux 5.2; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 11 August 2019

-- 
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/20190825/4cacdd97/attachment-0001.html>


More information about the Libreoffice-bugs mailing list