Bug 107590 - Cell value not refreshed
Summary: Cell value not refreshed
Status: CLOSED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-03 11:59 UTC by Michal Svec
Modified: 2017-12-06 18:11 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
minimal example (7.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-05-03 12:00 UTC, Michal Svec 		Details
A value in the particular cell (SUM) is not refreshed upon the changes (59 bytes, text/plain)
2017-05-06 18:35 UTC, Xavier Van Wijmeersch 		Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michal Svec 2017-05-03 11:59:43 UTC 
Description:
A value in the particular cell (SUM) is not refreshed upon the changes
of the other cells which are a source.


Steps to Reproduce:
Look at H10 (I am attaching a minimal example).


Actual Results:  
Number from the previous SUM


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0
Comment 1 Michal Svec 2017-05-03 12:00:05 UTC 
Created attachment 133026 [details]
minimal example
Comment 2 JO3EMC 2017-05-05 09:29:06 UTC 
Reproduced.

Value of H10 don't change without some change in I10-K10 which refered from H10.
Change of any other cell don't cause the recalculation of H10.
Althogh "AutoCaluculate" switch is checked.

I don't know this is bug or specification.
MS Excel 2013 behaves differently.

Version: 5.4.0.0.alpha1+
Build ID: 2514e38f8ebb95f51783ce321a84d6c55bba1de4
CPU threads: 4; OS: Windows 6.2; UI render: default; 
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2017-05-04_00:30:46
Locale: en-US (ja_JP); Calc: group

Version: 5.3.2.2
Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1
CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; Layout Engine: new; 
Locale: en-US (ja_JP); Calc: group
Comment 3 Xavier Van Wijmeersch 2017-05-06 18:35:36 UTC Comment hidden (obsolete)
Comment 4 Xavier Van Wijmeersch 2017-05-06 18:36:52 UTC 
column I;J are grey out when entering data
Comment 5 Eike Rathke 2017-06-28 18:28:45 UTC 
(In reply to Xavier Van Wijmeersch from comment #4)
> column I;J are grey out when entering data
That's because the font color is set to grey on those cells.
Comment 6 Eike Rathke 2017-06-28 18:38:15 UTC 
The document has a stored result of 2453 for H10 although the referenced cells are empty, which is displayed without recalculating. As soon as I enter a value in any cell of the referenced range I10:K10 the formula cell recalculates, so I can't reproduce. Also hard recalc (Shift+Ctrl+F9) or hitting F9 once on H10 recalculates to 0 after loading.

Document was stored using LibreOffice 5.3.3.1

Question remains how the original document could had ended up in such a state with AutoCalculate on. I have no idea.
Comment 7 Eike Rathke 2017-12-06 18:11:41 UTC 
Might be after having inserted a column, see bug 111428.