(example is Excel spreadsheet, I need one made in html format),
which is generated via pre-set data, on forms. So the main criteria is that all those numbers and letters in range H24:AL103 (see the example attachement) must be editable live and saved on temporary table. Like in Google docs. I enter something, quit it and can return whenever I want and continue editing it with its saved progress. In the end user can press completed and table is no longer editable and waiting for verification after which it is exportable to .xls, .pdf and printable.
Anyone can offer any practices on this one?[/font][/size]
Tables (read: cells) that are editable and updatable through the user interface without switching pages require some more coding then Yii offers out of the box. If you want to create something that feels and acts like Google Drive’s spreadsheets, you need (afaik) AJAX interaction through JavaScript.
I did some Googling whether there are Yii extensions that enable you to create such tables and found X-editable. Probably you’ll find some more if you check yourself.