#faster than native spreadsheets?... coming soon :)
the ajax spreadsheet
Easy & Wicked Fast spreadsheets for the web
Home Page: http://spreadsheets.github.io/WickedGrid
#faster than native spreadsheets?... coming soon :)
the ajax spreadsheet
'Spreadsheet Title'!A1:A10 does not work - gives error TypeError: s.loader is null
using latest v4 from github
is working with bootstrap or are you planing to support bootstrap?
I've been playing around and was wondering how I could implement a delete button on a sheet.
I have tried in the console on your demo site, but I am seeing erratic behavior.
The command I am using is $sheet.instance[0].deleteSheet(2), for example, on an instance that has 10 sheets. Sometimes the second sheet is deleted, the first, the last with no particular pattern as to why this is happening. Am I using this correctly?
Thanks
*** Edit ***
Ok, I see what's happening. I used $('#sheet').getSheet().deleteSheet() which appears to get the currently selected sheet and delete it. That explains the thing I saw, so it seems to be working right. One thing I have noticed, it that if you delete a sheet other than the last one, one can no longer select the sheet tab at the deleted location when the tab array shifts. (e,g out of 10 sheet tabs, if I delete the 5th tab then the tab array shifts to the left as expected with the exception that the 5th tab can no longer be selected and the tabs that follow have issues being selected. )
Hi there.
In which way do I should make to export the tables?
I try to not use examples, thus I just loadSheet jquery.sheet.html.
The problem is when I export the tables to XLS (I use btechco_excelexport), the menus and the others in the mainWrapper is also exported.
I thought that's because there's no table ID, but later still couldn't find it.
Some suggestion may help me, thanks.
Initial phase with just formula parsing and if it helps performance, resolving of formulas to cells too.
Tested on Tiki trunk r49288, Sheet 3.1.rc5
Created a simple chart with something like =PIECHART(D2:D8, E2:E8) (adapted to my case)
The chart was created in the cell where I typed the formula, very small in size.
I attempted to resize the cell, and then the chart dissappeared, as well as the syntax that I wrote on that cell.
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
Hi,
In repository are missing some folders and files.
Check preLoad method:
dependencies:{
coreCss:{css:'jquery.sheet.css'},
formulaParser:{script:'parser/formula/formula.js'},
tsvParser:{script:'parser/tsv/tsv.js'},
jQueryUI:{script:'jquery-ui/jquery-ui.min.js', thirdParty:true},
jQueryUIThemeRoller:{css:'jquery-ui/themes/smootheness/jquery-ui.min.css', thirdParty:true},
globalize:{script:'globalize/lib/globalize.js', thirdParty:true},
nearest:{script:'jquery-nearest/jquery.nearest.min.js', thirdParty:true}
},
/**
* Contains the optional plugins if you use $.sheet.preLoad();
* @memberOf jQuery.sheet
*/
optional:{
//native
advancedFn:{script:'plugins/jquery.sheet.advancedfn.js'},
dts:{script:'plugins/jquery.sheet.dts.js'},
financeFn:{script:'plugins/jquery.sheet.financefn.js'},
//3rd party
colorPicker:{
css:'really-simple-color-picker/jquery.colorPicker.css',
script:'really-simple-color-picker/jquery.colorPicker.min.js',
bower:true
},
Best Regards.
So if say A1:B2 are merged, and I scroll one cell to the right, B1:B2 are no longer merged.
I just tried to install jQuery.sheet but none of the examples worked, because MouseWheel did not get installed.
https://github.com/Spreadsheets/jQuery.sheet/blob/master/Sheet/sheet.js#L995
On windows 7 64bit, firefox
steps:
1 open jquery.sheet.html
2 click one cell,input some string
3 click another cell
4 the previous inputed cell text‘s font color is white, the same as the background, and show error on js console
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
Hi,
After merged some cells I tried to export them (I tried to do this in example dts.test.html)
After run this, I merged some cells from console and till this everything look correct.
While exporting data (I can't see in code /colspan="2"/ ) and new sheet is not correct merged.
It has cell with style display=none but the previous one doesnt have the "colspan=2"
Is this some bug ?
Please help :)
rgds
Marek
Missing bower_components MouseWheel/MouseWheel. Js
and so on
TypeError: spreadsheet[row][1].td[0] is undefined
parentEle = spreadsheet[row][1].td[0].parentNode;
jquery.sheet.dts.js - line 367
Hi Robert, it seems that fixing issue 39 may have introduced a new bug.
Now when I load a previously saved spreadsheet, then I update a cell and then try to save the spreadsheet I get the error:
Error: cell doesn't exist
throw new Error("cell doesn't exist"); Line 7494 col 6
I'm using the latest version 4 commit from Github
There doesn't seem to be any web-based spreadsheets:
https://packagist.org/search/?q=sheet
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
Using the DTS example, I hid a column and then converted to JSON. The restored table does not have the column hidden. Is this easy to fix?
If there are multiple spreadsheets in the same page, the click and keyboard events can be handled by the wrong instance.
In the following example, the only spreadsheet that has in-place-editing with a single mouse click is the one in the center, because it was created last.
In the other instances, editing cells requires a double click to open the yellow box, then a further click to focus.
Clicking on the left spreadsheet while a cell is being edited in the center sheet also does not end the editing. Keys are still read by the center instance. The same happens for the TAB to switch to the next cell.
For my use, since I really only need one of the spreadsheets to be editable, I disabled the setting on document.onkeydown in the spreadsheet that is not edited, and it works.
<!DOCTYPE html>
<html>
<head>
<script src="jQuery.sheet/jquery-1.10.2.min.js"></script>
<script src="jQuery.sheet/jquery.sheet.js"></script>
</head>
<body>
<div id="left" style="width:400px; float:left">
<table><tr><td></td><td></td><td></td></tr></table>
</div>
<div id="center" style="width:400px; float:left">
<table><tr><td></td><td></td><td></td></tr></table>
</div>
<div id="right" style="width:400px; float:left">
<table><tr><td></td><td></td><td></td></tr></table>
</div>
<script>
$.sheet.preLoad('jQuery.sheet/');
$(function(){
$('#left').sheet();
$('#right').sheet();
$('#center').sheet();
});
</script>
</body>
</html>
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
In ie7 the edit toobal is not displayed, and some charts are not rendered very well.
Hi,
On my opinion, using the bower is good for repository size, but is not good for plugin, because you need always be "on alert" because the 3rd party plugins can be changed, and you need refactor your code.
At this moment, you need refactor this line:
jS.undo.manager.register(u, jS.undo.removeCells, [before, id], 'Remove Cells', u, jS.undo.createCells, [after, null, id], 'Create Cells');
Because the Javascript-Undo-Manager plugin was changed recently by author.
Best Regards.
Hi Robert, great plugin which I'm intending to use for a major project.
So far I'm able to save the spreadsheet's JSON data in a database and then load it back to regenerate a spreadsheet without any problem.
However, I've noticed that when I add a new sheet to the workbook (so that the Workbook has more than 1 sheets) and then save it ( first save), it saves and then loads fine. But once loaded (spreadsheet with more than 1 sheet) and then I try to add another sheet ( the 3rd, or 4th etc ... ), I get the following JavaScript error, which breaks the Spreadsheet. Is it a bug or something? Please check...
TypeError: enclosure is undefined
enclosure.style.display = ""; Line 7622, col 20
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
Hi friends ,
I wants to make this plugin ruby on rails compatible any one have any idea or i can start work on it , please suggest .
Thanks .
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
Hi,
Looking into "jquery.sheet.css" file I've noted a pair of ".jSParent .jSBarTopMenuButton" rules, where the first one define a margin-right property that directly constraint space of the down triangle defined as span element with css class "ui-icon ui-icon-triangle-1-s".
If margin-right is used for fly-out column contextual menu activation button horizontal positioning, why the aforementioned css rule define a margin-right value of 30px instead of 18px (ie, the triangle button width)?
Thank for your reply in advance.
Best regards, Giorgio Arata.
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
I do not know if this is by design or un issue?
http://visop-dev.com/jQuery.sheet/jquery.sheet.html#
under the tab File, there is only one drop down tab New.
What has happened to Save, Open, and Close?
I get a 404 error when I visit http://visop-dev.com/doc/js3/index.html
Hi I'm having an issue loading data from JSON into the spreadsheet. I would like to modify the content of the spreadsheet. Save the content, then reload saved content.
Original screenshot (screenshot #1)
jQuery('#selectedSheet').html(jQuery.sheet.dts.toTables.json(res.data)).sheet();
The data is replaced, however the menu's are removed (screenshot #2)
var sheet = jQuery('#selectedSheet').getSheet();
sheet.openSheet(jQuery.sheet.dts.toTables.json(res.data));
The data remains unchanged and the menu is moved below the spreadsheet content.
I would like to replace the content of spreadsheet with the JSON data. However, I would like to keep the menu and the original state of the spreadsheet.
Please help,
Sonu
When you add a row, two rows will share the same number.
So, all calculations will be wrong in this row.
Right click on the mouse and choose “insert row after or insert row before”.
The numbering of rows incorrect.
All the calculations refers to any cells of this row will be wrong.
See the attached pictures (Picture_1 & Picture_2).
when i call jS.cellHandler.cellValue("A1"); give me in console cell is null
It causes the window to glitch into view, but could be very bad, especially when dealing with larger spreadsheets.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.