[Solved] =INFO("Directory") not supported

[eestmartin]

04/18/2018

Microsoft Excel supports the Information Function of: =INFO("Directory")

Examples of the Formula and its results follows:

I. Results using Microsoft Excel:
A B C D E F
1 Formula Results
2 =INFO("Directory") C:\Users\Emery\Documents\

II. Results using Apache Openoffice 4.1.5:
A B C D E F
1 Formula Results
2 =INFO("Directory") Err:502


Problem: My research shows that Apache Openoffice 4.1.5 does not support the "Directory" option.
Is there some alternative way in Apache Openoffice 4.1.5 that I can get the same Results as in Microsoft Excel?

Thank you,

Emery
Email Address: <Deleted>

[FJCC]

The CELL() function will return the full URL of the file plus the sheet name of a cell. That is not quite the same thing.

Code: Select all

=CELL("FILENAME";A1)

[eestmartin]

Thank you FJCC,
I used your suggested CELL() function getting the following results which is exactly what I wanted (The results have my name, Emery, within the filename):

A B C D E F G H I J
1 Formula Results
2 =cell("filename";$a$1) 'file:///C:/Users/Emery/Desktop/New OpenDocument Spreadsheet.ods'#$Sheet1

I will mark this incident "Solved".
Thanks again,
Emery