Opening all files in a folder

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: [hidden email]
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

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 <[hidden email]> wrote:

From: Kelly Holman <[hidden email]>
Subject: [libreoffice-users] Opening all files in a folder
To: [hidden email]
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: [hidden email]
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: [hidden email]
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

Thanks for the detailed instructions -- I wouldn't have thought of
some of those things until I was in the middle of it.

I also thought of doing an archive file and a current file. However,
part of the problem is that when I'm entering data from the
smartphone, it doesn't show me the tab name. I'm quite absent-minded
enough to enter the data for the wrong client, because it opens into
whatever tab I used last, and I can't see the name at the top when I'm
down in the list.

Another solution would be to put the client names = file names in
another file. It would mean an extra step when adding a new client,
but at least it would be a simple step, if I can't get the names of
all the files.
I'll have to ponder which of these ways will be the best. Yes, this
would work better in a database, but I need to be able to enter the
ledger data from my phone, and have it give me the current balance.
And I need to do calculations on the computer, but still have all the
data in the spreadsheet, available on the phone.

Thanks!


On 5/13/12, Tom Davies <[hidden email]> wrote:
> 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.

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

--
For unsubscribe instructions e-mail to: [hidden email]
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

Hi :)
I was thinking of file-names such as "Clients-Ab-Am" ... "Clients-V-Z" or perhaps by date although by date ends up being a nightmare.  Alphabetical is usually easier. 

I'm not sure how smart-phones work but i imagine they have folders and sub-folders so a  sub-folder called "Clients" containing all these files would be easy to scroll through to find the relevant file quite quickly.  With some OSes If you type the first letter of the file you are looking for then it automatically scrolls to roughly the right area. 

Regards from
Tom :)



--- On Sun, 13/5/12, Kelly Holman <[hidden email]> wrote:

From: Kelly Holman <[hidden email]>
Subject: Re: [libreoffice-users] Opening all files in a folder
To: [hidden email]
Date: Sunday, 13 May, 2012, 8:32

Thanks for the detailed instructions -- I wouldn't have thought of
some of those things until I was in the middle of it.

I also thought of doing an archive file and a current file. However,
part of the problem is that when I'm entering data from the
smartphone, it doesn't show me the tab name. I'm quite absent-minded
enough to enter the data for the wrong client, because it opens into
whatever tab I used last, and I can't see the name at the top when I'm
down in the list.

Another solution would be to put the client names = file names in
another file. It would mean an extra step when adding a new client,
but at least it would be a simple step, if I can't get the names of
all the files.
I'll have to ponder which of these ways will be the best. Yes, this
would work better in a database, but I need to be able to enter the
ledger data from my phone, and have it give me the current balance.
And I need to do calculations on the computer, but still have all the
data in the spreadsheet, available on the phone.

Thanks!


On 5/13/12, Tom Davies <[hidden email]> wrote:
> 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.

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

--
For unsubscribe instructions e-mail to: [hidden email]
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: [hidden email]
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

My phone would have no trouble with the multiple files -- that
solution will work. It just can't do databases.

On 5/13/12, Tom Davies <[hidden email]> wrote:

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

--
For unsubscribe instructions e-mail to: [hidden email]
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