In Libreoffice Calc, is there a way to convert a column of numbers in-place, such as converting from miles to kilometers, or percent to decimal?  I know how to do it by: adding a temporary column, applying a formula, copying the new column, paste-special onto the old column, deleting the temporary column. So the keyword is in-place, to avoid the addition/deletion of the temporary column.
Calc: How to convert a numeric column in-place?
libreoffice;spreadsheet
If adding one cell value is acceptable: enter the conversion factor in any empty cell (even on another sheet), select Paste Special, and select the approrpriate calculation below of Transpose.E.g., to convert between inches and centimeters:enter the factor 2.54 in an empty cell;copy that cell;select the values to convert;Menu Edit -> Paste Special;Under Operations, select the arithmetic operation to use; for in -> cm, select multiply; for cm to in, select divide:Without any modification of the sheet's content: then you'll have to create a macro that applies a pre-defined arithmetic operation on every cell in a defined / selected range.