Jump to content

Report adressing cells - data from one report to another


Recommended Posts

Dears,

Is it possible and if possible, How to adress a data cell from one report to another?
I want to make a irrigation joints report (which are not present in Vectorworks) useing simple maths. The thing is that I have to receive a data from other different reports.

ex. Number of tee joint (for sprinklers only) should be =number of sprinklers- number of watering sections/zones ex. 12 sprinklers & 2 sections/zones -> 12-2=10 tee joints

 

I want to receive a number of sprinklers from Irrigation Outlet Schedule. Is it possible to do it in similar to Excel way?
='[filename.xlsx]sheet name'!$column_no$row_no

underlined text could have different values

Maybe @Pat Stanford has some ideas?

Thanks in advance!

Link to comment

Thank You for Your rapid advice!
Let me ask You another and last question for today.
How to improve image quality while putting it into report with =image(s='my_2d_symbol') formula?
It works only when Cell Format>Image>Type>miniature     *I don' know if I translated functions properly (I'm using Polish version).

Type>2D attributes/properties is not working, it returns 0 (ZERO) into the cell
miniature resolution and quality is not good enough...

image.png.dd3f8e9edba24d222228105c4cbb9e12.png

Link to comment

Dear @Pat Stanford border works fine so as addressing formula, but I do have some problems SOMETIMES with =image(s='my symbol') when I'm using it for the firs time in a new report/schedule for the first time it works well, but if I'm trying to add a column on the left of the column with =image(...) formula cell it moves to the right (column F becomes to be G) the image of a symbol disappears (formula and cell formatting remain the same).

 

It happens sometimes or rather most of the time and does not see any rule or regularity why it happens...

Bellow images that describes the problem:

image.png.73b2cc65b0450dbea20a5bee325e3b34.pngimage.png.d111546c89a372533a725203d73c1780.pngimage.png.2e8e6f04ef0bf46ea607af4718359f1d.png
image.thumb.png.9154955ee92a69c09b765a6bd6df6ce0.png

image.thumb.png.d2af78c65c14e7dcc44eb0d85903ebd5.png

 

Do You have any solution for this problem??

Edited by Piotr Karczewski
adding details
Link to comment

I don't think you can use the Image Function (Or any function) with a separate criteria in a database row. The criteria for Image (and area, volume, Xposition, etc.) all come from the criteria of the database row.

 

I think you could put the =Image(S='XXX') into a Spreadsheet cell and then reference that in the database with a standard cell formula (=E1) But I don't think you will get the other way to work.

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
Reply to this topic...

×   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...