gnumeric.txt

how to install Gnumeric 1.12.35 under Xubuntu 16.04.2 LTS
  wget http://ftp.gnome.org/pub/GNOME/sources/gnumeric/1.12/gnumeric-1.12.35.tar.xz
  tar xvf gnumeric-1.12.35.tar.xz
  cd gnumeric-1.12.35/
  ./configure
  make
  sudo make install
  sudo ldconfig
  
how to install Gnumeric 1.12.34 under Xubuntu 16.04.2 LTS
  wget http://ftp.gnome.org/pub/GNOME/sources/gnumeric/1.12/gnumeric-1.12.34.tar.xz
  sudo apt-get -y install libgtk-3-dev zlibc zlib1g zlib1g-dev intltool libgoffice-0.10 itstool byacc
  # hexchat is necessary to have "Help --> Live Assistance" working:
  sudo apt-get -y install hexchat
  # yelp is necessary for the help system to work
  sudo apt-get -y install yelp
  tar xvf gnumeric-1.12.34.tar.xz 
  cd gnumeric-1.12.34/
  ./configure 
  ./make
  sudo make install

Sorting preserves format
  Data --> Sort --> "Sorting preserves format"
  https://bugzilla.gnome.org/show_bug.cgi?id=780385

Paste special --> Region operation --> Transpose

This technical note describes how Gnumeric does calculations internally and why certain simple calculations like 0.3-(3*0.1) give unexpected non-zero results.
  http://www.gnumeric.org/numerical-issues.html