Jump to content
  • 0

=IMAGE(N='Logo')


WhoCanDo

Question

Hi,

 

When I insert =IMAGE(N='Logo') into a spreadsheet cell, it shows me a picture of a logo. Good.

 

However, if I make that line a Database, it displays "False", not the picture.

 

Note: the named item is a 2D symbol.

 

The following link says I can do it for spreadsheet and database cells, but how ..

 

https://app-help.vectorworks.net/2023/eng/VW2023_Guide/Worksheets/Inserting_images_in_worksheet_cells.htm

Link to comment

3 answers to this question

Recommended Posts

  • 0

In a database row, the criteria is defined by the criteria of the database. You can not use custom criteria in the header row formulas of a database. For IMAGE to work in a database, the criteria has to specify an object that it can display an image of. 

 

It would be really useful to be able to do something like attach a record to an object and then return an image based on the data in that record, but that is not currently possible.

 

Sorry.

Link to comment
  • 0

So, finding a work around wasn't that difficult. This is how I solved it for those interested.

 

The reason for making a Database line was to get the Record Value from an object, with a record attached, and list it on the same row as the Logo.

 

The row must be of Spreadsheet type, and then the cell value   =IMAGE(N='Logo')   works.

 

I wrote this macro and the added this formula to a cell to the right of the Logo      =RUNSCRIPT('Name of script')

 

Many of you will recognize the method.

 

procedure Fab_List_Value;

	procedure Get_Value (h : handle);
	var V : string;
	begin
	V := Concat (GetRField (h, 'Value', 'GrWeight'), ' ', GetRField (h, 'Value', 'NtWeight'));
	WSScript_SetResStr (V);
	end;
	
begin
ForEachObject (Get_Value, ((L = 'Objects') & (C = 'Object1')));
end;
run (Fab_List_Value);

 

 

  • Like 1
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...