mirror of
https://github.com/storytold/gridcraft.git
synced 2026-11-20 21:10:03 -06:00
Compare commits
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
972f391635 | ||
|
|
57fed2d8a6 | ||
|
|
606fa7a37e | ||
|
|
d4ed031ec3 |
@@ -467,10 +467,35 @@ fn xlsb_external_book_formulas_and_names_decode_and_roundtrip_through_xlsx() {
|
||||
tabs.extend(wide("Other Sheet"));
|
||||
ext_bin.extend(record(359, &tabs));
|
||||
ext_bin.extend(record(577, &wide("ExtName")));
|
||||
// BrtSupNameFmla (585): ExtPtgRef3D (0x3A, sheet 0..0, r=0, c=0)
|
||||
let mut fmla_payload = 9u32.to_le_bytes().to_vec();
|
||||
fmla_payload.push(0x3A);
|
||||
fmla_payload.extend(0u16.to_le_bytes());
|
||||
fmla_payload.extend(0u16.to_le_bytes());
|
||||
fmla_payload.extend(0u16.to_le_bytes());
|
||||
fmla_payload.extend(0u16.to_le_bytes());
|
||||
ext_bin.extend(record(585, &fmla_payload));
|
||||
let mut bits = vec![0u8; 7];
|
||||
bits[2..6].copy_from_slice(&0u32.to_le_bytes());
|
||||
ext_bin.extend(record(586, &bits));
|
||||
ext_bin.extend(record(587, &[]));
|
||||
// Sheet-scoped external name ("LocalExt" on sheet 1 -> sheetId="0")
|
||||
ext_bin.extend(record(577, &wide("LocalExt")));
|
||||
let mut local_bits = vec![0u8; 7];
|
||||
local_bits[2..6].copy_from_slice(&1u32.to_le_bytes());
|
||||
ext_bin.extend(record(586, &local_bits));
|
||||
ext_bin.extend(record(587, &[]));
|
||||
// BrtExternTableStart (363) with refreshError=1, row 0, and all 5 cell types.
|
||||
let mut t_start = 0u32.to_le_bytes().to_vec();
|
||||
t_start.push(1);
|
||||
ext_bin.extend(record(363, &t_start));
|
||||
ext_bin.extend(record(366, &0u32.to_le_bytes()));
|
||||
ext_bin.extend(record(367, &0u32.to_le_bytes()));
|
||||
ext_bin.extend(record(368, &[&1u32.to_le_bytes()[..], &4.5f64.to_le_bytes()[..]].concat()));
|
||||
ext_bin.extend(record(369, &[&2u32.to_le_bytes()[..], &[1u8]].concat()));
|
||||
ext_bin.extend(record(370, &[&3u32.to_le_bytes()[..], &[0x07u8]].concat()));
|
||||
ext_bin.extend(record(371, &[&4u32.to_le_bytes()[..], &wide("hi")[..]].concat()));
|
||||
ext_bin.extend(record(364, &[]));
|
||||
ext_bin.extend(record(588, &[]));
|
||||
|
||||
let fmla_num = |col: u32, cached: f64, rgce: &[u8]| {
|
||||
@@ -638,13 +663,41 @@ fn xlsb_external_link_ordinals_preserve_missing_slots_on_xlsx_save() {
|
||||
]);
|
||||
|
||||
let (wb, report) = read_xlsb(&bytes).unwrap();
|
||||
assert!(report.warnings.iter().any(|w| w.contains("external link")), "{:?}", report.warnings);
|
||||
assert!(report.warnings.iter().any(|w| w.contains("unresolved external link")), "{:?}", report.warnings);
|
||||
assert!(wb.sheets[0].cell(CellRef::new(0, 0)).is_some_and(|c| c.formula.is_none() && c.value == Value::Number(11.0)));
|
||||
assert_eq!(wb.sheets[0].cell(CellRef::new(0, 1)).and_then(|c| c.formula.as_ref()).map(|f| f.text.as_str()), Some("[2]SheetA!$A$1"));
|
||||
assert_eq!(wb.sheets[0].cell(CellRef::new(0, 1)).and_then(|c| c.formula.as_ref()).map(|f| f.text.as_str()), Some("[1]SheetA!$A$1"));
|
||||
|
||||
let saved = write_xlsx(&wb).unwrap();
|
||||
let mut zip = zip::ZipArchive::new(std::io::Cursor::new(saved)).unwrap();
|
||||
let mut wb_xml = String::new();
|
||||
std::io::Read::read_to_string(&mut zip.by_name("xl/workbook.xml").unwrap(), &mut wb_xml).unwrap();
|
||||
assert!(wb_xml.contains("<externalReference/><externalReference r:id="), "{wb_xml}");
|
||||
let (reopened, rep2) = read_xlsx(&saved).unwrap();
|
||||
assert!(!rep2.warnings.iter().any(|w| w.contains("dropped")), "{:?}", rep2.warnings);
|
||||
assert_eq!(reopened.sheets[0].cell(CellRef::new(0, 1)).and_then(|c| c.formula.as_ref()).map(|f| f.text.as_str()), Some("[1]SheetA!$A$1"));
|
||||
|
||||
let saved2 = write_xlsx(&reopened).unwrap();
|
||||
let mut zip = zip::ZipArchive::new(std::io::Cursor::new(saved2)).unwrap();
|
||||
let read_zip = |z: &mut zip::ZipArchive<std::io::Cursor<Vec<u8>>>, name: &str| {
|
||||
let mut s = String::new();
|
||||
std::io::Read::read_to_string(&mut z.by_name(name).unwrap(), &mut s).unwrap();
|
||||
s
|
||||
};
|
||||
let wb_xml = read_zip(&mut zip, "xl/workbook.xml");
|
||||
let ref_ids: Vec<&str> =
|
||||
wb_xml.split("<externalReference ").skip(1).filter_map(|s| s.split("r:id=\"").nth(1).and_then(|t| t.split('"').next())).collect();
|
||||
assert_eq!(ref_ids.len(), 1, "only the surviving external link should be emitted: {wb_xml}");
|
||||
let wb_rels = read_zip(&mut zip, "xl/_rels/workbook.xml.rels");
|
||||
let link_target = wb_rels
|
||||
.split("<Relationship ")
|
||||
.find(|r| r.contains(&format!("Id=\"{}\"", ref_ids[0])))
|
||||
.and_then(|r| r.split("Target=\"").nth(1))
|
||||
.and_then(|s| s.split('"').next())
|
||||
.expect("externalReference r:id should resolve in workbook.xml.rels")
|
||||
.trim_start_matches('/');
|
||||
let link_part = if link_target.starts_with("xl/") { link_target.to_string() } else { format!("xl/{link_target}") };
|
||||
let link_xml = read_zip(&mut zip, &link_part);
|
||||
assert!(link_xml.contains("<externalBook ") && link_xml.contains("<sheetName val=\"SheetA\"/>"), "{link_xml}");
|
||||
let (dir, file) = link_part.rsplit_once('/').unwrap();
|
||||
let link_rels = read_zip(&mut zip, &format!("{dir}/_rels/{file}.rels"));
|
||||
assert!(
|
||||
link_rels.contains("externalLinkPath") && link_rels.contains("Target=\"SecondBook.xlsx\"") && link_rels.contains("TargetMode=\"External\""),
|
||||
"{link_rels}"
|
||||
);
|
||||
}
|
||||
|
||||
+94
-12
@@ -194,9 +194,13 @@ pub fn read_xlsb(bytes: &[u8]) -> Result<(Workbook, ReadReport), IoError> {
|
||||
}
|
||||
import_defined_names(&book, &file_to_model, &mut wb);
|
||||
let external_links = package.external_links(&book).map_err(map_error)?;
|
||||
if let Some(preserved) = preserve_external_links(&external_links) {
|
||||
let (preserved, ordinal_map) = preserve_external_links(&external_links, &mut report);
|
||||
if let Some(preserved) = preserved {
|
||||
wb.preserved = Some(Arc::new(preserved));
|
||||
}
|
||||
if let Some(remap) = ordinal_map {
|
||||
remap_workbook_external_ordinals(&mut wb, &remap);
|
||||
}
|
||||
for warning in package.warnings() {
|
||||
report.warn(warning);
|
||||
}
|
||||
@@ -211,34 +215,110 @@ pub(crate) fn is_xlsb(bytes: &[u8]) -> bool {
|
||||
craft_xlsx::is_xlsb(bytes)
|
||||
}
|
||||
|
||||
fn preserve_external_links(links: &[(String, Option<craft_xlsx::ExternalLink>)]) -> Option<Preserved> {
|
||||
fn preserve_external_links(
|
||||
links: &[(String, Option<craft_xlsx::ExternalLink>)],
|
||||
report: &mut ReadReport,
|
||||
) -> (Option<Preserved>, Option<Vec<Option<usize>>>) {
|
||||
if links.is_empty() {
|
||||
return None;
|
||||
return (None, None);
|
||||
}
|
||||
const CT_EXT_LINK: &str = "application/vnd.openxmlformats-officedocument.spreadsheetml.externalLink+xml";
|
||||
let mut p = Preserved::default();
|
||||
let mut refs_xml = format!("<externalReferences xmlns:r=\"{NS_REL}\">");
|
||||
let mut has_any = false;
|
||||
let mut remap = vec![None; links.len() + 1];
|
||||
let mut next_ordinal = 0usize;
|
||||
let mut had_missing = false;
|
||||
let mut shifted = false;
|
||||
for (i, (_, link)) in links.iter().enumerate() {
|
||||
let Some(link) = link else {
|
||||
// Preserve the 1-based `[n]` ordinal for later links when an earlier slot is missing.
|
||||
refs_xml.push_str("<externalReference/>");
|
||||
had_missing = true;
|
||||
continue;
|
||||
};
|
||||
has_any = true;
|
||||
let rid = format!("rId{}", i + 1);
|
||||
let part_name = format!("xl/externalLinks/externalLink{}.xml", i + 1);
|
||||
next_ordinal += 1;
|
||||
let old_ordinal = i + 1;
|
||||
remap[old_ordinal] = Some(next_ordinal);
|
||||
if next_ordinal != old_ordinal {
|
||||
shifted = true;
|
||||
}
|
||||
let rid = format!("rId{next_ordinal}");
|
||||
let part_name = format!("xl/externalLinks/externalLink{next_ordinal}.xml");
|
||||
let (xml, rels) = external_link_part_xml(link);
|
||||
p.rels.push(PreservedRel { id: rid.clone(), rel_type: format!("{NS_REL}/externalLink"), target: part_name.clone(), external: false });
|
||||
p.parts.push(PreservedPart { name: part_name, content_type: CT_EXT_LINK.into(), data: xml.into_bytes().into(), rels });
|
||||
let _ = write!(refs_xml, "<externalReference r:id=\"{rid}\"/>");
|
||||
}
|
||||
if !has_any {
|
||||
return None;
|
||||
if had_missing {
|
||||
report.warn("XLSB: unresolved external link kept its cached values; its target could not be preserved");
|
||||
}
|
||||
if next_ordinal == 0 {
|
||||
return (None, None);
|
||||
}
|
||||
refs_xml.push_str("</externalReferences>");
|
||||
p.elements.push(PreservedXml { slot: "externalReferences".into(), xml: refs_xml });
|
||||
Some(p)
|
||||
(Some(p), shifted.then_some(remap))
|
||||
}
|
||||
|
||||
fn remap_workbook_external_ordinals(wb: &mut Workbook, remap: &[Option<usize>]) {
|
||||
for sheet_arc in &mut wb.sheets {
|
||||
let sheet = Arc::make_mut(sheet_arc);
|
||||
let coords: Vec<CellRef> = sheet.cells.iter().filter(|(_, c)| c.formula.is_some()).map(|(pos, _)| pos).collect();
|
||||
for pos in coords {
|
||||
let Some(cell) = sheet.cells.get_mut(pos) else { continue };
|
||||
let Some(fm) = &cell.formula else { continue };
|
||||
if let Some(rewritten) = remap_external_formula(&fm.text, remap) {
|
||||
let mut updated = (**fm).clone();
|
||||
updated.text = rewritten;
|
||||
cell.formula = Some(Arc::new(updated));
|
||||
}
|
||||
}
|
||||
}
|
||||
for name in &mut wb.names {
|
||||
if let Some(rewritten) = remap_external_formula(&name.formula, remap) {
|
||||
name.formula = rewritten;
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
fn remap_external_formula(text: &str, remap: &[Option<usize>]) -> Option<String> {
|
||||
let bytes = text.as_bytes();
|
||||
let mut out: Option<String> = None;
|
||||
let mut i = 0;
|
||||
let mut copied = 0;
|
||||
let mut in_string = false;
|
||||
while i < bytes.len() {
|
||||
if bytes[i] == b'"' {
|
||||
in_string = !in_string;
|
||||
i += 1;
|
||||
continue;
|
||||
}
|
||||
if !in_string && bytes[i] == b'[' {
|
||||
let mut j = i + 1;
|
||||
while j < bytes.len() && bytes[j].is_ascii_digit() {
|
||||
j += 1;
|
||||
}
|
||||
if j > i + 1
|
||||
&& j < bytes.len()
|
||||
&& bytes[j] == b']'
|
||||
&& let Ok(old) = text[i + 1..j].parse::<usize>()
|
||||
&& let Some(&Some(new_n)) = remap.get(old)
|
||||
&& new_n != old
|
||||
{
|
||||
let buf = out.get_or_insert_with(|| String::with_capacity(text.len()));
|
||||
buf.push_str(&text[copied..=i]);
|
||||
let _ = write!(buf, "{new_n}]");
|
||||
i = j + 1;
|
||||
copied = i;
|
||||
continue;
|
||||
}
|
||||
}
|
||||
i += 1;
|
||||
}
|
||||
if let Some(mut buf) = out {
|
||||
buf.push_str(&text[copied..]);
|
||||
Some(buf)
|
||||
} else {
|
||||
None
|
||||
}
|
||||
}
|
||||
|
||||
fn external_link_part_xml(link: &craft_xlsx::ExternalLink) -> (String, Vec<PreservedRel>) {
|
||||
@@ -313,6 +393,8 @@ fn external_link_part_xml(link: &craft_xlsx::ExternalLink) -> (String, Vec<Prese
|
||||
xml.push_str("</sheetDataSet>");
|
||||
}
|
||||
xml.push_str("</externalBook>");
|
||||
} else {
|
||||
xml.push_str("<ddeLink ddeService=\"external\" ddeTopic=\"external\"/>");
|
||||
}
|
||||
xml.push_str("</externalLink>");
|
||||
(xml, rels)
|
||||
|
||||
Reference in New Issue
Block a user