Jump to content
Developer Wiki and Function Reference Links ×

Marionette colouring worksheet cells - possible?


Recommended Posts

When I'm doing plant orders I like to colour cells once I know an order is complete for that particular plant. I do everything in worksheets as have never found the plant database thing useful to how I work.


Doing this manually is tedious:
1 select cell
2 right click
3 format
4 select format tab
5 dropdown
6 solid
7 Select colour
8 Ok


I do not yet work with  Marionette but have seen a few work nodes that mention  colouring worksheet cells, but haven't found anything like this.

Edited by unearthed
spell error in subj
Link to comment
  • unearthed changed the title to Marionette colouring worksheet cells - possible?

It does not appear that any of the VW2023 default Marionette nodes provide for Worksheet Cell Formatting.


But there are Vectorscript calls to do this, so it should be relatively easy to modify the SetCellFormula node to do what you want.


The line of the script that sets the formula at the bottom of the SetCellFormula node is:


if worksheet != vs.Handle(0):
        formula = vs.SetWSCellFormulaN(worksheet, top, left, bottom, right, formula)



If you change the SetWSCellFormulaN to



( worksheet:HANDLE;









) ;


You will only need to remove the formula input and add the Style, bicolor, fgcolor, and fill pattern values.


There is also another trick that you have to do at the top of the node to make it changeable that I can never remember.  @sbarrett@Marissa Farrell can you help here?

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

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