https://bugs.documentfoundation.org/show_bug.cgi?id=101224
Bug ID: 101224
Summary: VIEWING Cell view not updated with split screen and
macros
Product: LibreOffice
Version: 5.0.6.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 126486
--> https://bugs.documentfoundation.org/attachment.cgi?id=126486&action=edit
Demonstration of the problem reduced to the bare minimum
The combination of a split view and the use of custom functions written in
BASIC, can cause calc not to display correctly the contents of some cells.
To reproduce:
==============
- Open the attached document (WARNING: contains macros, which must be activated
to demonstrate issue)
- Split the view horizontally and scroll the upper view to the top of the
spreadsheet. The lower view should show the highlighted cell at row 50
- In the upper View, write any value to cell A1 and hit enter
--> Cell A1 shows as empty, even though it (correctly) contains the value
just entered.
--> After editing any other cell, the contents of A1 will "appear"
Additional information:
========================
- The problem occurs only for cells that are referenced by a function written
in BASIC
- The function must be rather "long" to calculate for the problem to show.
Alternatively, the problem also shows with a function that takes less cycles,
but is used in several cells. (see Example2 in the attachement)
- The problem shows also with the view split horizontally, in this case the
function(s) must be in a cell to the right of A1.
- Inverting the positions for the "value cell" and the "function cell" the
problem does NOT reproduce. (i.e. everything works as expected)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
