Multiple lines comment

[stla]

Hello,

I have this comment in a xlsx file:

tidyxl only returns the first line:

> z$data$Sheet1$comment
 [1] "Stéphane Laurent:" NA                   NA                  
 [4] NA                   NA                   NA                  
 [7] NA                   NA                   NA                  
[10] NA                   NA                   NA 

(the encoding issue can be solved with Encoding(x) <- "UTF-8")

It is encoded like this in the xml file:

        <comment ref="A1" authorId="0">
            <text>
                <r>
                    <rPr><b/><sz val="9"/><color indexed="81"/><rFont val="Tahoma"/><family val="2"/></rPr>
                    <t>Stéphane Laurent:</t>
                </r>
                <r>
                    <rPr><sz val="9"/><color indexed="81"/><rFont val="Tahoma"/><family val="2"/></rPr>
                    <t xml:space="preserve">
                        hello</t>
                </r>
            </text>
        </comment>

It would be nice to get the concatenation of the two lines: Stéphane Laurent\r\nhello.

[stla]

By the way, perhaps comments deserve a separate dataframe to store them (z$comments$Sheet1), since they are styled.

[nacnudus]

The multiline bug is fixed in 96df3bd.

Stéphane renders properly in my terminal. Have you tried wrapping it in cat()? If that doesn't work, then please open another issue.

The styling of comments is a duplicate of #5, which I see you have already found.

[stla]

Stéphane renders properly in my terminal. Have you tried wrapping it in cat()?

Yes, this is the same with cat(). Maybe because I'm using Windows, or this is related to the locale. Also µ is rendered as µ.