How can I apply a function to cells in place in Calc?
0
votes
0
answers
22
views
I have a large table of numbers using the wrong decimal separator for my locale (dot instead of comma), so LibreOffice Calc does not parse them as numbers, but as strings. I can apply this function to a cell (A1 in this case) to parse it as a number:
NUMBERVALUE(A1; "."; "")
I know that I can create a side table where I would calculate the values using cell references and copy the results back to the original table. But that is impractical for a large table. How can I apply the function to all these cells at once without using any other cells?
Asked by matj1
(141 rep)
Apr 28, 2025, 11:57 AM