Dear ALL,
Over the last several days, I have been testing the new FSpreadsheetDataset component currently under active development by the author of the great FPSpreadSheet. (The new component is available here:
https://github.com/wp-xyz/FPSpreadsheetDataset).
Overall, is works just fine, but I have noticed a few glitches to which I would like to find a solution:
1) In the FPSpreadsheetDataset component, most of the numeric data in my example spreadsheet are not correctly displayed;
2) Field names containing diacritics (as 'Estação' and 'Posição') are truncated in the FPSpreadsheetDataset component;
3) The font sizes of the DBGrid and WorksheetGrid do not appear to be the same, although they are set to the same values in the Object Inspector (this is not really a problem, I am just curious about it);
4) In the FPSpreadsheetDataset component, the SheetName property is compulsory; could it not be made optional (with the component getting the name of the first sheet by default)?
I just saw that this has been already fixed in the latest release of the FPSpreadsheetDataset component.A sample application that demonstrate these problems is attached, including my example data set.
Thanks in advance for any assistance you can provide.
With
best wishes,
PS I just attempted to install the latest version of the FPSpreadsheetDataset component, but this time had compiler errors as follows:
fpsdataset.pas(322,84) Error: Wrong number of parameters specified for call to "Create"
Error: Found declaration: constructor Create(TCollection);
Error: Found declaration: constructor Create(TFieldDefs;const AnsiString;TFieldType;LongInt;Boolean;LongInt);