Skip to content

[BUG] Unlocked cells lose their vertical and horizontal alignment after a read and write. #1206

Closed
@Punknium

Description

@Punknium

🐛 Bug Report

If I read in an xlsx file and then write it back out any unlocked cell will lose their vertical and horizontal alignments.

Lib version: 3.8.2

Steps To Reproduce

Read and write an xlsx file.

Here is a before and after example. See cell E4
ExcelJS-FormattingLockedCellAndDatavalidation.xlsx
ExcelJS-AFTER-FormattingLockedCellAndDatavalidation.xlsx

async load() {
  try {
    const wb = new ExcelJS.Workbook()
    await wb.xlsx.load(await this.file.arrayBuffer())
    const out = await wb.xlsx.writeBuffer()
    this.download(out)
  } catch (e) {
    console.error(e)
  }
}

The expected behaviour:

Unlocked cells should maintain their vertical and horizontal alignments.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions