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)
 
(4 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
[[Category:Office]]
 
[[Category:Office]]
{{Stub}}
+
[[ja:Gnumeric]]
 
+
[[Wikipedia:Gnumeric|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.
[[Wikipedia:Gnumeric|Gnumeric]] is the most 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 ==
 
== Installing ==
  
[[pacman|Install]] {{pkg|gnumeric}} from the [[Official Repositories]].
+
[[Install]] {{pkg|gnumeric}}.
  
 
Optional dependencies are {{pkg|psiconv}} (for Psion 5 file support), {{pkg|python2-gobject2}} (for python plugin support) and {{pkg|yelp}} (for viewing the help manual).
 
Optional dependencies are {{pkg|psiconv}} (for Psion 5 file support), {{pkg|python2-gobject2}} (for python plugin support) and {{pkg|yelp}} (for viewing the help manual).
  
=== decimal separator ===
+
== Tips and tricks ==  
 
+
Gnumeric is depending on  your locale and use it for exporting as csv file too. For example, octave use dot decimal seperator.
+
 
+
Display 1/2:
+
 
+
With german locale "de", Gnumeric shows 0,5 ''(comma)''
+
  
With englisch locale "en", Gnumeric shows 0.5 ''(dot)''
+
Gnumeric respects your [[locale]] for the numeric decimal seperator 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 an english locale {{ic|en}}, a number shows as {{ic|0.5}} ''(dot)''.
  
To start Gnumeric with a different locale, just run
+
To start Gnumeric with a different locale, run
 
   LC_NUMERIC="en" gnumeric
 
   LC_NUMERIC="en" gnumeric
  
== External Resources ==
+
== See also ==
 
* [http://projects.gnome.org/gnumeric/ Gnumeric Official Website]
 
* [http://projects.gnome.org/gnumeric/ Gnumeric Official Website]

Latest revision as of 20:14, 24 June 2016

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 seperator 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