Yesterday and forever things like sum(xx:xx), value(xx), and today() worked.
Today as almost every day I download CSV data and start working with it. But the 3 functions above don’t work. I save as ods. Still don’t work.
I also can’t format a cell with contents 01/02/2026 as other date formats.
Is there a setting I can check?
LibreOffice 24.8
2.3 GHz 8-Core Intel Core i9
AMD Radeon Pro 5500M 4 GB
Intel UHD Graphics 630 1536 MB
16 GB 2667 MHz DDR4
MacOS Sequoia 15.5
Sorry no luck
I downloaded to csv. When the functions didn’t work I tried saving to odt, even closed it and opened again.
I found that the downloaded date data had a single tick in front:
'11/05/2025
I removed the tick and could format That Cell as mm/dd/yy.
But with “=value(f2)” in the cell to the right (g2), it only shows that text. Same with sum function.
They work an ods file that I’ve used for years. I’ve seen the single tick added to downloaded data before, but removing it has always allowed correct interpretation by Calc.
Might there be something off with the downloaded data? How could I check?
When importing the data, ensure that Detect special numbers under Other Options is checked.
That did it for those functions. Assume the rest will be ok. Thanks!