Filename from cell-content?

dgroy · General User Joined: 18 Jan 2012 Posts: 5

Hi,
Is it possible to automatically rename the calc-sheet to the contents of a cell in the sheet?

Example:
- Sheet is called "scratch.ods" and is opened by the user as so.
- Sheet has been changed by the user. After the changes cel A1 contains a specific name: "Specific.ods".
- As the user wants to send the sheet as an email-attachment the sheet shoud be attached to the message as "Specific.ods".

Would be very nice if somebody could hint me! Thanks in advance!

Greets, dgr

mgroenescheij · Posted: Fri Mar 16, 2012 6:09 pm Post subject:

Hi,

dgroy · General User Joined: 18 Jan 2012 Posts: 5

Hi,

Thanks for reacting and sorry for the confusion:

Where I use the name "sheet" I should have used "document".

Hopes this helps to generate a solution...

Roy

Villeroy · Posted: Sat Mar 17, 2012 8:24 am Post subject:

And what if such a file already exists?
What is wrong with the ordinary save dialog where you can paste the cell content as file name?
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

dgroy · General User Joined: 18 Jan 2012 Posts: 5

at Villeroy:

As doc is mailed from within Calc there will not be an existing doc with the same name...

Why not the conventional way?
Convenience and avoiding mistakes, for there are several docs to be mailed daily...

Do you have a hint, maybe?

Thia, Roy

Villeroy · Posted: Sun Mar 18, 2012 2:27 am Post subject:

You've got to write a macro program.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

mgroenescheij · Posted: Sun Mar 18, 2012 2:31 am Post subject:

Hi,

What is the difference in making a mistake by forgetting to update Cell A1 or forgetting to rename your attachment in the mail-tool?

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

PTR7 · Newbie Joined: 18 Mar 2012 Posts: 3

I have wanted to do the same thing. For instance - one cell calculates an updated sales total for the day. Another cell takes that new total, adds a date string, and then the doc takes its name from that cell: "March 18 2012 - $43,745" and is e-mailed to all sales associates. Re-typing the name is the traditional way to do this. Automated re-naming of the sheet for daily distribution would save time and avoid mistakes. But, sounds like there is not a function within Calc to do this. To Villefort's point, there would have to be a macro of some sort to snag the value and insert it into the Save dialog.

mgroenescheij · Posted: Mon Mar 19, 2012 4:36 am Post subject:

Hi PTR7,

Why don't you try to master the simple things first and do fancy things further down the track.

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).