off by one

Categories: pedro | technical:posterity


Mon Feb 10 13:04:27 PST Gnumeric File Reference "unknown workbook" Error:

If you have file references in Gnumeric (you refer to different workbooks using a reference like:

=[bookname.gnumeric]Sheet!A1

... the references will not resolve unless the other workbooks are opened *in the same gnumeric instance*. This means, for example, that if you open Nautilus, select all the workbooks, and open them in Gnumeric, that your references will not work. Instead, they will all be quoted; that is, they will look like this:

'=[bookname.gnumeric]Sheet!A1

Don't be alarmed -- your sheets have not been changed. Trying to manually remove the "'" will just throw up an error about a referral to an "unknown workbook."

The issue is that, as I said up top, all the sheets must be opened in the same instance of Gnumeric. It's not obvious in any way that open windows of Gnumeric may not be the same "instance" so this can be confusing. The solution is to open one of the documents, or a "new" Gnumeric instance, and then open the linked documents from within a single application instance.

I never used linked sheets in Excel, so I'm not sure if this is typical spreadsheet behavior or not. I'm frankly surprised that the sheets need to be open to be viewed... I think Gnumeric should be able to open linked sheets as long as the paths are right, but that's just me... anyway, HTH, HS (happy spreadsheeting)!

Wed Mar 13 08:59:46 PST What kind of object is this R variable, anyway?:

Numerous ideas here, with the first being:

R> typeof(something)

In other news, I've decided to just start posting all the questions I end up looking up, since I often have to find them again, and I believe in "upvoting" them for posterity.

Sat Feb 16 20:46:57 PST oh yeah!:

Run a sequence of SQL statements in a script and spit the output to a file:

shell> mysql db_name < script.sql > output.tab


[Main]

Unless otherwise noted, all content licensed by Peter A. H. Peterson
under a Creative Commons License.