How can I select that element from a vector of Gnumerc / Excel of which the difference of a given cell is minimal?
I would like to do a goal seek in gnumeric / Excel. I would also like to make a column of data, which values are selected from a vector (range) based on minimal difference to a given cell. What ...
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.
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 ...
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 ...
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...