Page 1 of 1
BIFF8 cell coment
Posted: Wed Nov 09, 2016 11:11 am
by icegood
Seems, BIFF8 cell comment doesn't processed properly while rerading excel'97(BIFFRECID_NOTE = $001C to process). Comments are always empty.
Re: BIFF8 cell coment
Posted: Thu Nov 10, 2016 7:49 am
by larsa
Hello
Please send me an XLS file with this problem.
Re: BIFF8 cell coment
Posted: Wed Jan 11, 2017 3:37 pm
by icegood
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.
Re: BIFF8 cell coment
Posted: Thu Jan 12, 2017 7:28 am
by larsa
Hello
The file works fine here. Please test with the latest update.
Re: BIFF8 cell coment
Posted: Thu Jan 12, 2017 8:12 am
by icegood
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 of Suite i have?
Re: BIFF8 cell coment
Posted: Mon Jan 16, 2017 8:10 am
by larsa
Hello
Again, this works fine here. Which version of the component are you using? Check the ComponentVersion property.