Styles not getting applied to SpreadSheet when parse method is used

Webix JS
1

Hi @Natalia_Shilova @NatashaS
Styles not getting applied to SpreadSheet when parse method is used.
I want to apply styles, use setFormat etc… with parse method, basically I have to render around 5000 rows and 2000 columns, so I have to go with parse method.
When using parse(), styles are not getting applied.
Can you please help here
https://snippet.webix.com/vsyeuxvr

Thanks!

2

Hello @Harshvardhan_Gaddam ,

The issue is that the styles and data formats you’re using are not what sheet.parse() expects. That is why styles (background, borders, alignment) are ignored:

  • parse requires each style to be a pair [name, "18 semicolon separated properties"] .
    Your array ["background-color: ...", "", "center", "middle"] is not recognised.
    The correct order of the 18 properties is:
    color; background; text-align; font-family; font-size; font-style; underline; font-weight; vertical-align; wrap; borders; format; border-right; border-bottom; border-left; border-top; strike; indent.

  • Style references in data must be strings, not numbers. You wrote [1, 1, "Participant(s)", 0] but the fourth element must be the name of a style (like "s0" ), not an index.

  • white-space and line-height are not supported in style strings. The allowed CSS properties are limited (see the list here). Use the built‑in wrap field (position 10) to enable text wrapping.

Please check the example: Code Snippet

3

We have checked the same snippet you have provided in our client machine it is still breaking.

image
image1824×675 56.4 KB

We will check with our team for workspace configuration.
We really appreciate your quick response, will reach out if we need any help further.

Thanks

4

We remain ready to continue investigating once you have more details. Feel free to reach out.

1 Like