spreadsheets / wickedgrid Goto Github PK

So if say A1:B2 are merged, and I scroll one cell to the right, B1:B2 are no longer merged.

Try to edit a cell, for example writing 40.5 instead of 405, dot stays but numbers vanish.

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

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.

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).
  

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.

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.

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

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?

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

In ie7 the edit toobal is not displayed, and some charts are not rendered very well.

I get a 404 error when I visit http://visop-dev.com/doc/js3/index.html

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.

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.

here:
https://rawgithub.com/Spreadsheets/jQuery.sheet/master/jquery.sheet.html

'Spreadsheet Title'!A1:A10 does not work - gives error TypeError: s.loader is null
using latest v4 from github

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)

1. When I use the following:

jQuery('#selectedSheet').html(jQuery.sheet.dts.toTables.json(res.data)).sheet();

The data is replaced, however the menu's are removed (screenshot #2)

1. When I use the following:

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

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

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 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.

TypeError: spreadsheet[row][1].td[0] is undefined
parentEle = spreadsheet[row][1].td[0].parentNode;

jquery.sheet.dts.js - line 367

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.

It causes the window to glitch into view, but could be very bad, especially when dealing with larger spreadsheets.

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

Initial phase with just formula parsing and if it helps performance, resolving of formulas to cells too.

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. )

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?

is working with bootstrap or are you planing to support bootstrap?

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.

when i call jS.cellHandler.cellValue("A1"); give me in console cell is null

Missing bower_components MouseWheel/MouseWheel. Js
and so on