Bug 160804

Created attachment 193834 [details]
sample file

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ea43cbbb7371a743f470d949762a0e92f196e652
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (es_AR); UI: en-US
Calc: CL threaded


_My_ settings are probably not typical:

* Array Row separator: semicolon (";")
* Array Column separator: vertical bar ("|" hex 7c, dec 124)


1. A1: ={1;2;3} [ENTER]

1.1. Array result:

A1: 1
A2: 2
A3: 3

2. Select A1:A3 (the whole array).

3. Expand the array to add one row, A1:A4.

3.1. Array result:

A1: 1
A2: 1
A3: 1
A4: 1


4. Expand the array to add one row, A1:A5.

4.1. Array result:

A1: 1
A2: 2
A3: 3
A4: #N/A
A5: #N/A



5. Expand the array to add _two_ rows, A1:A7.

5.1. Array result:

A1: 1
A2: 1
A3: 1
A4: 1
A5: 1
A6: 1
A7: 1


6. Expand the array to add one row, A1:A8

4.1. Array result:

A1: 1
A2: 2
A3: 3
A4: #N/A
A5: #N/A
A6: #N/A
A7: #N/A
A8: #N/A



I can even reduce the size of the array; the amount of rows (plus or minus) are not a factor.

The factor is: one time I get "ones", the next time I get the original array plus #N/A (as much as needed to fulfill the new size of the array), and then the cycle repeats.

I can also replicate this cycle when expanding the array from rows to multiple columns. The difference is that the "ones" are expanded to "twos", and so on (according to number of columns) and then #N/A's and then the cycle repeats.

(In reply to ady from comment #2)

> _My_ settings are probably not typical:
> 
> * Array Row separator: semicolon (";")
> * Array Column separator: vertical bar ("|" hex 7c, dec 124)
> 
> 
> 1. A1: ={1;2;3} [ENTER]

Of course that for older versions, the introduction of the array (formula) needs to be performed by [CTRL]+[SHIFT]+[ENTER] (instead of the sole [ENTER]). In newer versions, Calc automatically recognizes this as an array even when only using [ENTER].

When using CSE, I can reproduce the same behavior I described in comment 2 with LO 3.3 too.

Before setting this report to "inherited", I would rather have confirmation that what I described in comment 2 is indeed the same problem that is (apparently) reported in comment 0 (because I am not sure, considering the differences in my results).

Created attachment 194146 [details]
sample file within macro

> In newer versions, Calc automatically recognizes this as an array even when only using [ENTER].

However, I have not seen any documentation outside of the release notes that states that [Ctrl + Shift + Enter] may not be necessary.

______________________________________________________
I apologise if my description is not clear.

A macro has been created to show what happens to the fill down matrix when the delimiter is different from the system.
Check the changes in the system formula.
3-Types -- 1;2;3 , use Filter Function , use Sequence Function

Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/d4ae5abb4d00cc8adb3c45a9410fc71e56211c46

Resolves: tdf#160804 sc: ResizeMatrix: Use document grammar

It will be available in 24.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

Pending review https://gerrit.libreoffice.org/c/core/+/167817 for 24-2