Created attachment 84517 [details]
Spreasheet with an example of this bug (includes a macro that writes a number in a cell, which is then not update on the screen)
When numbers are inserted in a cell using the BASIC Value property, the cell content is not updated on the screen.
The number is effectively introduced in the cell (if you go to the cell with your mouse, you'll see the number in the input line), but it doesn't show up on the screen
This doesn't happen if there is another cell with a formula with a reference to the cell where the Value property writes . Also,
Steps to reproduce:
Try the attached spreadsheet, or the following code:
Dim Doc as Object
Doc = ThisComponent
Dim Sheet as Object
Sheet = Doc.Sheets(0)
Dim CellWrite as Object
CellWrite = Sheet.getCellByPosition(0,0)
CellWrite.value = 42
CellWrite = Sheet.getCellByPosition(0,1)
CellWrite.String = "Hello world!"
CellWrite = Sheet.getCellByPosition(0,2)
CellWrite.value = 41
The cell is not updated on the screen when you use BASIC Value property to write a number in that cell (although the number is effectively inserted in the cell)
The cell should be updated on the screen..
Operating System: Windows 7
Version: 18.104.22.168 release
Ubuntu 14.04 x65
LibreOffice 22.214.171.124 rc
Setting to WFM.
If you can reproduce this with 126.96.36.199 rc or later (4.3.0 will be released soon) then set the bug back to UNCONFIRMED and we'll retest it. Thanks!
I also cannot reproduce in:
Windows 7 x64
It seems that the bug is gone..
Great news - thanks for the update