Ask Your Question
0

Problem with CELL("contents") in Calc

asked 2018-12-17 21:21:37 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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=0QrQT... 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.

edit retag flag offensive close merge delete

Comments

Would you, please, describe exactly what =CELL("contents") returns in EXCEL?
Please avoid to refer to yotube videos if avoidable at all. Few people here can afford the time to watch that boring stuff. Give information instead.

Lupp gravatar imageLupp ( 2018-12-17 22:16:20 +0100 )edit

In this case it returns the last input, or change, to any cell in the document! If you look at the first minutes or so of the video you'll understand. I need something like this to pass the value in a cell to make some searchable dropdownmenues

abrj gravatar imageabrj ( 2018-12-17 22:23:00 +0100 )edit

Well, I might have better understood your question if it was worded as in your comment above or like "I want an implicit reference to the last cell that was edited". The answer then had been "There isn't such a built-in functionality in LibreOffice Calc.
Did someone tell you what the function with that flag will return if many cells changed their content in one go (by insertion into a range e.g.)?

Lupp gravatar imageLupp ( 2018-12-17 23:02:30 +0100 )edit

If I use =CELL("contents") in Excel, let's say in cell A1, and then type text in some other random cell, I'll see that in cell A1. I'm looking for something similar in CALC

abrj gravatar imageabrj ( 2018-12-17 23:09:29 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-12-17 22:42:36 +0100

Lupp gravatar image

updated 2018-12-17 23:14:05 +0100

===Edit1===
There is no function (with any flag / argument) in Calc returning the current value of the most recently edited cell.
=== End Edit1===

In LibO the CELL() function also is available (for compatibility assumably), and can be used with the flag "contents". It then returns - no, not the content which might be a formula, but - either the constant content (constant string, constant number) or the formula result without any formatting. To understand the relevance of "witout any formatting" you need to realise that there are some cases where a direct reference not only gets the value but also a format setting of the 'Numbers' format type. This is in force if the referenced cell has a date format, the logical (Bolean) format or a currency format. (That's bad , but fact again.) Otherwise =CELL("contents";A2) will return the same result as =A2 would do.

edit flag offensive delete link more

Comments

If I use =CELL("contents") in Excel, let's say in cell A1, and then type text in some other random cell, I'll see that in cell A1. I'm looking for something similar in CALC

abrj gravatar imageabrj ( 2018-12-17 23:09:42 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-12-17 21:21:37 +0100

Seen: 23 times

Last updated: Dec 17 '18