Openoffice problem in Ubuntu

[Arun Shrimali]

On Thu, Jul 2, 2009 at 4:58 PM, bill<william at techservsys.com> wrote:
> Arun Shrimali wrote:
>
> Dear All,
>
> I am working ubuntu 9.04 and OOo3.0.1
>
> While working on vlookup (two different files) I found the final
> result with #NAME? error after many combination I could not get the
> right output.
> Incidentaly, I logout and login as different user, and I found that
> vlookup is working perfectly.
>
> I again login as earlier user and do the simple formula like link to
> another file (='point to cell in another file') it give the same error
> i.e. #NAME?
> where as if I use the formula in the same file it works perfectly, if
> I use the another file it give the error #NAME? (which is not the case
> with the second user)
>
> I concluded that there is some configuration changes made by the user
> either in Openoffice or Ubuntu which doesn't make the proper links
> between files.
> can anybody point me out where could be the problem is ??
>
> Thanks
>
> Arun
>
>
>
> Try widening the column that gets the #NAME, sometimes it is that simple.
> Sometimes not.
>
> --
> Bill Drescher
> william {at} TechServSys {dot} com
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
>
>

It is the error which show even in the "result" block of the formula
.............
there might be some problem of configuration of OOo / Ubuntu, as other
users on the same m/c are working perfectly.

regards

Arun