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

Reading rich text formatted cells #440

Open
FlixCoder opened this issue Jun 4, 2024 · 1 comment
Open

Reading rich text formatted cells #440

FlixCoder opened this issue Jun 4, 2024 · 1 comment

Comments

@FlixCoder
Copy link

Thank you for the great library! :)

Somewhat related to #424, #404 #427, but after all quite different:
I want to read Excel sheets with cells that have individually formatted values, but not on the whole cell, but only part of the text. So it is not the cell style, but the rich text value inside the cell that interests me.

Example in shared strings (cell value displayed as: "1, 1, 2"):

        <si>
		<r>
			<t xml:space="preserve">1, </t>
		</r>
		<r>
			<rPr>
				<u />
				<sz val="8" />
				<rFont val="Arial" />
				<family val="2" />
			</rPr>
			<t>1</t>
		</r>
		<r>
			<rPr>
				<sz val="8" />
				<rFont val="Arial" />
				<family val="2" />
			</rPr>
			<t>, 2</t>
		</r>
	</si>

I am in the unfortunate situation that the formatting decides the meaning of the content 😅

Previous art / other implementations: https://docs.rs/edit-xlsx/0.4.4/edit_xlsx/struct.RichText.html : https://docs.rs/edit-xlsx/0.4.4/src/edit_xlsx/api/cell/rich_text.rs.html#5-7 as well as https://docs.rs/umya-spreadsheet/latest/umya_spreadsheet/structs/struct.RichText.html

Depending on the scope and agreement on the implementation, I might be interested in contributing this soon.
I suppose it would need another data type of cell values and a similar RichText implementation? Not sure how parsing exactly works and how it looks like in ODS..

@tafia
Copy link
Owner

tafia commented Jun 5, 2024

Thanks for opening the issue and stating it as clearly. I'll be more than happy to review any PR :)

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

2 participants