Apache OpenOffice (AOO) Bugzilla – Issue 127829
"define range" makes some cells look empty
Last modified: 2021-01-24 10:42:47 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,
I have to add that the cells disappear when I use the scroll bars (horizontal or vertical)
Created attachment 86473 [details] GIF animated I was not able to reproduce with AOO 4.1.5 and Win7 x64 Pro See attached GIF
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,
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
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
Created attachment 86996 [details] Screenshot demonstrating the issue
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?
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". ;‑)
Created attachment 86997 [details] test file
Created attachment 86998 [details] Screenshots illustrating the issue