You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2018/07/31 16:24:31 UTC
[Issue 127829] New: "define range" makes some cells look empy
https://bz.apache.org/ooo/show_bug.cgi?id=127829
Issue ID: 127829
Issue Type: DEFECT
Summary: "define range" makes some cells look empy
Product: Calc
Version: 4.1.5
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: programming
Assignee: issues@openoffice.apache.org
Reporter: esell@math.ist.utl.pt
Target Milestone: ---
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,
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127829] "define range" makes some cells look empy
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
Czesław Wolański <cz...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |czeslaw.wolanski@gmail.com
--- Comment #5 from Czesław Wolański <cz...@gmail.com> ---
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
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127829] "define range" makes some cells look empy
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oooforum@free.fr
--- Comment #2 from oooforum (fr) <oo...@free.fr> ---
Created attachment 86473
--> https://bz.apache.org/ooo/attachment.cgi?id=86473&action=edit
GIF animated
I was not able to reproduce with AOO 4.1.5 and Win7 x64 Pro
See attached GIF
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127829] "define range" makes some cells look empty
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
--- Comment #9 from Czesław Wolański <cz...@gmail.com> ---
Created attachment 86997
--> https://bz.apache.org/ooo/attachment.cgi?id=86997&action=edit
test file
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127829] "define range" makes some cells look empty
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
--- Comment #10 from Czesław Wolański <cz...@gmail.com> ---
Created attachment 86998
--> https://bz.apache.org/ooo/attachment.cgi?id=86998&action=edit
Screenshots illustrating the issue
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127829] "define range" makes some cells look empty
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
--- Comment #8 from Czesław Wolański <cz...@gmail.com> ---
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.
[Issue 127829] "define range" makes some cells look empy
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
--- Comment #7 from oooforum (fr) <oo...@free.fr> ---
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?
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127829] "define range" makes some cells look empy
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
--- Comment #1 from euripides <es...@math.ist.utl.pt> ---
I have to add that the cells disappear when I use the scroll bars (horizontal
or vertical)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127829] "define range" makes some cells look empty
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
Matthias Seidel <ms...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |mseidel@apache.org
Summary|"define range" makes some |"define range" makes some
|cells look empy |cells look empty
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127829] "define range" makes some cells look empy
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
--- Comment #3 from euripides <es...@math.ist.utl.pt> ---
Created attachment 86478
--> https://bz.apache.org/ooo/attachment.cgi?id=86478&action=edit
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,
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127829] "define range" makes some cells look empy
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
--- Comment #6 from Czesław Wolański <cz...@gmail.com> ---
Created attachment 86996
--> https://bz.apache.org/ooo/attachment.cgi?id=86996&action=edit
Screenshot demonstrating the issue
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127829] "define range" makes some cells look empy
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127829
--- Comment #4 from oooforum (fr) <oo...@free.fr> ---
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
--
You are receiving this mail because:
You are the assignee for the issue.