Issue 127829 - "define range" makes some cells look empy
Summary: "define range" makes some cells look empy
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: 2018-08-06 11:28 UTC (History)
1 user (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

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.