Search found 8 matches

Go to advanced search

by icegood
Thu Jan 12, 2017 8:12 am
Forum: XLSReadWritwII 6
Topic: BIFF8 cell coment
Replies: 5
Views: 2879

Re: BIFF8 cell coment

Hi, tnx for reply. In my case both xls.Sheets[0].Comments.Count xls.Sheets[1].Comments.Count are zero and xls.Sheets[0].Comments.AsPlainText[0, 0]/xls.Sheets[1].Comments.AsPlainText[0, 0] are empty. However on other Excels everything is OK (xls.Version=xvExcel97). How can i find which exact version ...
by icegood
Wed Jan 11, 2017 3:37 pm
Forum: XLSReadWritwII 6
Topic: BIFF8 cell coment
Replies: 5
Views: 2879

Re: BIFF8 cell coment

Hi, sorry for delay.
You can find file in
https://drive.google.com/file/d/0B4mLkz ... sp=sharing.
seems comments in Cell[1,1] are refused to read by XLS Suite 5.
by icegood
Wed Nov 09, 2016 11:11 am
Forum: XLSReadWritwII 6
Topic: BIFF8 cell coment
Replies: 5
Views: 2879

BIFF8 cell coment

Seems, BIFF8 cell comment doesn't processed properly while rerading excel'97(BIFFRECID_NOTE = $001C to process). Comments are always empty.
by icegood
Sun Jul 03, 2016 8:24 pm
Forum: XLSReadWritwII 6
Topic: array formulas
Replies: 1
Views: 1836

array formulas

Hi there again. Does library support so-called array formulas for example
=SUM(C$2:C$7*D$2:D$7)
to calculate it you should press ctrl+shift+enter.
More examples here: https://support.office.com/en-us/articl ... 361075954d
by icegood
Fri Jun 03, 2016 11:18 am
Forum: XLSReadWritwII 6
Topic: range of cells as argument
Replies: 1
Views: 1849

Re: range of cells as argument

Sorry, my fault. I hasn't used ';' as delimiter between arguments. Everything works!
by icegood
Fri Jun 03, 2016 9:48 am
Forum: XLSReadWritwII 6
Topic: range of cells as argument
Replies: 1
Views: 1849

range of cells as argument

Hi again. From my previous post i was unable to work with complicated arrays (e.g. those ones that have > 1 values in each array element) Now i've tried to workaround it via cell ranges but while parsing VLOOKUP(V9, A1:C3, 3, 1) i've obtained error E4003: Invalid fractional number I wonder is there ...
by icegood
Thu Jun 02, 2016 12:50 pm
Forum: XLSReadWritwII 6
Topic: Multirow arrays
Replies: 1
Views: 1869

Multirow arrays

Hi, there. Does Suite5 support multi-row arrays as the described there
https://forum.openoffice.org/en/forum/v ... =9&t=83641
?
by icegood
Mon May 30, 2016 8:25 pm
Forum: XLSReadWritwII 6
Topic: TXLSDataValidation: aggregation or inheritance
Replies: 1
Views: 1663

TXLSDataValidation: aggregation or inheritance

hi there, have in code

Code: Select all

type TXLSDataValidation = class(TXc12DataValidation)
...
protected
   FData: TXc12DataValidation;

...

procedure TXLSDataValidation.SetType_(const Value: TXc12DataValidationType);
begin
  FData.Type_ := Value;
end;
do you work via aggregation or via inheritance????

Go to advanced search