[Solved] Coping titles of folders

Discuss the spreadsheet application
Post Reply
bre_pat_2
Posts: 1
Joined: Sun May 22, 2011 9:31 pm

[Solved] Coping titles of folders

Post by bre_pat_2 »

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
User avatar
aqualung
Volunteer
Posts: 308
Joined: Mon Dec 20, 2010 10:35 pm

Re: coping titles of folders

Post by aqualung »

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: http://user.services.openoffice.org/en/ ... =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].
Bill
Volunteer
Posts: 8932
Joined: Sat Nov 24, 2007 6:48 am

Re: Coping titles of folders

Post by Bill »

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.
User avatar
aqualung
Volunteer
Posts: 308
Joined: Mon Dec 20, 2010 10:35 pm

Re: Coping titles of folders

Post by aqualung »

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].
JohnV
Volunteer
Posts: 1585
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA

Re: Coping titles of folders

Post by JohnV »

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.
http://user.services.openoffice.org/en/ ... 31#p189802

If you don't know how to use a macro found here see the link below. If you still need help just ask.
http://user.services.openoffice.org/en/ ... =74&t=5519
Writer21593
Posts: 1
Joined: Sun Sep 08, 2013 4:15 am

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

Post by Writer21593 »

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
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] Coping titles of folders

Post by Hagar Delest »

Have you tried the macro???
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
v3locim
Posts: 2
Joined: Mon Aug 14, 2017 5:09 pm

Re: [Solved] Coping titles of folders

Post by v3locim »

I would suggest to try "Long Path Tool" program.
Apache OpenOffice 4.1.3 Win7
Post Reply