Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Problem with CELL("contents") in Calc

I want to retrieve the last entered or updated text from some rows a column (not necessarily the last row), as I'm following this video; https://www.youtube.com/watch?v=0QrQT9D25Xk that's actually an excel video. In this video they are using a formula like this;

=CELL("contents")

I try to use that in LibreOffice Calc, but I keep getting an errormessage (504) Is there any other way I can do the same thing?

Problem with CELL("contents") in Calc

I want to retrieve the last entered or updated text from some rows a column (not necessarily the last row), as I'm following this video; https://www.youtube.com/watch?v=0QrQT9D25Xk that's actually an excel video. In this video they are using a formula like this;

=CELL("contents")

I try to use that in LibreOffice Calc, but I keep getting an errormessage (504) Is there any other way I can do the same thing? I don't want to use VBA or macros.

Problem with CELL("contents") in Calc

I want to retrieve the last entered or updated text from some rows a column (not necessarily the last row), as I'm following this video; https://www.youtube.com/watch?v=0QrQT9D25Xk that's actually an excel video. In this video they are using a formula like this;

=CELL("contents")

I try to use that in LibreOffice Calc, but I keep getting an errormessage (504) Is there any other way I can do the same thing? I don't want to use VBA or macros.