exceljs/exceljs

Column width not accurate

Open

#744 opened on Feb 9, 2019

View on GitHub
 (13 comments) (3 reactions) (0 assignees)JavaScript (11,838 stars) (1,534 forks)batch import
bughelp wanted

Description

Hi, If I want to define the column width, I need to add to almost every width a value of 0.71. So if I want a width of 12, I need actually to define it like column.width = 12.71. Only when it comes to the width of less then 1, this addition actually varies.

Does anybody have an experience, what could cause such a behavior?

Thanks

Contributor guide

Tech stack
javascriptnodejs
Domain
backenddata
Issue type
bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
needs investigation
Prerequisites
understanding of Excel column width unitsJavaScript
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
30
Research direction
Investigate the column width calculation in ExcelJS, specifically how pixel width is converted to Excel's character width. Look at the source code in the `lib/` directory for column width logic. Compare with Excel's specification (1 unit = 7 pixels?). Check if there's an offset issue. The issue mentions adding 0.71, so examine the constants used. Also look at any related issues or PRs.