On Wed, 2011-02-02 at 19:21 +0100, Bostjan Lemut wrote:
> Pozdrav!
>
> Kolega me muči z zanimivim problemom, zaradi katerega ne preide iz MSO v OOO.
> Moram priznati, da bi rešitev prišla prav tudi meni.
> Rad bi namreč nekje v preglednici uporabil ime datoteke, v kateri se nahaja ta
> preglednica. Pozor, v glavo in nogo dokumenta se to da prilepiti, ampak to ni
> to. V Writerju je to mogoče skozi Inser/Fields/Other/Document/FileName...
>
> lp,
>
> Boštjan
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
>
=CELL("filename";A1) vrne nekaj takega:
'file:///home/user/temp/Untitled 1.ods'#$Sheet1
Samo ime datoteke pa:
=MID(CELL("filename";A1);2;FIND("#";CELL("filename";A1))-3)
Dragan
--
This message has been washed by MailScanner and is believed to be clean.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
