Function in OSX with Calc 3.5.5

users
#1

Just installed 3.5.5 and now my functions just show ### as results.
The functions are basic like min, max and sum. Any ideas why ?

#2

The cells are probably not wide enough to display the data as formatted. Try either widening the cells or changing the display format for the cells.

#3

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.

#4

digisan wrote:

Just installed 3.5.5 and now my functions just show ### as results.
The functions are basic like min, max and sum. Any ideas why ?

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

      Can you create a Calc document that has this problem without showing privileged information? If you can, please do so and upload it to Nabble so someone could download it to see what the problem is.

--Dan

#5

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

#6

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

#7

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

#8

Steve Edmonds 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

#9

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

#10

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

#11

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.