Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to prevent cross-references from changing when shifting cells?

I have used LibreOffice Calc for fifteen years, previously OOo, but now I observe a strange change in behavior.

If I set A1 to "=B1", it shows the value of B1.

If I then drag B1 to another location, the code inside A1 suddenly changes to B1's new location.

This change in behavior is extremely frustrating, as I have many large spreadsheets, and its filling the data with errors everywhere. Now, every time I shift a single cell or worse, a whole group of content, I risk some other cross-reference somewhere else in the Calc file being pointed to the wrong place, and it is a ton of work to correct each time.

How can I disable what appears to be a new behavior for Calc? LibreOffice, Version: 5.2.7.2

How to prevent cross-references from changing when shifting cells?

I have used LibreOffice Calc for fifteen years, previously OOo, but now I observe a strange change in behavior.

If I set A1 to "=B1", it shows the value of B1.

If I then drag B1 to another location, the code inside A1 suddenly changes to point to B1's new location.location, so instead of showing the blank value, or 0, it is showing F3 or where ever I moved B1 to.

This change in behavior is extremely frustrating, as I have many large spreadsheets, and its filling the data with errors everywhere. Now, every time I shift a single cell or worse, a whole group of content, I risk some other cross-reference somewhere else in the Calc file being pointed to the wrong place, and it is a ton of work to correct each time.

How can I disable what appears to be a new behavior for Calc? LibreOffice, Version: 5.2.7.2

How to prevent cross-references from changing when shifting cells?

I have used LibreOffice Calc for fifteen years, previously OOo, but now I observe a strange change in behavior.

If I set A1 to "=B1", it shows the value of B1.

If I then drag B1 to another location, the code inside A1 suddenly changes to point to B1's new location, so instead of showing the blank value, or 0, it is showing F3 or where ever I moved B1 to.

This change in behavior is extremely frustrating, as I have many large spreadsheets, and its filling the data with errors everywhere. Now, every time I shift a single cell or worse, a whole group of content, I risk some other cross-reference somewhere else in the Calc file being pointed to the wrong place, and it is a ton of work to correct each time.time. Sometimes I have dozens of sheets that have to be entirely redone!

How can I disable what appears to be a new behavior for Calc? LibreOffice, Version: 5.2.7.2

How to prevent cross-references from changing when shifting cells?

I have used LibreOffice Calc for fifteen years, previously OOo, but now I observe a strange change in behavior.

If I set A1 to "=B1", it shows the value of B1.

If I then drag B1 to another location, the code inside A1 suddenly changes to point to B1's new location, so instead of showing the blank value, or 0, it is showing F3 or where ever I moved B1 to.

This change in behavior is extremely frustrating, as I have many large spreadsheets, and its filling the data with errors everywhere. Now, every time I shift a single cell or worse, a whole group of content, I risk some other cross-reference somewhere else in the Calc file being pointed to the wrong place, and it is a ton of work to correct each time. Sometimes I have dozens of sheets that have to be entirely redone!

How can I disable what appears to be a new behavior for Calc? LibreOffice, Version: 5.2.7.2

How to prevent cross-references from changing when shifting cells?

I have used LibreOffice Calc for fifteen years, previously OOo, but now I observe a strange change in behavior.

If I set A1 to "=B1", it shows the value of B1.

If I then drag B1 to another location, the code inside A1 suddenly changes to point to B1's new location, so instead of showing the blank value, or 0, it is showing F3 or where ever I moved B1 to.

This change in behavior is extremely frustrating, as I have many large spreadsheets, and its filling the data with errors everywhere. Now, every time I shift a single cell or worse, a whole group of content, I risk some other cross-reference somewhere else in the Calc file being pointed to the wrong place, and it is a ton of work to correct each time. I have dozens of sheets that have to be entirely redone!redone due to this strange behavior!

How can I disable what appears to be a new behavior for Calc? LibreOffice, Version: 5.2.7.2