Difference between revisions of "Gnumeric"

From ArchWiki
Jump to: navigation, search
(small wording fixes, rename section to "See also", create #Tips and tricks subsection, rm stub template)
m (spelling ; seperator > separator)
 
Line 11: Line 11:
 
== Tips and tricks ==  
 
== Tips and tricks ==  
  
Gnumeric respects your [[locale]] for the numeric decimal seperator and uses it for exporting, e.g. to .csv files, as well. For example
+
Gnumeric respects your [[locale]] for the numeric decimal separator and uses it for exporting, e.g. to .csv files, as well. For example
 
* with a german locale {{ic|de}}, a number shows as {{ic|0,5}} ''(comma)'',  
 
* with a german locale {{ic|de}}, a number shows as {{ic|0,5}} ''(comma)'',  
 
* with an english locale {{ic|en}}, a number shows as {{ic|0.5}} ''(dot)''.
 
* with an english locale {{ic|en}}, a number shows as {{ic|0.5}} ''(dot)''.

Latest revision as of 15:35, 12 February 2017

Gnumeric is a powerful spreadsheet application which can import and export in various formats including .csv, HTML, LaTeX, Lotus 1-2-3, OpenDocument Spreadsheet and Microsoft Excel.

Installing

Install gnumeric.

Optional dependencies are psiconv (for Psion 5 file support), python2-gobject2 (for python plugin support) and yelp (for viewing the help manual).

Tips and tricks

Gnumeric respects your locale for the numeric decimal separator and uses it for exporting, e.g. to .csv files, as well. For example

  • with a german locale de, a number shows as 0,5 (comma),
  • with an english locale en, a number shows as 0.5 (dot).

To start Gnumeric with a different locale, run

 LC_NUMERIC="en" gnumeric

See also