Re: [libreoffice-users] Opening all files in a folder

Hi :)
There might be a more elegant way of doing this (such as using a database instead) but my way would 
be; 
1.  to plan to group them into groups of 2-5 tabs per file.  
2.  create a copy of the big, main, unwieldy file.  
3.  create enough files and give them reasonable names to make it easy to find the right one in the 
future, bearing in mind that new tabs might be added later.  Delete all tabs except for 1 of them 
in each file, you'll be deleting that one later but every file needs at least one tab so you have 
to keep it temporarily.  
4.  Open the big, main, unwieldy file (the one with tooo many tabs at the moment) and the file that 
would contain the tab that opened first.  
5.  Back in the main file right-click on the tab and choose "Move or Copy Sheet".  In the pop-up 
dialogue-box the default is to "Move".  There should be a drop-down in "Location" that allows you 
to choose the relevant file.  It calls the file a document, same thing really.  
6.  Save the new file and check that when you open it the new file still contains the tabs you 
moved.  
7.  Once you are certain the tab is in the new file/document than save the big, main unwieldy one.  
When you save it the file wont contain the tab and it over-writes the version on your drive so you 
risk losing the tab at this point.  You do have the back-up created in step 2 but using that tends 
to create confusion.  Ideally we want to avoid needing to use it at all.  
8.  At first you might have to do this 1 tab at a time, 1 file/document at a time but hopefully the 
unwieldy original document becomes lighter-weight and easier to deal with so eventually you might 
be able to move more than 1 sheet/tab at a time and maybe have more than 2 files open at the same 
time.  Also as the main, old file gets lighter it becomes easier to move tabs in a more logical 
sequence rather than just moving whichever tab happens to be open when you open the file.

I think i would seriously consider making the back-up copy into a proper database at some point but 
if you haven't made a database before it can seem daunting.  In the longer-term a database is 
likely to be the best answer and it's not as tough as it seems but there is a bit of a learning 
curve and you probably just need something in a hurry.  

Regards from
Tom :)


--- On Sun, 13/5/12, Kelly Holman <kcholman@gmail.com> wrote:

From: Kelly Holman <kcholman@gmail.com>
Subject: [libreoffice-users] Opening all files in a folder
To: users@global.libreoffice.org
Date: Sunday, 13 May, 2012, 6:54

In LO Basic, is there a way to open, and get data from, all the
spreadsheet files in a folder?

I have a spreadsheet with lots of tabs that is unwieldy to use on my
smartphone. I'd like to split it up into several files. I know how to
iterate through all the tabs and get the data, but if I split them up,
I don't know how to iterate through the files, if I don't have the
names. And the names have to be client names, so I can recognize them,
not numbers that would make them easy to iterate until one isn't
found.

Thanks!


-- 
~~~~~
Kelly C. Holman
Hidden Talents Tutoring
Menomonie, WI
715-231-2191

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted