https://bugs.documentfoundation.org/show_bug.cgi?id=171179
Bug ID: 171179
Summary: The first and second terms of the SEQUENCE function
are insufficiently explained
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Description:
The first and second terms of the SEQUENCE function are insufficiently
explained.
Steps to Reproduce:
1. See SEQUENCE function page.
https://help.libreoffice.org/latest/en-US/text/scalc/01/func_sequence.html
```
=SEQUENCE(Rows; Columns [; Start [; Step ]])
Rows: a positive integer. The number of rows to return.
Columns: a positive integer. The number of columns to return.
```
Actual Results:
2. The descriptions for Rows and Columns are incorrect.
Expected Results:
2. The Columns argument is optional; if omitted, it defaults to 1.
The Rows argument is required, but if empty, it defaults to 1.
Reproducible: Always
User Profile Reset: No
Additional Info:
While I don't understand English well,
following conventional practices for functions like this, I believe the correct
implementation should be as follows:
```
=SEQUENCE(Rows [; Columns [; Start [; Step ]]])
^^ ^
Rows: a positive integer. The number of rows to return. If empty, default is 1.
^^^^^^^^^^^^^^^^^^^^^^^^
Columns: a positive integer. The number of columns to return. If omitted,
default is 1.
^^^^^^^^^^^^^^^^^^^^^^^^^^
```
---
Moreover, the example provided is inappropriate.
A square matrix like {=SEQUENCE(3; 3; 10; 11)} is not a good representative
example.
A rectangular matrix like {=SEQUENCE(3; 5; 10; 11)} would be much clearer.
--
You are receiving this mail because:
You are the assignee for the bug.
