Disclaimer

This information HAS errors and is made available WITHOUT ANY WARRANTY OF ANY KIND and without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. It is not permissible to be read by anyone who has ever met a lawyer or attorney. Use is confined to Engineers with more than 370 course hours of engineering.
If you see an error contact:
+1(785) 841 3089
inform@xtronics.com

Gnumeric

Tricks

Fraction Text to decimal

Where B1 is the source of the fraction

=left(C24,find("/",C24,1)-1)/right(C24,len(C24)-find("/",C24,1))

Swap columns to rows

1. Select range and copy - then Esc
2. Paste Special - Transpose

Reverse table order

1. Select range and copy - then Esc
2. Paste Special - Flip Horizontally or Vertically