Respect xml:space="preserve" (#43)

[TimG1964]

This PR fixes the issue reported in #43. I've added extra tests, too.

One caveat in testing: I had to change one test (only):

    @testset "next and prev" begin
        @test XML.prev(doc[1]) === data

I had to change the condition from === to only ==. With this single change, tests now all pass locally.

I've also checked that this PR works well with XLSX.jl downstream and all XLSX tests also pass locally.

With this PR, XLSX now properly reads a workbook like this:

which has leading and trailing whitespace in column A and, in column B, only has whitespace.
Reading this XLSX file now works correctly:

julia> f=XLSX.openxlsx(raw"C:\Users\tim\OneDrive\Documents\Julia\XLSX\sstTest.xlsx", mode="rw")
XLSXFile("sstTest.xlsx") containing 1 Worksheet
            sheetname size          range        
-------------------------------------------------
               Sheet1 5x2           A1:B5        

julia> f[1][:]
5×2 Matrix{Any}:
 "  hello"    "    "
 "  hello  "  "    "
 " hello\">"  "    "
 "hello\">"   "    "
 "  hello"    "    "

Previously, leading and trailing spaces would be trimmed, and cells containing only whitespace would become missing.

I'm afraid I can't match the simple elegance of your coding style, though!

[TimG1964]

Hi Josh. Is there a reason you haven't merged this? Let me know if there is anything more I need to do or if it doesn't pass muster for some reason. Thx.

[joshday]

Sorry for not responding!

I was in the middle of rewriting a bit of the XML internals when you made the PR and then both the rewrite and this PR got pushed to the back burner by other work.

LGTM, and again my apologies for the delay!

[TimG1964]

Thank you! Will there be a new release?

[joshday]

Yes!

JuliaRegistries/General#135609