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

Richtext cell: single underlining in sharedstrings not recognized #122

Closed
dvekeman opened this issue Oct 12, 2018 · 1 comment
Closed

Richtext cell: single underlining in sharedstrings not recognized #122

dvekeman opened this issue Oct 12, 2018 · 1 comment

Comments

@dvekeman
Copy link
Contributor

dvekeman commented Oct 12, 2018

Hi

If I have a simple xlsx file with just one cell containing a single and double underline then only the double underline is recognized.
In case of a more complex xlsx file, things get structured differently and there it seems to behave correctly.

An example:

excel:
A1

Single | Double underline
------   =====

sharedstrings.xml

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="1" uniqueCount="1">
  <si>
    <r>
      <rPr>
        <u/>
...
      </rPr>
      <t>Single</t>
    </r>
...
    <r>
      <rPr>
        <u val="double"/>
...
      </rPr>
      <t>Double</t>
    </r>
...
  </si>
</sst>

Note: I haven't checked the specs as to whether my version of excel actually wrongfully encodes <u /> instead of <u val="single" />

@qrilka
Copy link
Owner

qrilka commented Oct 13, 2018

Somewhat related to #69 - probably there are some other attributes with default values.

dvekeman added a commit to dvekeman/xlsx that referenced this issue Oct 15, 2018
- remove default values from output
@qrilka qrilka closed this as completed in 1c34df9 Oct 15, 2018
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