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
9
votes
1 answer

Angular Library Compile Time Error "Invariant violated: No format-path or format"

I have an Angular 11 project that is trying to integrate SpreadJS Designer, but is failing during the ngcc step Compiling @grapecity/spread-sheets-designer-angular : esm2015 as esm2015 with the exception: Error on worker #3: Error: Invariant…
vicatcu
  • 5,407
  • 7
  • 41
  • 65
3
votes
1 answer

Load SpreadJS using jsdom and nodeJS

I am trying to load SpreadJS using Jsdom, But it is giving error: need a browser which full supports HTML5 Canvas to run SpreadJS. Where as jsom doc says it supports canvas. I have installed canvas-prebuilt for jsom. This is the code I have done so…
Saurabh Agrawal
  • 7,581
  • 2
  • 27
  • 51
2
votes
1 answer

SpreadJS not working in Webpack based angular application

I am trying to add the spreadjs library to my Angular 5 application. I am following the tutorial given in this link. https://www.grapecity.com/en/blogs/spread-sheets-and-angular But one difference is there between the tutorial and my application.…
Sumodh S
  • 709
  • 1
  • 14
  • 36
1
vote
1 answer

Spread JS (GrapeCity) How to handler Sheet same name error

When I change same name for a sheet. It appear unexpected message popup. I don't sure about lib's bug or have custom in source code. But have any way to handler error(Spread JS GrapeCity ) message when change sheet name existed? thanks
cuong nguyen manh
  • 308
  • 2
  • 13
1
vote
2 answers

How to know which formulae were recovered / corrupted in an Excel file

I have a program which generates an Excel file. Specifically, it's a node app which generates a JSON file which is loaded into GrapeCity's SpreadJS and exported again via their ExcelIO libs. This file has a lot of formulae in it - at least a…
Richard Wheeldon
  • 973
  • 10
  • 25
1
vote
1 answer

SpreadJS - get updated cell text on keyDown/keyUp event

I am using SpreadJS version 12 What I want is to get cell text/value after each keyDown/keyUp event. when I try to run cell.text() or cell.getValue() I get old value(The value which was present earlier when we focused the cell) for ex. If cell 0,0…
Tushar Thakur
  • 956
  • 3
  • 15
  • 32
1
vote
1 answer

Cypress Testing on spreadJS with canvas

I'm trying to automate using cypress tests on spread JS that is built on canvas. I learnt that the spreadJS instance should be initialised but have no luck as of now. Do we have to use the spreadJS key as well to initialise or can it be done…
Sadiq Rahim
  • 11
  • 1
1
vote
1 answer

No exception being thrown inside SpreadJS event binding

First of all, I'm not sure if this is an Angular problem or ES6 problem. During some refactoring in our app, we extracted a method to a different file and by doing so we made the following mistake: export const setDataTypeToColumn = ( row: any, …
Narshe
  • 427
  • 8
  • 22
1
vote
1 answer

Add empty option to List Validator

I'm trying to add the option to my users that, on a List Validator, to allow select any of the options or a blank option. Spreadjs has the IgnoreBlanks setting, which I use, so when the user uses the delete key or the backspace and deletes the cell…
Narshe
  • 427
  • 8
  • 22
1
vote
1 answer

How to implement excel alt+down key to display the drop down of a List Validator

One of the requirements for my app is to be able to navigate the sheet completely without using the mouse. It seems that for some reason the excel keybind Alt+Down does not work in SpreadJS. I've already implemented a workaround which is basically…
Narshe
  • 427
  • 8
  • 22
1
vote
1 answer

Correct way to import SpreadJS Charting library in an angular application

I'm trying to import the SpreadJS charting library in my angular application but no matter the options I try I never get results. A colleague, however, using the same code and setup, is able to use the charts correctly. The versions we're using…
Narshe
  • 427
  • 8
  • 22
1
vote
2 answers

Add custom cell image/overlay watermark

I would like to be able to watermark a cell in spreadJs with a padlock icon. I want this to be always at the right center of the cell like the image below. Is this possible? I can see the below link does something similar, but this is stretched…
user3284707
  • 3,033
  • 3
  • 35
  • 69
1
vote
0 answers

How to dataBind spreadSheet (SpreadJS) to a server side bean

I have built a Spring WebMVC App with Primefaces. This app contains a list of nodes which can be dragged into the spreadSheet (I m working with SpreadJS). Behind each node there is a model and a bean. Evey node has a name and an input type. For…
S.Fahmi
  • 27
  • 1
  • 6
1
vote
2 answers

How Can I create a custom binding for a SpreadJs datagrid to align a defined column?

When I am creating a new column for my SPreadJs grid, I don't see any property to align my columns. For example: var nameColInfo = { name: "Name", displayName: "Name", size: "150", resizable: true }; I would like to add a new custom binding to my…
Luis Mi
  • 13
  • 8
1
vote
1 answer

How to filter date independent of Timezone?

I have an array of objects where each object has a date property. When I try to filter this array based on date using spread sheet formula like this [Date]=Date(2017,8,2) This formula only works in the timezone +1:00. It does not work any other…
Rahbee Alvee
  • 1,924
  • 7
  • 26
  • 42
1
2 3 4 5