umya-spreadsheet icon indicating copy to clipboard operation
umya-spreadsheet copied to clipboard

Broken Formatting & Lost List Box Upon Opening and Saving Workbook

Open fgimian opened this issue 1 year ago • 2 comments

Hey there, firstly thank you so much for this amazing library. I find it very enjoyable and ergonomic to use.

I did discover that just opening and saving my workbook caused some trouble when text used multiple font sizes within a single cell and there was a list box present.

Here's the code:

use std::{path::Path};

fn main() {
    let path = Path::new(r"C:\Users\Fots\Downloads\Book.xlsx");
    let mut book = umya_spreadsheet::reader::xlsx::read(path).unwrap();

    let path = Path::new("out.xlsx");
    umya_spreadsheet::writer::xlsx::write(&book, path).unwrap();
}

And here's a sample spreadsheet.

Book.xlsx

Here's how the original looks:

image

And how it looks after being opened and saved with the library:

image

Thanks heaps in advance! Fotis

P.S.: I can confirm that other developer controls such as buttons are lost too.

fgimian avatar Jul 15 '24 09:07 fgimian

Thank you for your report. We will proceed to investigate and address the cause of the problem.

MathNya avatar Jul 19 '24 02:07 MathNya

Fixed a bug related to text values. The developer control object is currently not supported. We will try to support it in the next update.

MathNya avatar Aug 04 '24 07:08 MathNya