close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 14 years ago

Closed 14 years ago

#1100 closed task (fixed)

New function Excel.ReadSeries

Reported by: Jorge Owned by: Jorge
Priority: highest Milestone: Mantainance
Component: Excel API Version: 2.0.1
Severity: critical Keywords:
Cc:

Description

It is requested the implementation of a function to read a set of series from a worksheet:

  Set Excel.ReadSeries( Real handle, Anything cornerLeftTop, Anything cornerRightBottom [, TimeSet dating ]  );

The range defined by [cornerLeftTop,cornerRightBottom] is such as the first column is considered as the dates supporting the series data which are specified from the second column on.

Change History (5)

comment:1 Changed 14 years ago by Jorge

Status: new → accepted

comment:2 Changed 14 years ago by Jorge

(In [3213]) refs #1100 test code

comment:3 Changed 14 years ago by Jorge

Resolution: → fixed
Status: accepted → closed

(In [3214]) * Updating BasicExcel & FormatExcel

  • Excel.ReadRange: when a columns type is specified all cells are readed as typed. refs #1099
  • Excel.ReadSeries: implemented, fixes #1100

comment:4 Changed 14 years ago by Víctor de Buen Remiro

Resolution: fixed
Status: closed → reopened

Description of function tells nothing about default value of dating optional argument.
It should be some like this

  Set Excel.ReadSeries( Real handle, Anything cornerLeftTop, Anything cornerRightBottom [, TimeSet dating = C]  );

It could be also a good feature to get the missed argument dating from de first row of the first columns, like in BDT files. Only if this cell is empty or is not a valid TimeSet then default value C will be taken.

comment:5 Changed 14 years ago by Víctor de Buen Remiro

Resolution: → fixed
Status: reopened → closed

These last proposal can be performed in ImportExport::@Excel

Note: See TracTickets for help on using tickets.