Stack Overflow
Stack Overflow

Questions tagged [spreadjs]

SpreadJS is a comprehensive spreadsheet component for JavaScript. Powerful Excel Formula support, tables, data visualization, charts and more...

SpreadJS is a comprehensive spreadsheet component for JavaScript. Powerful Excel Formula support, tables, data visualization, charts and more... http://spread.grapecity.com

61 questions
1
vote
2 answers

Place Formulas (setFormula) on SpreadJS headers (colHeader)

I currently have a solution using AngularJS/SpreadJS where we need to update the header section with a formula. When we change a cell value in the header using setValue everythign displays ok, however we need to display a formula using setFormula,…
joeCarpenter
  • 1,495
  • 4
  • 19
  • 32
0
votes
1 answer

Avoid pagebreak in merged rows or ranges in SpreadJS

I have a table with more than 1500 rows in SpreadJS, with many merged cells spanning multiple rows, but only in some columns. When printing or exporting, I need to prevent pagebreaks inside the merged cells. I have not found any setting in printing…
Nacho B
  • 1,573
  • 1
  • 12
  • 16
0
votes
0 answers

How to custom tooltip in Spreadjs chart( multi chart types)

I'm use a Spreadjs chart. The tooltip will appear when I hover over a point data, the tooltip will be displayed. However, the tooltip uses the same structure when I hover over a column or any other point. And I want a different background tooltip…
Phạm Quốc Vương
  • 1
  • 1
0
votes
1 answer

How to open new SpreadJS file type of .sjs in a Blazor WASM application?

SpreadJS just released v16. How do I open the new file type of .sjs? This is a compressed/zipped file. I tried creating a javascript Blob and passing this blob to spread.open(). See below. openFileWithSjs: function (host, sjsFile) { try { …
Tyler Franklin
  • 189
  • 1
  • 10
0
votes
0 answers

How to locate HTML elements in SpreadJS

My company uses SpreadJS to embed an Excel like sheet into a web page. I'm trying to find a way to create automation tests for this, but I'm unable to locate any of the document information due to the following error: "You need a browser which full…
Robert
  • 183
  • 2
  • 13
0
votes
1 answer

SpreadJS SetStyle event not called on `undo`

I'm using SpreadJS in my application, and came accros this behavior. When I set a style the SetStyle event is called. When I hit UNDO, the SetStyle event is not called. If I press REDO the SetStyle event is called. I was wondering, does UNDO call a…
JudgeProphet
  • 1,687
  • 3
  • 26
  • 44
0
votes
1 answer

Remove the filter arrows from the first row in a themed SpreadJS table

I am working with SpreadJS for the first time, and am busy wrapping my head around how the table styling works. I am theming to apply styles over the entire table, but there is a funny thing happening when I do so. Whenever I apply a theme, whether…
phunder
  • 1,607
  • 3
  • 17
  • 33
0
votes
1 answer

Grapecity spread-sheets-pdf: savePDF() is not a function

Using NodeJs I'm trying to write a small API with Grapecity SpreadJs library. In my project I have installed the following libraries: "@grapecity/spread-excelio": "^14.2.0", "@grapecity/spread-sheets": "^14.1.2", "@grapecity/spread-sheets-pdf":…
mdavi
  • 53
  • 8
0
votes
1 answer

How to Iterate through cells within particular columns

I have a spread sheet and I am trying to set a backColor for cells with empty values of some particular columns. Presently, I can iterate through the spread sheet and set the backColor for all cells with empty values, but I want to narrow it down to…
teestunna
  • 197
  • 4
  • 17
0
votes
1 answer

Import Array of JSON Data into spread JS

I am trying to import an array of object into spreadjs, I am using the fromJSON method but it doesnt get imported, my data is an array of object that looks like this let jsonObj = [{ 'name' : 'One', 'id': 1, 'colour': 'blue' }, { 'name' :…
teestunna
  • 197
  • 4
  • 17
0
votes
1 answer

Integrate SpreadJS in Oracle APEX

I am new to Oracle APEX, i am using apex version 21.1.0, i just want to upload excel file with password protected, so i have used Spread JS java script plugin, while i am trying to integrate i am getting this below error which attached in…
user3321757
  • 37
  • 1
  • 8
0
votes
1 answer

Trying to integrate SpreadJS Designer Component in a React Project

So I've been trying to integrate SpreadJS Designer Component (npm module) into my React project following this Quick Start guide for React. After trying for some time I got it to work like this, Spreadsheet is working (shapes, charts, colors and…
Chamuth Chamandana
  • 110
  • 1
  • 13
0
votes
1 answer

Uncaught TypeError: Cannot read property 'calcOnDemand' of null

I'm getting this error when I click outside the spreadsheet, after creating a new blank file from the File tab What is the problem in this?
wtartanus
  • 21
  • 2
0
votes
1 answer

How to intercept a right-click on a cell in spreadJS

I'm trying to intercept a right-click event with spreadJS, sadly the event doesn't exist on the list : SpreadJS Events Type, only left click can be intercepted. Is there any way to intercept a right-click on a cell? I know we can customize the…
Ganbin
  • 2,004
  • 2
  • 12
  • 19
0
votes
0 answers

spreadjs with jhipster not working while generated project though online UI monolithic project

I have created the project though jhipster online ui application and trying to use spreadjs . I am getting the error ERROR in node_modules/@grapecity/spread-sheets-angular/dist/gc.spread.sheets.angular.ts:247:17 - error TS7029: Fallthrough case in…
shiv roy
  • 11
  • 1
  • 3
1
2
3 4 5