[Solved] Coping titles of folders

Discuss the spreadsheet application

[Solved] Coping titles of folders

Postby bre_pat_2 » Sun May 22, 2011 9:40 pm

I need to make a directory of my embroidery designs. there are several hundred of them and I was hoping to just copy and paste the names of the folders on a spreadsheet and then do the same with the subcatagories. Unfortunatly it is not working as I had hoped. It will not paste to a spreadsheet and when I try pasting it to text document it comes up with a bunch of jibberish and it will not allow me to paste special. Any suggestions???
Bren
Last edited by bre_pat_2 on Tue May 24, 2011 2:55 pm, edited 1 time in total.
Open Office 3.2
Windows Vista
bre_pat_2
 
Posts: 1
Joined: Sun May 22, 2011 9:31 pm

Re: coping titles of folders

Postby aqualung » Sun May 22, 2011 10:03 pm

Hello and welcome to the forum!

Can you upload a copy of the file containing the data you want to paste into your spreadsheet?

See the tutorial on uploading a file to the forum: viewtopic.php?f=74&t=8289
OOo 3.3.0, Windows 7 64-bit SP1, planning to add LibreOffice after a bug-fix version of 3.4 is released.
Has your question been answered? Please go back to the message at the top of the thread and mark it as [SOLVED].
User avatar
aqualung
Volunteer
 
Posts: 308
Joined: Mon Dec 20, 2010 10:35 pm

Re: Coping titles of folders

Postby Bill » Mon May 23, 2011 12:56 am

If you're trying to create a list of several folder names, you first need to create a text file which has a list of the folder names, then copy the list from the text file to Calc. The list can't be copied directly using Windows Explorer. The free file manager Free Commander has a command "Folder > Make folder list..." which will create such a text file. Alternatively, you can use the command line to create the text file. In Vista, click the start button and type "cmd.exe" in the Start Search box and press ENTER to open a cmd window. Use the "cd" command to navigate to the directory containing the folders, then use the command "dir /ad >list.txt" to create the text file named "list.txt".

Edit: I've found a workaround that will allow you to paste folder titles in Calc without having to create an intermediate text file. In Windows Explorer, select all of the folders whose names you want to copy, then hold down the SHIFT key, right-click the selected folders and select "Copy as path" on the context menu. You can then paste the copied paths in Calc and use Find and Replace to remove everything except the folder name from the paths.
Bill
Volunteer
 
Posts: 8002
Joined: Sat Nov 24, 2007 6:48 am

Re: Coping titles of folders

Postby aqualung » Mon May 23, 2011 7:41 am

Bill's suggestion sounds excellent.

Bren, did that answer your question? Are you sure that you want your information to be in a Calc spreadsheet, or would a numbered list or a table in Writer be easier?

If your question has been answered, please go back to your first post, click on the EDIT button and insert [SOLVED] before the title.
OOo 3.3.0, Windows 7 64-bit SP1, planning to add LibreOffice after a bug-fix version of 3.4 is released.
Has your question been answered? Please go back to the message at the top of the thread and mark it as [SOLVED].
User avatar
aqualung
Volunteer
 
Posts: 308
Joined: Mon Dec 20, 2010 10:35 pm

Re: Coping titles of folders

Postby JohnV » Mon May 23, 2011 4:45 pm

This post presented an interesting programing challenge so I undertook it.

The macro is posted here. Does the job in about half a second. See below for the options available.
viewtopic.php?f=21&t=41231#p189802

If you don't know how to use a macro found here see the link below. If you still need help just ask.
viewtopic.php?f=74&t=5519
JohnV
Volunteer
 
Posts: 1585
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA

How do I turn a folder into a file using OpenOffice?

Postby Writer21593 » Sun Sep 08, 2013 4:21 am

I'm new to this program, and I was wondering how to create a file out of a folder, from a rich text document from my desktop. I'm submitting to publishers who require it, done that way. How do I this? Can someone help me with this. Thank you.
openoffice 4.0 windows vista
Writer21593
 
Posts: 1
Joined: Sun Sep 08, 2013 4:15 am

Re: [Solved] Coping titles of folders

Postby Hagar Delest » Sun Sep 08, 2013 12:36 pm

Have you tried the macro???
LO 6.4.6 on Xubuntu 20.04 and Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29066
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] Coping titles of folders

Postby v3locim » Wed Aug 23, 2017 8:19 am

I would suggest to try "Long Path Tool" program.
Apache OpenOffice 4.1.3 Win7
v3locim
 
Posts: 2
Joined: Mon Aug 14, 2017 5:09 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests