Reading underlines
Created originally on Bitbucket by wgurr (Walter Gurr)
Excel uses the <u\>
tag for underline, however this tag appears to not recognized by openpyxl. For example this does not come in with an underline from the openpyxl parser:
#!xml
-<font>
<u/>
<sz val="11"/>
<color rgb="FF0000FF"/>
<name val="Calibri"/>
</font>
When openpyxl sets underline in it's output it uses <u val="single"/>
. This is accepted by Excel, but when Excel saves it reverts to `'.
#!xml
-<font>
<color rgb="000000FF"/>
<u val="single"/>
</font>
I'm using Excel 2010 and openpyxl 2.4.5.