https://bugs.documentfoundation.org/show_bug.cgi?id=170397
Bug ID: 170397
Summary: XLSX Import: Manual column widths ignored and
auto-shrunk to minimum content width (AutoFit) during
rendering
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
I would like to report a rendering/import issue regarding column widths in
Excel (.xlsx) files.
When opening or previewing an uploaded Excel file, the application seems to
ignore the manually set column widths and forces an "AutoFit" behavior based on
the content length.
Steps to Reproduce:
1. Create a new spreadsheet in **Microsoft Excel** and save it as `test.xlsx`.
2. In a column, enter a short text string (e.g., `"Test"`).
3. Manually expand the column width to a value significantly wider than the
content
(e.g., set the width to **20 or 30**).
4. *(Optional but recommended)* Create merged cells in adjacent rows to better
expose layout issues.
5. Convert the Excel file to PDF using LibreOffice in headless mode with the
following command:
```bash
soffice --headless --convert-to pdf test.xlsx
Actual Results:
The column width in the generated PDF is automatically reduced to fit the text
content, as if AutoFit were applied, ignoring the manually defined column width
set in Excel.
Expected Results:
The column width in the output PDF should preserve the original width defined
in Excel, regardless of the content length.
Reproducible: Always
User Profile Reset: No
Additional Info:
## Version of LibreOffice
sh-4.4# /opt/libreoffice7.5/program/soffice --version
LibreOffice 7.5.3.2 9f56dff12ba03b9acd7730a5a481eea045e468f3
## System info
Report generated on Tue Jan 20 07:35:37 AM UTC 2026
========================================
SYSTEM INFORMATION
========================================
Kernel: Linux 6.17.8-orbstack-00308-g8f9c941121b1
Hostname: 320dcd6f6c2c
NAME="SLES"
VERSION_ID="15.7"
PRETTY_NAME="SUSE Linux Enterprise Server 15 SP7"
CPE_NAME="cpe:/o:suse:sles:15:sp7"
========================================
DISPLAY ENVIRONMENT
========================================
XDG_SESSION_TYPE: Unknown
XDG_CURRENT_DESKTOP: Unknown
DESKTOP_SESSION: Unknown
GDK_BACKEND: Unset
QT_QPA_PLATFORM: Unset
========================================
GRAPHICS / GPU
========================================
> Command: lspci (NOT FOUND)
> Command: glxinfo (NOT FOUND)
========================================
LIBREOFFICE VERSION
========================================
Standard 'libreoffice' or 'soffice' command not found in PATH.
========================================
LO SPECIFIC ENV VARS
========================================
========================================
JAVA
========================================
> Command: java -version
openjdk version "21.0.7" 2025-04-15 LTS
OpenJDK Runtime Environment SapMachine (build 21.0.7+6-LTS)
OpenJDK 64-Bit Server VM SapMachine (build 21.0.7+6-LTS, mixed mode, sharing)
--
You are receiving this mail because:
You are the assignee for the bug.