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

 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? related: Highlight the active row in Calc 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!