Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to prevent formulea updating if rows are Inserted / Deleted?

Hi, I'm using Calc (Version: 4.1.6.2) to generate a csv. To make use of formatting, data rages, and other Libre office features the file is in ods format with two sheets, the second sheet refers to data in the first and places text delimiters where needed, and is used to 'save as' in the required csv format. The issue I have run into is that when I insert or remove rows in sheet1 the relative addressing used in the formulae in sheet2 updates. I had thought I could try absolute addressing in the second sheet formulae but I already employ this with select parts of the formulae to allow for expansion in the number of rows and columns. I've been managing by selecting the top row in sheet2 and scrolling to the required length to renew the contents before exporting my file, but as I have 34 of these files to edit and some of them have as many as 12,000 rows, this scrolling is time consuming. Thanks for reading. Michael

How to prevent formulea updating if rows are Inserted / Deleted?

Hi, I'm using Calc (Version: 4.1.6.2) to generate a csv. To make use of formatting, data rages, and other Libre office features the file is in ods format with two sheets, the second sheet refers to data in the first and places text delimiters where needed, and is used to 'save as' in the required csv format. The issue I have run into is that when I insert or remove rows in sheet1 the relative addressing used in the formulae in sheet2 updates. I had thought I could try absolute addressing in the second sheet formulae but I already employ this with select parts of the formulae to allow for expansion in the number of rows and columns. I've been managing by selecting the top row in sheet2 and scrolling to the required length to renew the contents before exporting my file, but as I have 34 of these files to edit and some of them have as many as 12,000 rows, this scrolling is time consuming. Thanks for reading. Michael