Questions tagged [gnumeric]

The tag has no usage guidance.

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
560 views

How do I import multiple csv files in gnumeric?

I am trying to import multiple csv files into gnumeric so that each one is a separate sheet in the workbook. This is relatively simple in Excel but I cannot work out how to do it in gnumeric.
1
vote
1answer
217 views

Importing numbers with leading zeros as text strings in gnumeric

I have a csv file with numbers, some that start with zeros. Those zeros are somewhat important to me. All the entries in the file are encapsulated with double quotes. Gnumeric's import dialogue ...
0
votes
0answers
18 views

Ubuntu 20.04 gnumeric 1.12.46 displays unicode boxes from older gnumeric files

I recently upgraded to Ubuntu 20.04 and just discovered all my old gnumric files do not display correctly. All text and numeric fields in the spreadsheet show up as hex codes in little boxes, like ...
0
votes
0answers
5 views

How to specify output file cell format when using ssconvert --merge-to to create ODS file from multiple CSVs?

I successfully converted a series of .csv files into a single .ods spreadsheet file, but I had a minor formatting problem: all cells with date contents ended up with date and time format. Command used:...
0
votes
0answers
61 views

Prepend text for spreadsheet

I want to have a string value prepended to a XL-style formating in a spreadsheet program (gnumeric). The current formatting is [$-f4f2]hh:mm which should take 1:00 PM as input and convert/display it ...