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?
#NAME?
hi @IanY welcome to the forum
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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.