Set level rows up in the first element #2820
Labels
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
No Milestone
No Assignees
2 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: sheetjs/sheetjs#2820
Loading…
Reference in New Issue
No description provided.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
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?
In 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?
Sorry, 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