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)

Problem description: 

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:
    Sub Main
        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
    End Sub

---------

Current behavior:

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)


---------

Expected behavior:

The cell should be updated on the screen..
Operating System: Windows 7
Version: 4.1.0.4 release