OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Filename from cell-content?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
dgroy
General User
General User


Joined: 18 Jan 2012
Posts: 5

PostPosted: Fri Mar 16, 2012 3:14 am    Post subject: Filename from cell-content? Reply with quote

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
Back to top
View user's profile Send private message
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Fri Mar 16, 2012 6:09 pm    Post subject: Reply with quote

Hi,

Quote:
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".
Quite confusing question.
In the first two points you talk about renaming sheets but use an .ods extension.
In the last point you talk about sending the sheet via email, the point is that you can send a document as a whole, but not individual sheets.

Please clarify your issue.

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
dgroy
General User
General User


Joined: 18 Jan 2012
Posts: 5

PostPosted: Fri Mar 16, 2012 11:13 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Mar 17, 2012 8:24 am    Post subject: Reply with quote

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 https://forum.openoffice.org
Back to top
View user's profile Send private message
dgroy
General User
General User


Joined: 18 Jan 2012
Posts: 5

PostPosted: Sun Mar 18, 2012 2:10 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Mar 18, 2012 2:27 am    Post subject: Reply with quote

You've got to write a macro program.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Sun Mar 18, 2012 2:31 am    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
PTR7
Newbie
Newbie


Joined: 18 Mar 2012
Posts: 3

PostPosted: Sun Mar 18, 2012 7:51 am    Post subject: Its a good question, actually Reply with quote

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.
Back to top
View user's profile Send private message
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Mon Mar 19, 2012 4:36 am    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group