DHTMLX Spreadsheet

New Functionality Requests
#1

Hi,

I might be mistaken, but it should be possible to load data from a pre-defined database right? I’m trying to use the Spreadsheet as a front-end to mysql for editing specified fields in a database table.

I’m able to display/connect to the database based on the documentation, but all I’ve been able to accomplish so far is DHTMLX adding a table to the database named “sheet” and populating it with each subsequent call to the spreadsheet.

Would I be better off looking into the Grid?

Any advice/thoughts are appreciated.

Thanks,
Fury

#2

I might be mistaken, but it should be possible to load data from a pre-defined database right
Nope, spreadsheet uses its custom format of data storage and requires extra table(s) for storing formatting, structure and other info.

If you need to load data from custom table - try to use dhtmlxGrid

#3

Thanks!

I guess I should put in a functionality request to have it be configurable for something like this then? Can I combine the Grid and the Spreadsheet? (I’ll review the Grid more at work today)

Thanks for your quick response,

Fury

#4

You can make grid to look very similar to spreadsheet.
Actually spreadsheet uses dhtmlxgrid inside, and most behaviors ( edit, resizing, data saving ) are native behavior of dhtmlxGrid.

#5

I ran into a weird problem using your plug-in. It works fine initially then all of a sudden, the spreadsheet disappears but the correct space and the insert remains. When I look at the source, this appears:

DOM Source of Selection

The spreadsheet has disappeared at different times during my doing things like: changing the number of columns, modifying a cell contents, etc. It will reappear if I change the ID but then disappear again. I can make some changes and it stays fine but then it disappears on the next refresh sometimes without any additional changes.

I have the latest version of WordPress installed. My browser is Mozilla Firefox.

This is a very cool idea and I love it while it works but I can’t use it as it is now. Any ideas that you have would be appreciated.

#6

Which other plugins you have installed ?
Unfortunately we can’t reconstruct the same issue locally.

#7

Also, copying and pasting multiple cells does not work on a MAC. It all gets concatenated into one cell…