[libreoffice-users] Re: Calc

Am 11.02.2011 20:18, TVCSF Chair wrote:
> I have been using Libre Office 3.3 having up dated from Ooo 3.2. I now
> find that when trying to reference from one spreadsheet to another
> sometimes it works and sometimes it doesn't, coming up with a #REF
> failure. It also fails to show the graphs from an Excel sheet that
> worked perfectly in Open Office 3.2.
>
> I uninstalled 3.2 before installing 3.3, but have had to go back to
> Oo3.2 to get my spreadsheets working again.

I doubt that the #REF! error has anything to do with the software 
version. As far as I can see, this error works properly in LibreOffice. 
#REF! has to do with relative references and how these references 
resolve when you copy relative references. When they refer to some 
sheet/row/column out of scope you get either one of
=#REF!.A1 (no such sheet)
Sheet1.#REF!1 (no such row)
Sheet1.A#REF! (no such column)

Without any information at all it is impossible to help without posting 
a spreadsheet tutorial.


--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***