Gnumeric Question
 

I was wondering if anyone knew an easier way to switch between sheets other than a half dozen clicks. The main file Im concerned about this with is a spreadsheet I use to keep track of my movies on my pc (almost 900) and I have a sheet for each genre, 11 in total. Is there no way we can have the tabs display at the bottom like on open office? I just need an easier way to switch between sheets. Any help is much appreciated. :)

Re: Gnumeric Question
 

Not that I could ever find. Unfortunately gnumeric hasn't been completely hildonized, so some dialog windows are garbled and there are no tabs(gnumeric should have tabs), and no context menus. The hotkey to switch sheets is Ctrl+PageUp/PageDown, but I have a n800 so not much use for me, don't know if it would work for n810.

Re: Gnumeric Question
 

Is there an equivalent of page up/down on the N810, which is what I have?

Re: Gnumeric Question
 

I wasn't sure if the n810 did or did not have a Page Up/ Downs keys or not. In theory, I think you could remap another key to be PageUp PageDown, though I don't know if you would want to do that or not. Look up remapping n810 keys, to find some info on how to do it.

Re: Gnumeric Question
 

Is there possibly any kind of configuration file in gnumeric that could be edited to change the keyboard shortcut for changing sheets?

Re: Gnumeric Question
 

Unfortunately no, there is no editing of the keybindings from the gnumeric program. You would have to edit and recompile it.

Re: Gnumeric Question
 

Gnumeric needs some love like the recent Abiword updates to make it more Hildon-friendly. I moved from the spreadsheet in Documents To Go on Palm which had a nice drop-down menu in the top-right to change sheets within a workbook, which worked well. E.g.
http://www.linuxdevices.com/files/mi...dtg_spread.jpg

Re: Gnumeric Question
 

Id like to see the tabs implemented as a toolbar you can turn on and off....I would rather scroll vertically more than horizontally.

Re: Gnumeric Question
 

I was just sitting here thinking, that it would be great if we could take the existing productivity apps that we have Gnumeric, Abiword, Xournal, and merge them into Maemo Office suite. Surely someone has the desire besides me?

Re: Gnumeric Question
 

Actually I think in the development branch of gnumeric, since 1.9.4 or so, they moved the tabs to the statusbar, which can be toggled of and on, but the current stable version of gnumeric has tabs at the bottom and they can't be turned off.

Re: Gnumeric Question
 

Which repo is a newer version in...I checked extras devel and nothing there.

Re: Gnumeric Question
 

Sorry, I was just talking about gnumeric in general, it's a Gnome desktop app that can run on maemo, but it runs on regular desktop Linux and WIndows and OS X. We only have a modified version of 1.8.3 to run on maemo.

The 1.9 branch is a development branch, so it might have other issues. To get it you would have to compile it for maemo, no easy task.

Re: Gnumeric Question
 

Ahh, ok yeah I knew about the desktop version, I used to use it before open office.

Re: Gnumeric Question
 

Gnumeric is one of those apps that I don't use regularly on Maemo, but when I do it's invaluable (whether it's doing cashflows, tax calculations, graphing some data etc.)

I hope we'll see a Fremantle version.

Re: Gnumeric Question
 

Maybe the easy-debian version of Gnumeric would adress your problem... it can display a sheet selector and allow you to switch sheets easily.

--denis

Re: Gnumeric Question
 

I had that installed, was just too slow for me unfortunatly, not to discount all the hard work the developers done on it.

Re: Gnumeric Question
 

I was very annoyed by having to muck around in the menus each time I wanted to change sheets, and was about to convert all of my spreadsheets to text files, when I happened upon this file:
In this file there are sections to change the layout of the menus and the toolbars. Scroll down to the <toolbar name="StandardToolbar"> bit and add the following line below it:
Hey presto! Now I have a button at the beginning of the toolbar which takes me directly to the Manage Sheets dialog.

Re: Gnumeric Question
 

Awesome! Thanks alot! Any idea how I might change it so that I can set a small icon to display rather than the big button?

Re: Gnumeric Question
 

If you look through the menus you will see that some of the items have icons and some don't. I'm guessing that the Manage Sheets function simply doesn't have an icon. Let me know if you figure it out!

By the way, I also added the following:
So now I have quick buttons for sheets and full screen, and a nice little separator to block them off from the rest of the buttons. I don't know if it was necessary, but I went down the rest of the toolbar items and bumped up the rest of the separator names to std-sep2, std-sep3, etc.

Re: Gnumeric Question
 

Nice .... Works like a charm!

Re: Gnumeric Question
 

Another question: In the "File" menu can I increase the 3 recently viewed files to 6?