Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature Request] Row Properties #417

Open
bonsairobo opened this issue Mar 26, 2024 · 0 comments
Open

[Feature Request] Row Properties #417

bonsairobo opened this issue Mar 26, 2024 · 0 comments

Comments

@bonsairobo
Copy link

bonsairobo commented Mar 26, 2024

As far as I can tell, there is no support for extracting row properties from the row XML, e.g.:

<row r="430" ht="15.75" hidden="1" customHeight="1" outlineLevel="2">
    ...
</row>

I'm specifically interested in the outlineLevel attribute. It's apparently used for encoding a tree of rows that's relevant to our application.

Here's an example of another spreadsheet library that supports these extra properties: https://docs.sheetjs.com/docs/csf/features/rowprops/

And some Microsoft documentation: https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.row?view=openxml-3.0.1#properties

I've added experimental support for only the outlineLevel property here: bde6613

I'm not confident that the API is right, and the implementation is a little hacky, but it serves the use case for now.

Is this feature something the maintainers are willing to support?

If so, my next question is: which attributes are common enough that supporting them is important? Should they be dynamic? The Msoft documentation link above has a fixed set of properties, but I suspect this is not exhaustive. I don't have evidence other than... you know... it's Microsoft. They're not exactly known for documenting stuff well.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant