Cannot handle multple fonts in same cell correctly

[piaoger]

• How to reproduce

1. create a file with two cells which are filled by mixing different Bold, Italic, Font and font size. See attached aaa_multifonts.xlsx.
2. run a simple read write roundtrip
3. Open the output file, you will find fonts are not handled well for entire string.
   See below snapshot in WPS office, the 2nd and 3th chars are default Simsun。In MS Office, they are Calibri.
   
   

• code snippt

        let f = "/w/assets/xlsx/aaa_multifonts.xlsx";
        let path = std::path::Path::new(&f);
        let mut book = umya_spreadsheet::reader::xlsx::lazy_read(&path).unwrap();
        let _ = umya_spreadsheet::writer::xlsx::write(&book, &format!("{f}.rw.output.xlsx"));

aaa_multifonts.xlsx

aaa_multifonts.xlsx.rw.output.xlsx

[MathNya]

@piaoger
Thank you very much for your help here.
I think it is probably a glitch.
We will investigate the cause and take action.

[MathNya]

@piaoger
Sorry, could you please provide us with aaa_multifonts.xlsx so that we can understand the situation as accurately as possible.
(I think the two files you attached are probably both post-processed files.)

[piaoger]

@MathNya I just updated the origin post and attached the right xlsx file.

[piaoger]

I just checked the result with latest change. It works great !!

Blow is the snapshot of WPS Office: