| View previous topic :: View next topic |
| Author |
Message |
valy.maties
General User
Joined: 27 Jan 2009
Posts: 18
|
 Posted: Sat Jan 31, 2009 12:38 am Post subject: may be possible? |
 |
|
It is possible that the name of a sheet to be changed according to a date of a cell? I mean I want the sheet name to a be the name entered in a cell.
Exemple: if i put in the cell D4 of sheet 1 the name "John" the name of spredshet 1 automatically change in "John".  |
|
| Back to top |
|
 |
valy.maties
General User
Joined: 27 Jan 2009
Posts: 18
|
| Posted: Mon Feb 02, 2009 11:33 pm Post subject: Its seems that nobody knows.. |
|
|
I posted two simple issues and it seems that nobody can answer me... I had to deal with import from excel macro
I leave this forum ... I will look for other sources of response ... It appears that users of this forum are quite competent
 |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Tue Feb 03, 2009 12:14 am Post subject: |
|
|
It requires a right-click to rename a sheet.
| Code: | | =MID(CELL("filename");FIND("#$";CELL("filename"))+2;LEN(CELL("filename"))) |
returns the changed sheet-name after forcing a recalculation [Ctrl+Shift+F9] or after reloading the file.
You can be assured that this spreadsheet will never ever rename nor rewrite anything by changing the value of a cell.
Likewise you can be assured that this spreadsheet will never ever change a value by changing any formatting attribute, such as number format.
These are extremely important feature to keep the spreadsheet managable.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
