Ask Your Question
0

Calc question - contents of target cell changes when source cell moves.

asked 2018-12-12 07:05:54 +0200

Agal59 gravatar image

On page one I have a cell that is the source. On page two I have a cell that contains the contents of the source cell. Regardless of where the source cell moves (through sorting) I want the target cell to always contain the contents of the source cell. Additionally, regardless of where the target cell moves (row or column deletions/additions) I want it to always contain the contents of the source cell. I've not been able to find a way to make this happen. Can someone help?

edit retag flag offensive close merge delete

Comments

How do you make a link between source cell and second cell on second sheet?

kompilainenn gravatar imagekompilainenn ( 2018-12-12 07:17:33 +0200 )edit

=$PageOne.$D$8 I have been trying this construct with/without '$'.

Agal59 gravatar imageAgal59 ( 2018-12-12 07:27:55 +0200 )edit

What version?
Same behaviour in LibO >Help>Restart in Safe Mode... or after a reset of the user profile?

Lupp gravatar imageLupp ( 2018-12-12 12:55:52 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2018-12-12 11:03:48 +0200

updated 2018-12-12 11:26:20 +0200

Hello, @Agal59 Thanks a lot for asking.

1). Please check un LO settings under LibreOffic Calc -> General if Update references when sorting range of cells is enabled.

2). I believe it is natural Calc behavior - to keep cell reference to the source cell after inserting new column/row. =$PageOne.$D$8will transform for example to =$PageOne.$E$8 or =$PageOne.$D$9if you insert new column/row on PageOne sheet, and Calc will keep =$PageOne.$D$8 if you add new column/row in the sheet which contains this formula.

edit flag offensive delete link more

Comments

Thanks for good questions can be expressed by upvoting.

Lupp gravatar imageLupp ( 2018-12-12 12:47:04 +0200 )edit

Thank you for 'Update references ....'. My target cell is now following the source cell when the Sort operation is used.

Agal59 gravatar imageAgal59 ( 2018-12-13 08:23:20 +0200 )edit
0

answered 2018-12-12 12:42:31 +0200

Lupp gravatar image

updated 2018-12-13 14:36:59 +0200

-1- Calc keeps the "physical" cell (you may recognise it based on a constant content or a specific hard attribute) referenced if it was moved by insertion/deletion of rows/columns or by dragging with the mouse. This means that the "AbsoluteName" (address as a string with "$" characters) must change.

-2- If your question actually concerns behaviour under sorting:
I would never advise to enable Update references when sorting range of cells. There was a version once introducing this behaviour and there were lots of issues in practical use. (There are logical implications.) Based on these experiences the mentioned option was created and set not enabled by default.

-3- Since a sheet doesn't know about operations in a different document/file, the above does not apply to external references.

-4- I would recommend to not regard sorting as moving cells but as moving contents (contents+properties if enabled).

===Edit 2018-12-13 14:35 CET===
You may want to study the discussion of bug tdf#81633 and related bugs to find out what I meant by "implications".

edit flag offensive delete link more

Comments

Thank you for 'Update references ....'. My target cell is now following the source cell when the Sort operation is used. I am going to have to think about your idea of 'moving cells' vs. 'moving contents'.

Agal59 gravatar imageAgal59 ( 2018-12-13 08:26:23 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-12-12 07:05:54 +0200

Seen: 48 times

Last updated: Dec 13 '18