Recent I found an error with physic’s formulas.
It’s there any method to define custom units like meters, seconds, distance or any SI unit?
Something like: A1=10 meters / 5 seconds = 2 m/s
Do you want make calculations with the units? And do you expect that the unit of the number will be automatically “calculated” with the result in same cell?
I never heard such feature of the Calc application…
No, Calc has no understanding of units. It can only cakculate with numbers.
.
What you can do is defining formats like it is done for currencies.
A cell will hold 1234.56 and show instead $ 1,234.56
https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html
.
But there is no check, if your units are right. Calc will show °C instead of m/s if you tell so.
1 Like
While not a solution in the frame of Calc (or other spreadsheet software I know), maybe you need something like Mathcad (or similar free tools like Smath Studio). They allow using units in a nice and sensible way in calculations, making it possible to do things like
And they support arrays, making it possible to do calculations over large arrays of data. They also may have plugins to import/export data from/to spreadsheets.
1 Like
Additional to the already given good comments ( except the useless AI-Screenshot )
https://physipy.readthedocs.io/en/latest/
on the same site is also:
https://physipy.readthedocs.io/en/latest/misc/alternative-packages/alternative-home.html
would need some AI plugin …
