We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Ales's profile - activity

2020-12-08 22:28:47 +0200 received badge  Notable Question (source)
2020-12-08 22:28:47 +0200 received badge  Famous Question (source)
2020-08-25 22:42:16 +0200 received badge  Nice Answer (source)
2020-05-29 07:44:45 +0200 commented answer CALC: Maximum Length of String in a Range of Cells

Thanks but it still needs that MAX function as shown below. It seems that {=LEN(A1:A3)} alone gets the whole array.

2020-05-29 07:32:55 +0200 marked best answer CALC: Maximum Length of String in a Range of Cells

I have a very long column of strings and I need to find out what is the maximum length.

I thought that this will do the trick: =MAX(LEN(A1:A999)) but it doesn't work --> #VALUE.

In fact even this alone fails: =LEN(A1:A999) as well as: =SUM(LEN(A1:A999)).

What is the right way to do it?

Example:

[     A     ]
[1] aaa
[2] bbbb
[3] ccccc 
---> MAX(LEN(A1:A3)) = 5

LibreOffice Calc 6.4.3.2 (x64), win10.

Thanks.

2020-05-29 07:32:55 +0200 received badge  Scholar (source)
2020-05-28 17:39:35 +0200 received badge  Popular Question (source)
2020-05-28 15:42:24 +0200 asked a question CALC: Maximum Length of String in a Range of Cells

CALC: Maximum Length of String in a Range of Cells I have a very long column of strings and I need to find out what is t

2017-11-26 05:17:58 +0200 received badge  Good Question (source)
2014-09-24 10:29:35 +0200 received badge  Enthusiast
2014-09-23 07:45:50 +0200 answered a question Highlight (not select) row and column of currently selected cell in spreadsheet?
2014-05-19 08:32:46 +0200 commented question Highlight the active row in Calc

It turned out that I'm not the first one who asks for this (no surprise). There already is the Bug 33201 from 2011. If anyone is interested in, can you please add a comment there to express your concern? Thanks. Link: https://bugs.freedesktop.org/show_bug...

2014-05-15 12:11:36 +0200 received badge  Famous Question (source)
2014-05-14 13:10:33 +0200 received badge  Nice Question (source)
2014-05-14 10:59:24 +0200 received badge  Nice Answer (source)
2014-05-14 09:34:43 +0200 received badge  Teacher (source)
2014-05-14 09:34:43 +0200 received badge  Self-Learner (source)
2014-05-14 08:24:51 +0200 answered a question Highlight the active row in Calc

Thank you for your response. Done: fdo#78682

2014-05-14 00:13:45 +0200 received badge  Notable Question (source)
2014-05-13 17:01:02 +0200 received badge  Popular Question (source)
2014-05-13 14:16:54 +0200 received badge  Student (source)
2014-05-13 14:13:20 +0200 asked a question Highlight the active row in Calc

I would really appreciate if you could make a feature that would allow to automatically highlight the active row (or the row and even the column) while moving in spreadsheet. It would greatly improve orientation in large tables.

Something like this: http://en.libreofficeforum.org/node/7548

Thanks!