Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [gnumeric]

The tag has no usage guidance.

0
votes
0answers
42 views

How to make windows installer from Gnumeric source code

On the Gnumeric official web site http://www.gnumeric.org/ in download page there is only one option: download the source code of the latest release. So, the question is how can I make an installer (....
-1
votes
2answers
341 views

How to use MPIR with Visual Studio?

I am an academic and I need to develop some numerical algorithms which require functions from a package called MPIR http://mpir.org/downloads.html. I downloaded the 3.0.0 version and I am trying to ...
-1
votes
1answer
60 views

Return value pairs based on first row and column

Gnumeric has a nice tool for calculating correlations, but is limited in terms of specifying your output. It looks like this, Figure 8-7 : Correlations | pressure | distance | height pressure | ...
7
votes
1answer
2k views

“Save as csv” not available

How can I save single spreadsheet as a csv file in Gnumeric (version 1.12.28)? Going through File - Save As offers several file types like .gnumeric, .xls or .ods, but not .csv.
1
vote
1answer
28 views

How to mark elements of formula to “don't shift”

I have two worksheets in my Gnumeric file. In the first I have a lot of rows which contain an index. On the second I have the respective values for that index. Now, I can use the ­­index function to ...
2
votes
1answer
208 views

How to delete multiple rows in Gnumeric

When I select one row in Gnumeric I get the option to Delete 1 Row: When I select more than one in Gnumeric, I get a grayed out (non-functional) option to Delete 3 Rows: Clearly Gnumeric knows what ...
0
votes
1answer
181 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
47 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 ...
1
vote
2answers
297 views

Insert many rows in Gnumeric

Gnumeric is a spreadsheet program. There is Insert 1 row in the row context menu. But how to insert many row? Anything better than selecting Insert 1 row many times?
2
votes
1answer
352 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.
0
votes
1answer
120 views

How to get the average of the higher M values in N cells?

I have a spreadsheet with values in a matrix with several rows. For each row I have a N numbers. I want to calculate the average of the M higher values of the row. With M<N. Is there a common ...
1
vote
1answer
2k views

Binary spreadsheets with bitwise operators [closed]

I am looking for a way to easily construct binary spreadsheets using bitwise operators such as SHIFT, AND, OR and XOR. I've looked at Gnumeric but can't find any function that'd allow you to set the ...
1
vote
1answer
290 views

Gnumeric doesn't recognize numbers

I am trying to do some basic calculations (mostly finding the median of a range of values) using gnumeric. Unfortunately, this is giving me a hard time. Consider the following data: 0.04 0.04 0 0 0....
6
votes
1answer
747 views

Swap rows in gnumeric

Is there any convenient way to swap two rows in gnumeric? Currently I'm doing it the hard way: insert an empty row, move rows, and remove empty row. I hope that there is a better way...
1
vote
1answer
1k views

How can I open a subset of a large (35MB) .xlsx file?

I have Ubuntu 10.04 running on a Dell Optiplex with 4GB of memory and two 3.16GHz processors. I received a 35MB spreadsheet. It opened in Gnumeric after 5 minutes with errors, and it hasn't opened ...