Inconsistent line options between cellRange and shapes

Posted by: davide.vago on 2 December 2020, 3:09 am EST

  • Posted 2 December 2020, 3:09 am EST

    Good morning/afternoon

    I recently requested support regarding the tracing functionality and I've got a solution involving the Shapes library.

    I noticed an inconsistency within the line styles between cells/cell ranges and shapes during the implementation of the above.

    As you can see from the example:
    https://codesandbox.io/s/spreadjs-inconsistent-border-line-options-ct62s?file=/src/app/app.component.ts

    It appears you are able to style the cells using a double line border but Shapes object don't have the same option as per documentation:
    https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Shapes.PresetLineDashStyle.html?highlight=presetlinedashstyle%2C

    Would you mind review it?

    I'd like to have the same options to provide a consistent style between shapes and cells (we use the double line style to style precedents/dependents cells as the double line style does stand out and doesn't conflict with other pre-existing styles, e.g. background) and we have a system to generate shapes to display data coming from the formula using multiple sheets

    Looking forward to hearing from you

    As always thanks for the support.
  • Replied 7 December 2020, 11:08 pm EST

    Hi Davide,

    We are able to observe the issue hence we have made an enhancement request for the required functionality. We will update you regarding this as soon as we get any information. The internal ID for this issue will be SJS-6802.

    Regards
    Avinash
  • Replied 14 December 2020, 3:27 pm EST

    Hi Davide,

    The dev team informed us that this feature isn't supported at the moment, but we have added it to our product backlog.

    Regards
    Avinash
  • Marked as Answer

    Replied 23 May 2021, 3:48 pm EST

    Hi Davide,

    The feature has been added to our latest 14.1.0 build. Please refer to the following demo which demonstrate how we could achieve the same functionality and let us know if you face any issues.

    line fill: https://www.grapecity.com/spreadjs/demos/features/shapes/shape-line-effect/purejs

    Regards
    Avinash
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels