[Spreadsheet] How to count the sum of the number of lines in a column?

🍱 Features & apps office
1

In Google Spreadsheet, if you want to count the sum of the number of lines in all cells in column A, you can use this function:

=counta(A1:A) + sum(arrayformula(len(regexreplace(A1:A, "[^\n]", ""))))

What’s the equivalent in Nextcloud Office? I tried the same function, and it doesn’t work and shows the result as #NAME?

2

hi @IanY welcome to the forum :handshake:

Nextcloud Office could use with different backends. Assuming you use Collabora as most popular I would recommend you to ask the question in their forum as chances are higher you get answers for application specific: https://forum.collaboraonline.com

2 Likes