Need help on creating List cells using data validation

[BharathIO]

Hi, I am creating Excel with 2 sheets, One to create a List of values and the other to point values to display drop-down.

But calling get_data_validations() returns None. When I try to read validations from the existing Excel template and write to output a new file, my output workbook does not have any validations. Looks like they are not getting copied/cloned, could you please check and do the needful? I am attaching excel template for reference

My requirement is to read that excel, fill in actual data, and create an output file. But because of missing data validations, my output file is getting corrupted, and opening in recovery mode does not have any validations.

Excel file

lov-template.xlsx

[MathNya]

@BharathIO Thank you for contacting us. We will address this in the next version of the software.

[BharathIO]

Thanks for the update @MathNya , may i know when can i expect next version with the above fixes?

[MathNya]

@BharathIO We will probably be able to release it around the end of this month.

[BharathIO]

Sure. I will be waiting for that feature. Hope it takes care of defined named ranges for Lists read/write.

[BharathIO]

I see we are facing issue when named range is creating like below.

=OFFSET(LOV!$A$1,1,0,COUNTIF(LOV!$A:$A,"<>"&"")-1,1)

[BharathIO]

Fyi, this is what i observed.

[MathNya]

@BharathIO We have released 1.2.1 which fixes this problem. Please check it out.

[BharathIO]

After version upgrade, i am facing issue mentioned here https://github.com/MathNya/umya-spreadsheet/issues/181#issuecomment-1968439976, could you please check for it?

[BharathIO]

I am still facing this issue after upgrading to 1.2.2. could you please check

Output file

Employees (8).xlsx

[BharathIO]

Input file

lov-template-input.xlsx

Output file

1_lov_copy.xlsx

let template_path = "../lov-template-input.xlsx";
    let output_path = "../1_lov_copy.xlsx";
    let book = umya_spreadsheet::reader::xlsx::read(template_path).unwrap();

    let path = std::path::Path::new(output_path);
    let _ = umya_spreadsheet::writer::xlsx::write(&book, path);
    println!("File cloned successfully at: {}", output_path);

[BharathIO]

Hi @MathNya, did you get a chance to check above issue? Please correct if i am doing anything wrong

[MathNya]

@BharathIO Sorry for the delay in contacting you. I will check the situation.

[MathNya]

@BharathIO We were able to correct the cause of the error. Version 1.2.3 was released. Please check it out.

[BharathIO]

Thanks, @MathNya, it is working as expected now.

Excel for reference

Employees (11).xlsx