Ales isimli kullanıcının profili - etkinlik

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

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.

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

related: 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...

Thank you for your response. Done: fdo#78682

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!