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