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

How to add inline style for double underlined text in a cell after copying in spreadjs

I have been trying add custom inline styles for the cells where double underline is applied. My plan was to get the cell where the double underline is aplied and using its indexes find the currosponding td and then aplly custom style/tag. Currently…
tintu
  • 1
  • 3
0
votes
1 answer

Issue with copy pasting of double underlined content from soreadjs to textarea

While copy pasting double underlined content from soreadjs to textarea, underline not getting applied. But in the case of single underline, it is getting pasted. When debugging it is observed that html getting from soreadjs after copying doesn't…
tintu
  • 1
  • 3
0
votes
1 answer

Javascript Query to Set the value in spreadsheet using Selenium

I need to set a cell value through javascript in Selenium as it has been built through spreadjs and i can't obtain the elements value. I used below Query to set the value: string query =…
NamrataH
  • 3
  • 1
0
votes
1 answer

Pasting tables to spreadJS without losing the formatting

I have been trying to paste a table from my tinyMCE text editor to SpreadJS. I am using a custom made clipboard instead of the default one for this operation, and on copy, table values(text, html) from tinyMCE are successfully passed to the…
MSN
  • 15
  • 3
0
votes
1 answer

how to show quick access bar in spreadjs - grapecity

How can I enable quick access bar in spreadjs ? Found js and css for .quick-access-bar class but not found any html for it. Need to enable any options in js?
Aswathy S
  • 729
  • 1
  • 12
  • 41
0
votes
1 answer

change default font in spreadjs

How to change the default font in the toolbar of spreadjs? I tried it with the below code. But it didn't working. var active = spread.getActiveSheet(); sheetstyle.font = "8pt Arial"; active.setDefaultStyle(sheetstyle,…
Aswathy S
  • 729
  • 1
  • 12
  • 41
0
votes
2 answers

Invert grid to display data as details, subtotals and the grand total

I have tried several approaches to no avail. The below screen capture shows a grid with a grand total, followed by subtotals and then details. I need to somewhat invert this grid so that the data displays as details, subtotals and the grand…
user7897422
  • 13
  • 2
  • 8
0
votes
1 answer

Can we have dynamic headers in spreadjs?

I have integrated spreadJS with react framework. In spreadjs they only use the header name specified in JSON and accordingly the data get displayed in the spreadsheet. Can we have dynamic headers and their respective value using JSON? import {…
Nehal Markandeya
  • 1
0
votes
1 answer

How to load fast effectively a large number of spread excel sheets using spreadjs library?

I am using spreadjs and ExcelIO to show a large Excel file having more than 100 sheets in it. I have to show all these sheets on my excel view UI. I am able to show it but this is taking more than 3 minutes of time to load all sheets on UI. I have a…
satyendra kumar
  • 719
  • 2
  • 10
  • 19
0
votes
0 answers

SpreadJS set cursor at end in keyup event

I am using spreadjs to show spreadsheet in my project. There is a bug which I need to fix. 1. set the cell text alignment to center/right. 2. Enter some text and then delete it using backspace. 3. After the backspace is finished(all the text is…
Tushar Thakur
  • 956
  • 3
  • 15
  • 32
0
votes
0 answers

Issue with SpreadJS selenium automation

I am trying to automate spreadJS application using selenium web driver java. I have found something like this, js.executeScript("var spread = new GcSpread.Sheets.Workbook(document.getElementById('ss'));"); And I tried the same after launching the…
Asha
  • 1
0
votes
1 answer

Set the padding in a cell in SpreadJs which auto resizes correctly

When I set the padding of a cell in SpreadJs, then do an auto resize on the row, the cell shrinks to just what the padding is. If I set no padding, then the cell auto resizes to a standard size which is what I would like to happen. I would like the…
user3284707
  • 3,033
  • 3
  • 35
  • 69
0
votes
0 answers

SpreadJs set border on a merged range

I would like to set a border on a merged range using spreadJs spreadsheet library, however I cannot get this to work. const lineStyle = GC.Spread.Sheets.LineStyle; const lineBorder = GC.Spread.Sheets.LineBorder; const borderColor =…
user3284707
  • 3,033
  • 3
  • 35
  • 69
0
votes
1 answer

SpreadJs is not showing some fonts correctly

When using SpreadJs, if I set the font to Roboto, then the spreadsheet displays the font incorrectly. Is there a way to add custom fonts or am I setting this incorrectly? I am setting using the following format, this works for a select set of fonts…
user3284707
  • 3,033
  • 3
  • 35
  • 69
0
votes
1 answer

SpreadJs border not setting

I am trying to set a border using SpreadJs, however it is not working for me. I have taken the example off their help documentation but it does not work, the border does not show…
user3284707
  • 3,033
  • 3
  • 35
  • 69
1 2
3
4 5