Stack Overflow
Stack Overflow

Questions tagged [gnumeric]

Gnumeric is a spreadsheet program that is part of the GNOME Free Software Desktop Project.

Gnumeric is a GNU GPL licensed spreadsheet program intended to replace proprietary and other spreadsheet programs such as Microsoft Excel, which it broadly and openly emulates.

45 questions
20
votes
3 answers

How to import .ods?

I'm trying to import data (.ods file) and I know how to import .csv, .xls etc. but I strand all the time. I tried it with the package Gnumeric but R tells me that the required program 'ssconvert' cannot be found.
Thomas
  • 1,392
  • 3
  • 22
  • 38
8
votes
2 answers

View semicolon-separated .csv files in gnumeric

I have a semicolon-separated csv file over here, and I would like to be able to look at it with gnumeric. Sadly, gnumeric does not read the semicolon as a separator. I have tried: appending sep=; on the first line clicking through the GUI…
TheChymera
  • 17,004
  • 14
  • 56
  • 86
8
votes
2 answers

Paradox database file

I found paradox database files with different extension. There are db file, mb file, dat file, px file, XG0 file, XG1 file, XG2 file, XG3 file, XG4 file, YG0 file, YG1 file, YG2 file, YG3 file and YG4 file. I already found way to open db file and px…
prem
  • 95
  • 1
  • 1
  • 5
5
votes
2 answers

Changing Gnumeric text import export default settings

I am using the Gnumeric spreadsheet to import, update, then export csv files delimited by the pipe "|" separator. Gnumeric by default saves it's files as xml via its .gnumeric file extension. Therefore a user needs to import files via Data > Get…
user1888167
  • 131
  • 3
  • 9
4
votes
1 answer

Gnumeric Sort function

Can someone please direct me to a detailed explanation (link) of the Gnumeric sort function? The Gnumeric manual is abbreviated and has no examples. I haven't been able to find any appropriate info through the search engines and even Stackoverflow…
Johnny
  • 41
  • 2
4
votes
2 answers

Replace or ignore new line character when converting .ods files to .csv files

I'm using ssconvert in Gnumeric to convert a bunch of ODS files to CSV files with the command: ssconvert -O 'separator=; quoting-mode=never' "f.ods" "f.txt"; which works out great ... most of the time. Sometimes, there are cells where the user has…
Speldosa
  • 1,900
  • 5
  • 21
  • 36
4
votes
2 answers

How to convert .csv to .xls

I have a simple .csv file. Is it possible to convert it to .xls using the command line tool ssconvert? I would also need to specify the name of the sheet.
RockScience
  • 17,932
  • 26
  • 89
  • 125
3
votes
3 answers

Make spreadsheet save in human-readable format for version control

Apparently Gnumeric's native file format is compressed xml. Diffing binary files isn't easy, so you lose many of the advantages of version control. Is it possible to get it to save (and load) its files in straight xml (or any other human readable…
John Lawrence Aspden
  • 17,124
  • 11
  • 67
  • 110
3
votes
0 answers

How to add data labels on a chart?

I would like to add data labels for some values like "TIMEOUT" on bar chart in Gnumeric. As in the image below with "Not supported" string: I know it is possible in Excel, but is it possible in Gnumeric, and how?
Umair Qudus
  • 81
  • 8
2
votes
1 answer

Gnumeric/LO Calc - how to get cell background color?

I have large spreadsheet, with rows colored according to no regular rule, so the cell color cannot be determined by the cell entries. I want to lookup the cell color and use it as value. Spreadsheet is like this: ---------- data|data| <--…
vlad
  • 771
  • 2
  • 10
  • 21
2
votes
0 answers

Problem when compile gnumeric from source

I'm trying to compile gnumeric 1.12.45 from source. The building is done and it works but when the windows open, it shows a lot of warnings. For example, there are multiple lines of warnings like this, CRITICAL **: 19:10:06.028:…
David Ozc
  • 31
  • 2
2
votes
1 answer

Creating TAB-separated values from .xlsx with ssconvert

Due to commas within cell values, I am not able to use the ssconvert utility for .xls(x) to .csv conversion. Is there a possibility to create tab-separated values directly from xlsx with ssconvert (command line spreadsheet format converter)?…
corinna
  • 629
  • 7
  • 18
2
votes
0 answers

How do I get 'ssconvert' to embed off-sheet references?

I have this working, using Gnumeric's ssconvert: ssconvert --merge-to=merged.xls test1.csv test2.csv test3.csv It happily imports formulae, such as =MIN(G2:G4) correctly. The problem I have is with off-sheet references. How do I, with the above…
Peter Brooks
  • 349
  • 3
  • 13
2
votes
1 answer

How to prevent `ssconvert` recalculating Excel file before conversion?

I am trying to convert the .xlsx file http://www.eia.gov/forecasts/steo/archives/mar14_base.xlsx into a .csv, but it seems that the .xlsx contains formulae that link to a local file that I don't have (the creator of the file must have forgotten to…
RockScience
  • 17,932
  • 26
  • 89
  • 125
2
votes
1 answer

Gnumeric Python plugin : service file_opener and file_saver

Is it possible to write a gnumeric python plugin for the file_opener and file_saver service? It seems implemented in the python-loader plugin, there are corresponding sections in the Gnome documentation. But the example plugin gnome-glossary, which…
jacquarg
  • 176
  • 1
  • 7
1
2 3