ksobon / Bumblebee

Excel interop for Dynamo
36 stars 14 forks source link

Vertical Align Types - Bottom #41

Open Twsedf8 opened 2 years ago

Twsedf8 commented 2 years ago

When you select "Bottom" from the "Vertical Align Types" node, it registers a value of "-4017". Per Microsoft https://docs.microsoft.com/en-us/office/vba/api/excel.xlvalign the value for "Bottom" is "-4107". Using your node causes all BB Styles to not be applied to the Excel file (regardless of getting a Success response from the "Format Excel" node). When using a Code Block with the correct value, styles are applied as expected.

Thank you so much for everything you have done for this and other packages, your work is outstanding and inspiring!

Vertical Align Types

ksobon commented 2 years ago

@Twsedf8 great catch! Yes, that's for sure a bug. Thank you for reporting it.