https://bugs.documentfoundation.org/show_bug.cgi?id=86321
--- Comment #115 from matthewn...@yahoo.co.uk ---
(In reply to VLB from comment #113)
> (In reply to matthewnote from comment #112)
> > Testing Calc 7062 on Windows 10 Pro using attachment 114246 [details] (from
> > VLB)
> >
> > Step 1. Deleting values in H19:L19,
> > All the charts update - is the expected result
> > (there are fewer valid x scatter coordinates)
> > Step 2. Click back using toolbar Undo: Delete
> > All the charts update - is the expected result
> > (there are all the x valid scatter coordinates)
> >
> > However, the trend lines on the charts are not restored to original state.
> > Saving the file (different name), then open, the trend lines are in error.
> >
> > Step 3. Modify value I19 from 4 to 8, the trend lines are redrawn.
> > Step 4. Click back using toolbar Undo: Input
> > All the charts update - is the expected result
> > The trend lines are now again at the file original start shapes.
>
> I can also see the behavior in LO 7.06 + 7.1.3 + 7.2
> The behavior shouldn't happen and has nothing to do with the macro.
I find, here, that in Windows with Calc 7.1.3.2 the lines are correct with
Tools>Options>OpenCL> deselect "Allow" (uncheck) Apply>Restart Now
Open>Liggerv2.6. In other words charts work here with Windows OpenCL OFF.
For QA.
1. It seems use of OpenCL(+Windows) is in error by introducing problem cells.
If I uninstall Libreoffice (entirely) from Windows 10 Pro then install 7.1.3.2,
then Help, Restart in Safe Mode, Reset to factory settings, Reset entire user
profile, Apply Changes and Restart then OpenCL is enabled on this PC.
2. Open attachment 114246. Message appears "You are running...for first time"
3. roX0_9 is the open sheet. Go to invoer and delete H19:L19 (now empty).
4. Click back arrow Undo:delete. H19:L19 are now with values again.
5. On sheet roX0_9 last chart lines are in error. Cells DT52:DT153 are wrong.
6. Actual result; DT88 is showing a value of 59.441.
7. Expected result; DT88=DQ84 which is value = 0.1512.
8. Close file. Reopen file. Repeat steps 3 to 7; the error is the same.
9. However, Close File, Close Calc, Restart Calc, Open attachment.
10. Repeat steps 3 to 5. On sheet roX0_9 the DT column values are now correct.
11. On sheet invoer, the line for data range DT column is now wrong but it's DT
column values (also on invoer) are correctly calculated and displayed.
Observations.
Use of CL with Windows on this PC is associated with cell values being wrong.
Starting 7.1.3.2 twice then open the same file causes differently wrong than
the first fresh install. Cell values become correct (although the file hasn't
changed at all) with trend lines now in error (because the system has lost
track of the full data range to be drawn).
Data>Calculate>Recalculate does not update the DT52:DT153 values at step 5.
Recalculate_Hard does cause the DT52:DT153 range to update.
Option OpenCL OFF causes correct presentation of all charts and their data.
Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
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
