[libreoffice-users] Re: Function in OSX with Calc 3.5.5

2012-07-19 Thread digisan
That was my first thought. I tried widening the cells - drastically as well
as different formatting options. I have it set for only 3 decimal places.

--
View this message in context: 
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996453.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] Re: Function in OSX with Calc 3.5.5

2012-07-19 Thread digisan
Here is a sample of what I'm dealing with. Thanks for the suggestion Dan.

http://nabble.documentfoundation.org/file/n3996484/UploadTroubleShooting.ods
UploadTroubleShooting.ods 

--
View this message in context: 
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996484.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Function in OSX with Calc 3.5.5

2012-07-19 Thread Steve Edmonds


On 2012-07-20 06:01, digisan wrote:

Here is a sample of what I'm dealing with. Thanks for the suggestion Dan.

http://nabble.documentfoundation.org/file/n3996484/UploadTroubleShooting.ods
UploadTroubleShooting.ods

--
View this message in context: 
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996484.html
Sent from the Users mailing list archive at Nabble.com.

Hi. Opens and looks fine on 3.4 here, do you have a screen shot to show 
what you see (Grab on mac Osx).

Steve



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] Re: Function in OSX with Calc 3.5.5

2012-07-19 Thread digisan
Steve,
I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot.
Does anyone know where to download 3.4, it looks like it is no longer
available on the website. 

http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png
 

--
View this message in context: 
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996499.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Function in OSX with Calc 3.5.5

2012-07-19 Thread Dan

Steve Edmonds wrote:


On 2012-07-20 06:01, digisan wrote:

Here is a sample of what I'm dealing with. Thanks for the suggestion Dan.

http://nabble.documentfoundation.org/file/n3996484/UploadTroubleShooting.ods

UploadTroubleShooting.ods

--
View this message in context:
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996484.html

Sent from the Users mailing list archive at Nabble.com.


Hi. Opens and looks fine on 3.4 here, do you have a screen shot to show
what you see (Grab on mac Osx).
Steve


 I used 3.4.6 and 3.5.5 to open the calc document with no ### 
showing in any cells. The only way I could produce any ### in a cell was 
to reduce the width of column and then only in the second sheet and the 
columns containing functions.
 If you are getting ### on a Mac, it could be a bug in the Mac 
version, but I have no way to test this.


--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Function in OSX with Calc 3.5.5

2012-07-19 Thread Steve Edmonds
Just got my mac from the car, in 3.5.4.2 it is showing fine. Is your 
font Arial (shows that here).

Steve

On 20/07/12 7:39 AM, digisan wrote:

Steve,
I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot.
Does anyone know where to download 3.4, it looks like it is no longer
available on the website.

http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png

--
View this message in context: 
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996499.html
Sent from the Users mailing list archive at Nabble.com.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Function in OSX with Calc 3.5.5

2012-07-19 Thread Regina Henschel

digisan schrieb:

Steve,
I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot.
Does anyone know where to download 3.4, it looks like it is no longer
available on the website.

http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png



You have turned on Value highlighting, isn't it? So I guess that the 
blue values are numbers and the  are formulas. Please have a look at 
Tools  Options  Calc  View   Section 'Display'. If there is a check 
for 'Formulas', remove it.


Kind regards
Regina


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: Function in OSX with Calc 3.5.5

2012-07-19 Thread digisan
That's it. I had Formulas checked. In 3.5.5.3 on the Mac it is under
preferences. Thanks so much to all for the help.

--
View this message in context: 
http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996518.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted