SpreadSheet & Char(10) Wrapping Mode

Webix JS
1

It would be great if having the formula

=“FirstLine” & Char(10) & “SecondLine”

wrapped the text in cell wrapping mode. Currently this does not seem to work.

3

Hello @adz,

It would be great if having the formula

=“FirstLine” & Char(10) & “SecondLine”

wrapped the text in cell wrapping mode. Currently this does not seem to work.

By default, newline characters are handled the same as other white space characters within the cells. This behaviour can be changed via the white-space CSS property, e.g.: Code Snippet.

4

Hi, this stopped working with webix 11 :confused: . Anything you can do about?

5

Hello @bikerboy ,
There were changes in the formulas starting from version 11:

You just need to specify that “text” methods are available to use CHAR() function: Code Snippet .

6

Thx for the quick reply. Still got a problem because anytime i use then data-Part in my JetApp the spreadsheet is not redered

{
					localId: "spreadsheet",
					view: "spreadsheet",
					disabled: false,
					url: "",
					datatype: "excel",
					toolbar: [
						{
							cols: [{view: "label", label: "Datentyp:", width: 80}, {$button: "format"}, {}],
						},
					],
					data: {
						data: [[1, 1, "Hallo Welt", "", "string"]],
						table: {
							frozenColumns: 0,
							frozenRows: 0,
							gridlines: 1,
							headers: 1,
						},
					},
				},
7

and my spreadsheet only has 20 columns but i am working with 48. I can set them via setCellValue, but they are not visible

8

A. datatype property is used when a type of data loaded by url/defined in the data differs from the expected by default JSON type.
If you define your data as in the snippet, you do not need a datatype (or is should be a “json” type):
Code Snippet .
Otherwise, Spreadsheet tries to parse your data as data of an excel type and fails with an error

B. By default columnCount is 20 until another value is set: Code Snippet .
In general, the amount of rows/columns changes dynamically depending on the data that gets parsed to it. However, Spreadsheet respects the set rowCount/columnCount property values and displays a set amount of rows/columns (50 rows, 20 columns by default), even if the data does not occupy them. So, if you would like to increase the initial amount of columns, you can do it with a columnCount property.