Udyad,
Please note that - one time only - I addressed my reply to your personal
email as well as to the list, because you are not subscribed to the
list. However, to continue this thread please always address your
messages to, and look for answers in, the openoffice.org list.
In a message dated 1998.12.31 13:53 -0500,
[email protected] wrote:
I have a doubt on excel that I would like to reflect all the
files that are in a particular folder on the excel sheet, I
almost made it but I couldn't trace it out the problem where
persists. I would like to do something that if a particular file
not found that will shown on that cell as *0* and if found as *1*.
To clarify: cells in columns I, J (and upward) will contain file
references; if the file exists, the cell should display 1; if not
exist, 0. Is that correct?
Assuming yes, my first question [which I'm sure someone on the list
can answer] is whether Calc finds the function
ISERROR(HYPERLINK(<filespec>;..)) meaningful. From a quick test, I
think not. That is, I don't think HYPERLINK() returns an error,
whether the link is valid or not.
How should I reflect on the cells "1" if files found in a folder and
if not then "0". I shall be greatful to you please clarify my doubt....
Thank you for confirming the clarification. But then, as noted in my
last post, I believe there is a fundamental problem with your cell
formulas, that the function ISERROR(HYPERLINK(<filespec>;..)) is not
meaningful because HYPERLINK() does not return an error, whether the
link is valid or not. I hope someone on the list can offer an
alternative test.
There is also a secondary problem in your formula in the use of two IF()
clauses when there should be a single IF() statement. That is, *if*
HYPERLINK() could test the presence of a file and return an error, your
cell formula should be simply IF(ISERROR(HYPERLINK(<filespec>));0,1).
John
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
