Libreoffice copy formula to entire column

I thought I could add a formula to the already existing values.

Subscribe to RSS

Working with data at that scale is the job special programs or, of database applications. Thanks for your valuable time Lupp. There is one remaining dilemma. If this gets very urgent, the only way I can think of is a bit of user programming. So, I thought there would be an easier way to add a formula to the entire column.

I am still wondering what you actually have and what you actually want, precisely. But is good enough to get a clear view of the numbers as I need. Reading your statements I feel not quite sure that you regard the fact that a cell already containing data cannot take a formula working on tthe data at the same time. Thank you for a detailed reply sir.

The unrounded values remains content or formula result of the cells.

Applying a formula to a whole column - English - Ask LibreOffice

One suggested method is: Select the cell containing the formula.

delete or copy the array

So, I thought there would be an easier way to add a formula to the entire column.

I have a column of numbers in decimal format. If applicable, ask again. It is very simple to get a formula work in a huge range of cells.

Creating a helper column and then copy paste with the new values is also tedious job as the file is a big one. Unfortunately there is no easy way to add a formula to cells already containing values. I would, however, dissuade from using it, because there are unclear and probably not stable implications. Actually the data is imported from a text file.

If the data are imported, the helper column should be the only recommendable way.