Skip to content

how to set cell width wrap by using cell formatting in xlsx? #2081

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
MuraliThangavel opened this issue Sep 18, 2024 · 1 comment
Open
Labels
waiting for customer response Cannot make further progress until the customer responds. xlsIO XlsIO component

Comments

@MuraliThangavel
Copy link

Bug description

Cell width should be wrapped depending on content size. How to adjust the width?

Steps to reproduce

Create a excel file with dynamic content using Worksheet.

Code sample

Code sample

final xlsio.Style style = workbook.styles.add('customFontStyle');
sheet.getRangeByIndex(1, column).cellStyle = style;

Screenshots or Video

Screenshots / Video demonstration

[Upload media here]

Screenshot 2024-09-18 at 6 35 09 PM

Stack Traces

Stack Traces
[Add the Stack Traces here]

On which target platforms have you observed this bug?

Web

Flutter Doctor output

Doctor output

[✓] Flutter (Channel stable, 3.7.12, on macOS 14.5 23F79 darwin-arm64, locale en-IN)
• Flutter version 3.7.12 on channel stable at /Users/nex3015/Dev/flutterSdk/flutter
• Upstream repository https://github.com/flutter/flutter.git
• Framework revision 4d9e56e694 (1 year, 5 months ago), 2023-04-17 21:47:46 -0400
• Engine revision 1a65d409c7
• Dart version 2.19.6
• DevTools version 2.20.1

[✓] Android toolchain - develop for Android devices (Android SDK version 33.0.2)
• Android SDK at /Users/nex3015/Library/Android/sdk
• Platform android-34, build-tools 33.0.2
• Java binary at: /Applications/Android Studio.app/Contents/jbr/Contents/Home/bin/java
• Java version OpenJDK Runtime Environment (build 17.0.6+0-17.0.6b802.4-9586694)
• All Android licenses accepted.

[✓] Xcode - develop for iOS and macOS (Xcode 15.4)
• Xcode at /Applications/Xcode.app/Contents/Developer
• Build 15F31d
• CocoaPods version 1.15.2

[✓] Chrome - develop for the web
• Chrome at /Applications/Google Chrome.app/Contents/MacOS/Google Chrome

[✓] Android Studio (version 2022.2)
• Android Studio at /Applications/Android Studio.app/Contents
• Flutter plugin can be installed from:
🔨 https://plugins.jetbrains.com/plugin/9212-flutter
• Dart plugin can be installed from:
🔨 https://plugins.jetbrains.com/plugin/6351-dart
• Java version OpenJDK Runtime Environment (build 17.0.6+0-17.0.6b802.4-9586694)

[✓] VS Code (version 1.93.0)
• VS Code at /Applications/Visual Studio Code.app/Contents
• Flutter extension version 3.96.0

[✓] Connected device (2 available)
• macOS (desktop) • macos • darwin-arm64 • macOS 14.5 23F79 darwin-arm64
• Chrome (web) • chrome • web-javascript • Google Chrome 128.0.6613.138

[✓] HTTP Host Availability
• All required HTTP hosts are available

• No issues found!

@MuraliThangavel MuraliThangavel changed the title how to set cell width wrap ? how to set cell width wrap by using cell formatting? Sep 18, 2024
@MuraliThangavel MuraliThangavel changed the title how to set cell width wrap by using cell formatting? how to set cell width wrap by using cell formatting in xlsx? Sep 18, 2024
@VijayakumarMariappan VijayakumarMariappan added xlsIO XlsIO component open Open labels Sep 20, 2024
@PandikumarSF2691
Copy link

Hi MuraliThangavel,

Cell width wrapping can be achieved by enabling either AutoFit Rows or AutoFit Columns. For more details, please refer to the user guide link below.

UG Link : Worksheet Rows and Columns Manipulation using Syncfusion Flutter XlsIO

Regards,
Pandi kumar D.

@VijayakumarMariappan VijayakumarMariappan added waiting for customer response Cannot make further progress until the customer responds. and removed open Open labels May 23, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
waiting for customer response Cannot make further progress until the customer responds. xlsIO XlsIO component
Projects
None yet
Development

No branches or pull requests

3 participants