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

SpreadJS FromJson Chart load

I'm using SpreadJS v12 as a reporting tool. User will enter the page get the wanted data, create charts and save it for later use. When user saves the report I get Json data (GC.Spread.Sheets.Workbook.toJSon) and save this Json to database and…
xeon
  • 71
  • 9
0
votes
1 answer

Selenium driver for testing SpreadJS

How could I make click(events) on the basis of cell position in spreadJs? I try something like: sheet.setActiveCell(3,3); sheet.cellClick(); and sheet.getCell(3,3).cellClick(); But it's not working. Thanks in advance if any solution or advice.
Jack
  • 5
  • 1
0
votes
1 answer

Best way to display and edit an Excel workbook on a web page

Purpose - I want to display an excel workbook (Macro) on a web-page in Angular 2-4 project. In an angular application I want to allow use to see an Excel workbook (Macro) data, and user must have the ability to edit it on the web page it self. This…
0
votes
1 answer

How can I upgrade spreadACtions.none in spreadjs 10?

I am upgrading spreadjs 8 to 10. By the way I cannot upgrade this line. sheet.addKeyMap(GC.Spread.Sheets.Key.del, false, false, false, false, GC.Spread.Sheets.SpreadActions.none); I think this is delete disable function. How can I…
0
votes
1 answer

Uncaught TypeError: Cannot read property 'Spread' of undefined with Angularjs

I have an AngularJS project where I'm incorporating SpreadJS. I dynamically loading teh js and css files through gulp and these are loading into my main index.html file good. However when I try creating a new "spreadsheet" for the first time I get…
joeCarpenter
  • 1,495
  • 4
  • 19
  • 32
0
votes
1 answer

Get RowHeader Text in SpreadJs

I want to get the row header text, after clicking on any specific row. It could be number/alphabet. Yes, I'm able to get its index. But I want to get its text value, which i'm needed to show elsewhere in my case. I didn't found any idea or solution…
Fazal Shah
  • 73
  • 1
  • 9
0
votes
1 answer

Event Trigger in SpreadJs

How could I make click(events) on the basis of cell position in spreadJs. Ok, I know to change certain Css properties and get the cell value. But, I need to trigger click function dynamically.... Say Something like "sheet.getCell(5,5).click()" as in…
Fazal Shah
  • 73
  • 1
  • 9
0
votes
1 answer

Copy a full sheet between two instances of SpreadJS

I have two spreads in my interface: SpreadA and SpreadB. Both of them have a sheet called MySheet and I am trying to copy the contents of MySheet in SpreadA and paste them into MySheet in SpreadB. I have used ClipboardPasteUndoAction but it's not…
Juan Rivillas
  • 897
  • 2
  • 9
  • 23
0
votes
1 answer

Spreadjs references from iframe

We use an iframe in the parent page, that is dynamically replaced with other pages. Spread is loaded in the parent. Is there some type of plugin that will allow me to access the spread core that is loaded in the parent from the iframe pages without…
Abu Sufyan
  • 197
  • 1
  • 2
  • 14
0
votes
1 answer

SpreadJS ClipboardPasteOptions is set to "All" but no formatting is applied

i open a spreadsheet and i can see in console: _clipBoardOptions: "All" in activeSheet obj. but whenever i try to paste formatting from excel it just passes the value. any thoughts on were i'm going wrong.? Basically the default is "All" but no…
fedesc
  • 2,554
  • 2
  • 23
  • 39
0
votes
1 answer

Disable "Cut", "Copy" & "Paste" in wijmo spreadjs ipad

I am loading xlsx files in the iPad using wijmo spreadJs framework. When i select a cell i am be to see "Cut", "Copy" & "Paste" option be default. I want to disable it.
Warrior
  • 39,156
  • 44
  • 139
  • 214
-1
votes
1 answer

Two-Variable Data Table in JavaScript

Can I create a "Two-Variable Data Table" (aka "Two-Way Data Table") in JavaScript? In Excel, of course, this can be found in the Data, What-If Analysis, Data Table menu sequence.
-1
votes
1 answer

SpreadJS: show headers even for empty sheets

Library name: [GrapeCity's SpreadJS][1] Need to show header even for empty sheets. Right now, for an empty sheet, I only have this picture, no header. Anybody have idea how to do it? EDIT: Table header missing
Jalle
  • 1,566
  • 5
  • 22
  • 42
-1
votes
1 answer

Got some strange console errors in firefox when loading spreadjs

Got some undefined errors like a is undefined , r.spread is defined from the spreadjs-all.min.js. What are the scenarios for these errors occurs. I have loaded my spreadsheet in an iframe. Is this cause any error ? Only getting this error is…
Aswathy S
  • 729
  • 1
  • 12
  • 41
-2
votes
1 answer

icons and some buttons of spreadjs is not working

in this image paste button,find button and some of the default buttons are not working is there anything with the package that need to change, or which package is it for icons