FAIRmat-NFDI / sand / 39606888553

88%

main: 86%

Pull #102

github

Sheet editing: check what an openpyxl save would lose

roundtrip_problems opens a sheet, saves it unchanged and reports every
difference: sheets, merged cells, cell values, types, number formats,
lost package parts, and lost formula results.

The last one matters most. openpyxl keeps formulas but drops the results
Excel cached for them, and NOMAD's batch parser reads only those results.
On the KIT sheet the Nomad ID and Deposition Time columns come back
empty to pandas, so NOMAD would find no samples.

116 of 120 new or added lines in 3 files covered. (96.67%)

1831 of 2087 relevant lines covered (87.73%)

0.88 hits per line