Comments (7)
simple linebreaks in 1.3.18
https://github.com/shuchkin/simplexlsxgen#formatting
from simplexlsxgen.
Hi, great job, but it seems the breakline is not working for me.
I merged cells B1:H1, put them in bold, centered and size 16, then I put some \n but it displayes the "\n" instead of breaking line.
I've tried \r, \n, \r\n, all didn't work.
What should I do?
----EDIT----
It suddenly works. But the line height and font (maybe all from the balise "style") don't work anymore.
----EDIT 2----
I think I've found the issue: to break line, the text must be between double brackets, but the value in the style brackets must also be specified in double brackets. So my solution was to do something like this:
'<style font-size="32">'."text1 \r\n text2".'</style>'
from simplexlsxgen.
use <wraptext>
from simplexlsxgen.
This doesn't change anything in my case. I tried with and without, no difference. Only the trick I wrote did something
from simplexlsxgen.
See difference " and ' quotes
from simplexlsxgen.
See difference " and ' quotes
Yes, this is how I fixed. But I didn't see in the docs explanations about it. Might worth to mention
from simplexlsxgen.
learn php
https://www.php.net/manual/en/language.types.string.php
and donate opensource
from simplexlsxgen.
Related Issues (20)
- Thisis excellent
- Cell text gets trimmed HOT 4
- 1.3.16 seems to have broken compatibility with Libreoffice Calc HOT 3
- _x002d_ is replaced by - HOT 7
- String is passed to date2excel HOT 1
- Can not get formats to work HOT 1
- I should make a drop-down list with Data Validation in Excel.
- Adding a picture HOT 1
- downloadAs or saveAs -> corrupted file HOT 5
- The autoresize of columns doesn't work properly when the first row has a different (bigger) font size than the rest of the rows HOT 4
- Feature Request: Append to Excel File HOT 1
- Hyperlink to internal file HOT 2
- xlsx defect HOT 4
- Replacement in cell2coord will not work HOT 4
- Applying style to a raw value HOT 1
- http2 HOT 3
- SimpleXLSXGen generated spreadsheet can not be parsed by SimpleXLSX HOT 1
- Backspace character corrupts output file. HOT 1
- The presence of a <b></b> tag makes the all entire text bold, not just the text inside this tag. HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from simplexlsxgen.