Issue 127829 - "define range" makes some cells look empty
Summary: "define range" makes some cells look empty
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.1.5
Hardware: PC Windows 10
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2018-07-31 16:24 UTC by euripides
Modified: 2021-01-24 10:42 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

GIF animated (153.23 KB, image/gif)
2018-08-03 16:01 UTC, oooforum (fr)
no flags Details
A calc file. (51.44 KB, application/octet-stream)
2018-08-06 11:28 UTC, euripides
no flags Details
Screenshot demonstrating the issue (289.36 KB, image/jpeg)
2021-01-23 16:45 UTC, Czesław Wolański
no flags Details
test file (10.92 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-01-24 10:41 UTC, Czesław Wolański
no flags Details
Screenshots illustrating the issue (272.36 KB, image/jpeg)
2021-01-24 10:42 UTC, Czesław Wolański
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description euripides 2018-07-31 16:24:31 UTC
 I want to report a bug related to openoffice Calc.

 I fill a range with real values let's say a1:d4 and then I click "data" -> "define range" and then I define a name, let's say "mymat" and I click the "add" button. The matrix is created. When I close the dialog box some cells of the matrix look empty, like they never had any value, but they are not actually empty. The program does not let me modify any part of the matrix.

If I save, exit, and reopen the document all entries of the matrix reappear. The matrix is intact.

To override this bug, someone has got to save and reopen the document.
Windows 10, version 4.1.5.

Comment 1 euripides 2018-07-31 16:47:46 UTC
I have to add that the cells disappear when I use the scroll bars (horizontal or vertical)
Comment 2 oooforum (fr) 2018-08-03 16:01:51 UTC
Created attachment 86473 [details]
GIF animated

I was not able to reproduce with AOO 4.1.5 and Win7 x64 Pro

See attached GIF
Comment 3 euripides 2018-08-06 11:28:33 UTC
Created attachment 86478 [details]
A calc file.

In the file above the bug is reproduced (at least in my system, windows 10).

The procedure that makes the bug appear is the following

- open the file using openoffice calc.
- scroll down and go to cell B271
- select cell range B271:H271
- type the formula
   =mmult(pvec;mmult(aimat, bxx))
- press All + Enter
- click Data -> Define Range
  In the dialog box enter the name "myrange" and click the add button.
  click ok.
- scroll up to the top of the spreadsheet using the mouse and the vertical scroll bar.
- scroll down again to cell b271.
  Cell b271 is empty.

It reproduces always, at least in my system. 

Comment 4 oooforum (fr) 2021-01-23 13:37:48 UTC
I read your step-by-step and I don't reproduce with last build 4.1.8 and Win10

Note that
>- type the formula
>   =mmult(pvec;mmult(aimat, bxx))
This formula returns Err:508 for each cell in B271:H271 range
Comment 5 Czesław Wolański 2021-01-23 16:17:21 UTC
AOO 4.1.8
Windows 7, 64-bit

I can reproduce the effect, provided that two changes are made to the report:

Change    =mmult(pvec;mmult(aimat, bxx)) 
to        =mmult(pvec;mmult(aimat; bxx))
(semicolon as argument separator)

Change "All + Enter" to "Ctrl+Shift+Enter"
(array formula)

See/download please the video available at the following link:
Comment 6 Czesław Wolański 2021-01-23 16:45:58 UTC
Created attachment 86996 [details]
Screenshot demonstrating the issue
Comment 7 oooforum (fr) 2021-01-23 16:47:04 UTC
I see a custom style "Excel Built-in Normal"
So, I wonder if this document has been created from scratch with Calc.
Perharps an MS-Excel ersatz good?
Comment 8 Czesław Wolański 2021-01-24 10:40:53 UTC
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" )

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


Thanks for de-empying "empy".  ;‑)
Comment 9 Czesław Wolański 2021-01-24 10:41:51 UTC
Created attachment 86997 [details]
test file
Comment 10 Czesław Wolański 2021-01-24 10:42:47 UTC
Created attachment 86998 [details]
Screenshots illustrating the issue