[Libreoffice-bugs] [Bug 111912] New: 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

            Bug ID: 111912
           Summary: 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
           Product: LibreOffice
           Version: 5.1.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mlytle0 at sbcglobal.net

Description:
I have a complex spreadsheet with 4 sheets.  The first panel is for data input
and data accumulation and some calculations.  Some of that data is copied to
the other sheets and further calculations are done, and those columns are
preset up and change from displaying '#value!' to displaying something real and
useful when the the cells these are linked to get real data, and that's normal
behavior.  Now when entering data and saving the spreadsheet, many of these
cells that are in the state of displaying '#value!' suddenly decide their value
is '0' or some arbitrary random number.  Those columns are the feed for some
x-y plots,and produce bizarre results.

Steps to Reproduce:
1.Add data to spreadsheet
2.Save spreadsheet and close it.
3.Reload spreadsheet, and there they are. You can manually 'clean' these cells
by dragging down from the last correctly displayed value to the bottom of the
sheet and it will nicely and correctly display '#value!' again.  but after a
save and close and reload, you're back in the problem again.

Actual Results:  
Results are bizarre and incorrect plots.  But it's not the plot engine that's
at fault.

Expected Results:
Graph output that makes sense.


Reproducible: Always

User Profile Reset: No

Additional Info:
This is happening on two different hardware platforms, on brand new
installations and two different releases of Linux Mint.


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:55.0) Gecko/20100101
Firefox/55.0

-- 
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/20170819/29206a89/attachment.html>