[Libreoffice-bugs] [Bug 111912] Spreadsheet is displaying cells with complex formulas and data dependencies with zero or some arbitrary value. These columns are feeds for x-y plots , and they begin to display bizarre results

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Mark Lytle <mlytle0 at sbcglobal.net> ---
O.K. I now have loaded LO 5.4, and the problem is if anything, worse.  But I
understand it better now. The first of the 4 sheets in this somewhat
complicated spreadsheet find 'hiden' trendlines in securities, be they cryptos,
stocks, currencies, whatever.  Those values are calculated day by day using end
of day information.

Columns C, D, & E which are highlighted in light green, are where the current
date, the high for the day , and the low for the day, respectively are input.  
Colomns AF, AG, AU, AV, AW, AX, BM, AND BN are where the values for the y
co-ordinate (price level) of these newly discovered trendlines are calculated
for each imput calendar date successly input into column C.  To avoid creating
this whole very complex set of graphs everytime you add anothers days data,
I've preset about 2000 cells representing about 2000 calendar days in advance
to set up the graph, and these rows become active and useful as each new days
data is entered.  This used to work flawlessly.

For some reason, the cells lower than the last current row that has it's end of
data needs in coulmn C,D, And E met, will sometimes appear to have data in
them, and instead of displaying #value!, meaning I guess, an unresolved (as of
yet) formula, it sometimes takes on some odd partial value, or zero.  Why that
happens I don't know, but it's happening on the second, third, and fourth
sheets where the values from the first sheet are copied sheet to sheet to their
corresponding places to be plotted on the graphs as a function of time
(x-co-ordinate).   The REAL problem seems to be  that only the graphs on sheet
2 are affected, that is these spurious zeros get plotted and ruin the  graphs. 
This doesn't happen on sheets 3 & 4 for some reason.  So, two issues, why the
spurious numbers, and why only the graphs on sheet 2 fails to ignore them.

-- 
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/20170821/dbdc9f2f/attachment.html>