Worksheets & Reports & custom features

[Piotr Karczewski]

Hi I have found some of worksheets with database (row) line hidden, sometimes, but not always, they appear when I change their height but after all they hide.
I'm wondering how to obtain this result in my own worksheet? Using 0 height make it is easy to reveal the line.

[Tom W.]

Do you mean you want to hide row 2? If so, in the View menu uncheck 'Database Headers'.

[Piotr Karczewski]

Thanks @Tom W., this is what I was looking for! I didn't know that it works per worksheet instance.

[Piotr Karczewski]

I'm also looking for a way to present  hatch image of the hardscape (1st/top component hatch like in 2D view)  in worksheets.
=IMAGE with Type: Miniature shows the shape of the hardscape.

When I use Type: 2d attributes it goes for hardscape attribute which is NOT TOP component attribute.

It should look like this:

This is the result of using Type: Miniature + 1:20 scale (You can still see shape of the hardscape ex. 3.4)

What is that I'm looking for is a 1st component hatch preview in rectangle shape for ex. 120x40pts in worksheet.

Thanx for any advice!

[Pat Stanford]

I don't think the Image functions in worksheets are sophisticated enough to do what you are attempting.

 

I am not certain but you may have better results using a Graphical Legend instead of a worksheet.

[Tom W.]

Definitely try Graphic Legends this is exactly what they’re designed for.

[Piotr Karczewski]

I'm making a report and function, described below, does not work correctly

Functions:

=ROUNDUP(number; digits) - 

Rounds the specified number up to a specified number of decimal digits.

 

for me it should be H3.1 = 375,84 and J3.1 = 87

How to fix it? or is there another way to ROUND the number UP to the nearest WHOLE NUMBER

[Pat Stanford]

It seems to work correctly and give the answer you want for me in VW2025.

 

But I put in a fixed value in Column I.  Could it be that you actually have more decimal points in Hardscape.Record so the value you are using is not exactly 4.32?  Do you need a Round to 2 decimal places there?

 

Also, I don't see a Record field in the VW2025 Hardscape Parameter Record. And what is the :' at the end of the Value statement doing?