BIFF8 cell coment

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
icegood
Posts: 8
Joined: Wed May 04, 2016 1:28 pm

BIFF8 cell coment

Post by icegood »

Seems, BIFF8 cell comment doesn't processed properly while rerading excel'97(BIFFRECID_NOTE = $001C to process). Comments are always empty.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: BIFF8 cell coment

Post by larsa »

Hello

Please send me an XLS file with this problem.
Lars Arvidsson, Axolot Data
icegood
Posts: 8
Joined: Wed May 04, 2016 1:28 pm

Re: BIFF8 cell coment

Post 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.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: BIFF8 cell coment

Post by larsa »

Hello

The file works fine here. Please test with the latest update.
Lars Arvidsson, Axolot Data
icegood
Posts: 8
Joined: Wed May 04, 2016 1:28 pm

Re: BIFF8 cell coment

Post 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?
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: BIFF8 cell coment

Post by larsa »

Hello

Again, this works fine here. Which version of the component are you using? Check the ComponentVersion property.
Lars Arvidsson, Axolot Data
Post Reply