spreadsheet config popup issue

Spreadsheet
#1

i have the spreadsheet loading, saving, opening just fine into divs… but when its open and i click the settings cog, the modal interface comes up, the number of rows and columns are now filled out, the checkboxes for show export etc are not checked… i can fill out the fields and checkboxes but when i hit ok the box does not go away and the sheet does not change. cancel also does not close the box or remove the modal … any ideas?

also what are the chances of getting “Fill” functions like excel? Fill down, fill left, fill right, fill up… basically if vertical adjust all formulas in each field to go up or down a row number, if horizontal adjust column in all formulas… saves hours and hours and hours when making complicated spreadsheets for projections etc … ??

im trying to get this program working in crm software we are constructing, if i can get it working the way it needs to, i can justify (and will need to be) buying an enterprise license

#2

the rows and columns are NOT* filled out… typo, sorry

#3

ok figured that one out… just being stupid… needed to load spreadsheet.php?load=js on page load and run

var dhx_<?=$sheet;?> = new dhtmlxSpreadSheet({ load: "/spread/codebase/php/data.php", save: "/spread/codebase/php/data.php", parent: "<?=$hid;?>", icons_path: "/spread/codebase/imgs/icons/" }); dhx_<?=$sheet;?>.load("<?=$sheet;?>");
instead of

<script src="/spread/codebase/spreadsheet.php?math=true&load=/spread/codebase/php/data.php&save=/spread/codebase/php/data.php&sheet=<?=$sheet;?>&parent=<?=$hid;?>" ></script>

for each sheet (calling spreadsheet.php more than once uses the same dhx_spreadsheet object making the options panel not connect to the sheet its launched from)

still wondering about the fill down / left / right thing

#4

Hi,
sorry for the delay in answerring.
Unfortunately spreadsheet doesn’t support fill-feature for now. Maybe it will be implemented in future.