Jump to content
  • 1

Worksheets Total


markdd

Question

6 answers to this question

Recommended Posts

  • 0

Total guess here, but based on the Left alignment of the numbers in column E and the count in the header row of E2=3, it looks like they are formatted at text instead of as numbers. Try changing them to be formatted as numbers (Worksheet Format menu:Cells, Decimal with 0 decimal points).  

 

The Header Row (E2) should give you the sum of the numbers in the column.  If you want to be able to hide the header row, you can still access that data. Just set E4 to =E2.

  • Like 1
Link to comment
  • 0

That is such a great tip. Thanks.

 

Should these tools that report numbers which are clearly intended for worksheets, not be formatted as numbers? I think its the same for all the Stage deck tools as well as the Stage Lift tool.

 

Most grateful as ever

 

Mark

Link to comment
  • 0

I certainly think so. I end up answering a question like this almost monthly. There are certainly some benefits to the programmer doing it this way. If they were formatted as a number they would have to deal with what to do when someone changed that number from the worksheet or else the number in the worksheet would be different than what the object requires. This was handled in the Space object by adding a second field that had the numeric version as well as the canonical text version. If the numeric version was changed it would just reset back to match the text version the next time the object was reset.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...