quadratic
quadratic copied to clipboard
Durations in CSVs break on refresh
- Make a new file
- Drag this CSV file onto the grid at
A1 - Note that durations import correctly
- Put this Python code at
I1and run it:
import numpy as np
import pandas as pd
pd.DataFrame(np.vectorize(lambda s: str.strip(s) if isinstance(s, str) else s)(np.array(cells((1,1),(7,601)))))
- Refresh
Expected behavior: durations have their original values
Actual behavior: all durations have the value 0s