Hi all,
I’ve lost confidence with Libre Office as I didn’t have a chance to use it for many years…
I have a few spreadsheets in various dirs. In each dir there is a (common) menu listing all the others.
In older times - when I still used Win$ows (or even Dos) - I used to switch between the various spreadsheets just typing a key combination, such as ‘CTRL+X’ (X being a letter from A to G) that took me to the chosen spreadsheet.
Is there a way to do the same in Libre Office (run under GNU Linux/Debian)?
Thanks for your attention,
ennio
" I have a few spreadsheets in various dirs. In each dir there is a (common) menu listing all the others."
What a “Menu” do you mean? What type of files that “Menu” is? Is it an another Spreadsheet file?
Inside LO I’d use hyperlinks or put Macros on Ctrl-A… etc if I don’t need this Keys for other purposes.
Outside LO I would create the Menu once as html and link to this file from other directories.
But as we have powerful search boxes in Startmenu of most OS this approach may be easier now…
I ‘discovered’ hyperlinks yesterday but my first attempts to use them took me nowhere. I tried to register in a macro the few steps taken to move from one dir to another (all belonging to the same project) also but for some reason got nothing registered.
Thanks for your help. anyway. ennio
Zizi64 asked:
What a “Menu” do you mean? What type of files that “Menu” is? Is it an another Spreadsheet file?
It is an .ods file, but could well be a normal text file, as it contains a simple list of names, referring to other spreadsheets that could be reached (in the original Lotus 123) typing ‘ALT+X’. Something like:
------- MENU --------
A - Other Files (file foo, file dum, …) /
B - John’s Situation ( …, …, …) /
… /
X - Testing Files under review /
-------------------------- /
In other words, what I’m looking for, is the possibility to associate to a ‘shortcut-key’ the LO command sequence: /
“File/Open/click to go back one dir/choose a new dir/”
I’m sorry: probably this is not the correct way to interact but hope learn do better in future, ennio