Change default measure from imperial to metric in Spreadsheet

I recently upgraded LibreOffice to ver.7.0.5.2, and wish to change the default units of measurement from Imperial to Metric - but all responses keep referring me to Tools/Option in order to do this - but my version of LibreOffice Spreadsheet does not include this option under Tools - can you help, any assistance would be greatly appreciated

Are you perchance a Mac user? If so, LibreOffice | Preferences is the menu you need; or keyboard shortcut Command+Comma.

If this answer helped you, please accept it by clicking the check mark ? to the left and, karma permitting, upvote it. That will help other people with the same question.

In case you need clarification, edit your question (don’t use an answer) or comment the relevant answer.

Yes I am a Mac user & the info was in LibreOffice/Calc/General/Metrics & thereby it also updated Spreadsheet - thanks heaps

Thus it is useful to mention your OS and LO version when asking a question.

yes indeed I will in future thanks again