[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 --- Comment #11 from Mark Lytle --- You seem to have found the problem. Everything is now working as it used to. Thank you for your efforts, I never would have found this on my own.. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 m.a.riosv changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |NOTABUG --- Comment #10 from m.a.riosv --- There are spaces instead a blank cell in C71:E1999. LibreOffice it's more restrictive on how convert text on numbers. You have options about it on Menu/Tools/Options/LibreOffice Calc/Formula - Detailed calculation settings - Custom - Details, and select the option that fits what you like, I guess the firts 'Generate #VALUE! error' Resolved as not a bug, please if you are not agree reopen it. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 --- Comment #9 from Mark Lytle --- Created attachment 135712 --> https://bugs.documentfoundation.org/attachment.cgi?id=135712&action=edit Same problem under LO 5.4 as noted earlier. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 --- Comment #8 from Mark Lytle --- Just uploaded picture of Apache OPenoffice on Windows 10. no problems..SLOW though, I'd hate to have to go that route. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 --- Comment #7 from Mark Lytle --- Created attachment 135706 --> https://bugs.documentfoundation.org/attachment.cgi?id=135706&action=edit This is the same file in Apache Openoffice 4.1.3 on Windows 10, no problems One of the two machines I'm running these spreadsheets on is a dual boot Windows 10/Linux Mint machine. On the Windows 10 side have loaded apache openoffice 4.1.3, it is free of the spurious zero's and has not manifested this proble. Some spurious values here too, but not zero's which seem to be the main culprit. All graphs are normal, running 5 of them.. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 --- Comment #6 from Mark Lytle --- 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 Jean-Baptiste Faure changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||jbfa...@libreoffice.org Ever confirmed|0 |1 --- Comment #5 from Jean-Baptiste Faure --- Please, could you try with a recent version? LO 5.1 is not maintained anymore. You can install 5.3 or 5.4 from the LibreOffice PPA managed by the LO team of Canonical. In LO 5.4, I can restore a correct state by propagating formulas again. Then adding values in column C of Sheet1 works as expected. Set status to NEEDINFO, please set it back to UNCONFIRMED once requested informations are provided. Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 Aron Budea changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 --- Comment #4 from Mark Lytle --- Created attachment 135668 --> https://bugs.documentfoundation.org/attachment.cgi?id=135668&action=edit screenshot of how columns produce bogus data from recent incident. 0.000 and 11.170 are bogus should show #value! -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 --- Comment #3 from Mark Lytle --- Created attachment 135667 --> https://bugs.documentfoundation.org/attachment.cgi?id=135667&action=edit This is what I get on the second sheet sometimes when a bogus value (in this case '0') appears on one of the columns. The purple line should be one straight line only. The one coming up from 'zero' from lower left is wrong. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 Mark Lytle changed: What|Removed |Added CC||mlyt...@sbcglobal.net --- Comment #2 from Mark Lytle --- Created attachment 135666 --> https://bugs.documentfoundation.org/attachment.cgi?id=135666&action=edit This is one of the worksheets that are acting up. On first sheet, if you look down the columns AF & AG at some point real data 'created' on column AG as the value 414.76, the column to the left is still correct on those rows with '#value1', I keep 'cleaning' it, comes back. Sometimes it produces a column of zeros below the last real calculation. This data is then copied to the second, third and fourth sheets for graphs and they become very messed up as they plot the bogus values. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[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
https://bugs.documentfoundation.org/show_bug.cgi?id=111912 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 --- Comment #1 from m.a.riosv --- Is needed attach a sample file to take a look about what is happening. Please remember thhis is a public site. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs