Philippe Nobili wrote: > > We had never really used the spreadsheet engine before. We now have in > mind to use it to keep a centralized record of several information > related to our software products. So, the challenge is to be able to > locate easily a product, generate a new unique ID for a new product etc > etc (the tables will be BIG).
The integrated spreadsheet engine adds a computed fields facility to XML documents. It also have facilities to address table cells in a natural way (e.g. A1). Other than that table cells are not treated specially. The integrated spreadsheet engine does not work by embedding an Excel worksheet or an OpenOffice Calc worksheet into XMLmind XML Editor. See http://www.xmlmind.com/xmleditor/_distrib/doc/spreadsheet/index.html > > When the columns/rows labels are shown, it is very tempting to click on > the labels to perform ascending or descending sort... For now, the column/row labels are just a decoration similar to CSS generated content. It is intended to make it easier typing spreadsheet formulas. > What would be the > best way to implement these operations from our side ? > I don't see how you could do this from your side. Given the way the spreadsheet engine has been implemented, sorting a table column would be an editing operation (and not a viewing operation like in a real spreadsheet) which would change the contents of the table cells according to a sort criterion. This editing operation would be somewhat unrelated to the spreadsheet engine.
