https://bz.apache.org/ooo/show_bug.cgi?id=127829

--- Comment #8 from Czesław Wolański <[email protected]> ---
I don't think the issue is related to MS Excel or
to the custom style "Excel Built-in Normal".

The attached file "rangeTEST.ods", Sheet1
two ranges defined: "range1" (cells D3:F5) and "range2" (cells D8:D10)

Cell area F15:F17 contains the array product of two arrays
calculated with array formula =MMULT(D3:F5;D8:D10)

Cell area F20:F22 contains the array product of two arrays
calculated with array formula =MMULT(range1;range2)


Now the proof:

Step 1 - open the file "rangeTEST.ods"

Step 2
- define a range of cells F15:F17 (via 'Data - Define Range...')
- scroll down the spreadsheet view using the mouse and
  the vertical scroll bar so that start area becomes invisible
- scroll back to the start area

No change in the appearance of cells F15:F17.

Step 3
- define a range of cells F20:F22.
- scroll down the spreadsheet view using the mouse and
  the vertical scroll bar so that the start area becomes invisible
- scroll back to the start area

Now cell F20 looks empty.
( cf. the attached file "'Empty' cell.jpg" )


NOTE:
One can achieve the same effect also by using names
(via "Insert - Names - Define...').
Perhaps I should file a separate report in this matter.


--------------------------


@Matthias
Thanks for de-empying "empy".  ;‑)

-- 
You are receiving this mail because:
You are the assignee for the issue.

Reply via email to