No Branch/Tag Specified

ThomasChan/master

gh-pages

grantfayvor/master

ivan-trusov/fix-basedate

master

maybeswapnil/issue2737

mgreter/master

nandanv2702/issue_1300

protobi/master

sankhavaramsaitulasiram/feat-fix-2752

scottysseus/2560_2

tom-groves/bug-1105/rounding-error

v0.10.0

v0.10.1

v0.10.2

v0.10.3

v0.10.4

v0.10.5

v0.10.6

v0.10.7

v0.10.8

v0.10.9

v0.11.0

v0.11.1

v0.11.10

v0.11.11

v0.11.12

v0.11.13

v0.11.14

v0.11.15

v0.11.16

v0.11.17

v0.11.18

v0.11.19

v0.11.2

v0.11.3

v0.11.4

v0.11.5

v0.11.6

v0.11.7

v0.11.8

v0.11.9

v0.12.0

v0.12.1

v0.12.10

v0.12.11

v0.12.12

v0.12.13

v0.12.2

v0.12.3

v0.12.4

v0.12.5

v0.12.6

v0.12.7

v0.12.8

v0.12.9

v0.13.0

v0.13.1

v0.13.3

v0.13.4

v0.13.5

v0.14.0

v0.15.2

v0.15.5

v0.15.6

v0.16.0

v0.16.1

v0.16.2

v0.16.3

v0.16.5

v0.16.6

v0.16.7

v0.16.8

v0.17.0

v0.17.5

v0.18.0+deno

v0.18.1

v0.18.2

v0.18.3

v0.18.4

v0.18.4+deno

v0.18.5

v0.18.6

v0.4.3

v0.5.0

v0.5.10

v0.5.7

v0.5.8

v0.5.9

v0.7.1

v0.7.10

v0.7.11

v0.7.2

v0.7.3

v0.7.4

v0.7.5

v0.7.6

v0.7.6-a

v0.7.6-h

v0.7.6-i

v0.7.7

v0.7.9

v0.8.0

v0.8.1

v0.8.2

v0.8.3

v0.8.4

v0.8.5

v0.8.6

v0.8.7

v0.8.8

v0.87

v0.9.0

v0.9.1

v0.9.10

v0.9.11

v0.9.12

v0.9.13

v0.9.2

v0.9.3

v0.9.4

v0.9.5

v0.9.6

v0.9.7

v0.9.8

v0.9.9

**Labels**

Apply labels

Clear labels

DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue

**Milestone**

Set milestone

Clear milestone

No items

No Milestone

**Projects**

Clear projects

No project

**Assignees**

Assign users

Clear assignees

No Assignees

**2 Participants**

**Notifications**

**Due Date**

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

**Dependencies**

No dependencies set.

Reference: sheetjs/sheetjs#2820

Reference in new issue

There is no content yet.

Delete Branch '%!s(<nil>)'

Deleting a branch is permanent. It **CANNOT** be undone. Continue?

No

Yes

this is my code:

in practice I go through the errors and group them by giving levels.

my problem is as follows (see img):

however, the grouping ends with the last unequal element.

is there the possibility to move the + up directly in the row of the first element?

Cattura.PNGIn the screenshot, rows 106:110 have a deeper level assignment. There are two possible rows for the collapse/expand icon (the +/- symbol): the row after the group (111) or the row before the group (105).

The default behavior is to show the grouping icon after the group (111 in your example). To show it on row 105, set the

`!outline`

property as described in https://docs.sheetjs.com/docs/csf/sheet#worksheet-object :Excuse the question, but in which part of my code should I enter this code?

In your example, there is a

`wsrows`

variable that represents the rows array. You are either:A) building

`wsrows`

and assigning back to the worksheet:B) setting

`wsrows`

to the worksheet property and mutating:You can add the line right after either block, replacing

`ws`

with the name of the worksheet variablenot work for my code

Note that it is a worksheet-level setting, so you cannot show some icons below and some icons above within the same worksheet.

Ensure you are using the latest version: https://docs.sheetjs.com/docs/getting-started/#installation

When you write, pass the option

`cellStyles: true`

.Here is a live example https://jsfiddle.net/se26pz1x/

Code(click to show)The resource https://cdn.sheetjs.com/xlsx-0.19.0/package/dist/xlsx.full.min.js is loaded before the script is run

my code is structured in a much more complex way, is there any way to share it?

ps: I have the latest version of xlsx

We've explained the situation and provided a live demo.

If you want a SheetJS teammate to take a look at your code, we can offer paid support. Please send an email to hello@sheetjs.com for more info.

I saw the live but the problem is not solved in that case anyway.

as we said, the result that I would like is that the grouping does not end with - in the element following the grouping itself but in the first with a +.

I'm sorry for bothering you and sorry for the questions.

however, the problem is not solved.

good evening

If you open the demo page, it will generate an Excel file. Open the file in Excel. There are two worksheets. In each worksheet, rows 2:9 (SheetJS rows 1 to 8) are grouped.

In the "Below" worksheet (see "issue2820below" screenshot), the grouping symbol shows up in Excel row 10

In the "Above" worksheet (see "issue2820above" screenshot), the outline property is set and the grouping symbol shows up in Excel row 1

The symbol is (-) because each row is visible (and clicking the icon will collapse the rows.

Are you asking about something different?

issue2820below.pngissue2820above.pngSorry, the code is certainly exact but it varies according to the excel with which I open the file.

furthermore, loading it in the drive does not bring the changes back.

this work with openoffice but not with excel or drive