Issue 127829

Summary:

"define range" makes some cells look empty

Product:

Calc

Reporter:

euripides <esell>

Component:

programming

Assignee:

AOO issues mailing list <issues>

Status:

UNCONFIRMED ---

QA Contact:

Severity:

Normal

Priority:

P5 (lowest)

CC:

czeslaw.wolanski, mseidel, oooforum

Version:

4.1.5

Target Milestone:

---

Hardware:

OS:

Windows 10

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
GIF animated	none
A calc file.	none
Screenshot demonstrating the issue	none
test file	none
Screenshots illustrating the issue	none

Description euripides 2018-07-31 16:24:31 UTC

Hello, 
 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.

Regards,

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. 

Regards,

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:

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

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

See/download please the video available at the following link:

https://drive.google.com/file/d/18MmnW5uYH2MKU7fJx0HfyxoFfjmYXHbx/view?usp=sharing

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" )


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".  ;‑)

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