Search found 5 matches

by BigMax
Tue Dec 03, 2013 3:00 am
Forum: XLSReadWritwII 6
Topic: Cannot read XL2007 files and error E4006
Replies: 9
Views: 4523

Re: Cannot read XL2007 files and error E4006

Understood :( I blocked reading the names in the source of components. Another problem with Delphi7: when reading data from an empty cell and convert to a string is not correct processed value varNull, example: mValue:=XLS.Sheets[0].AsVariant[0,1000]; mStr:=VarToStr(mValue); if mValue=varNull, funct...
by BigMax
Thu Nov 28, 2013 5:54 am
Forum: XLSReadWritwII 6
Topic: Cannot read XL2007 files and error E4006
Replies: 9
Views: 4523

Re: Cannot read XL2007 files and error E4006

larsa wrote: This is fixed in update 5.20.09
still the same error :(
Error occurs during parsing formulas in the names.
by BigMax
Wed Nov 27, 2013 2:22 am
Forum: XLSReadWritwII 6
Topic: Cannot read XL2007 files and error E4006
Replies: 9
Views: 4523

Re: Cannot read XL2007 files and error E4006

Hello! Thanks for Name Manager Error out because using russian letters in sheets names (column 'Refers To' in Name Manager). After replacing names of sheets on english letters - error disappeared. In formulas on the sheets I checked - no errors because of using russian letters. Please, correct this ...
by BigMax
Tue Nov 26, 2013 2:07 am
Forum: XLSReadWritwII 6
Topic: Cannot read XL2007 files and error E4006
Replies: 9
Views: 4523

Re: Cannot read XL2007 files and error E4006

Code: Select all

ListSeparator=';'
DecimalSeparator=','
Version Delphi - 7.0

About the names of the formulas I not understand - on sheets of formulas nowhere. Where they are in the file?
by BigMax
Mon Nov 25, 2013 9:46 am
Forum: XLSReadWritwII 6
Topic: Cannot read XL2007 files and error E4006
Replies: 9
Views: 4523

Cannot read XL2007 files and error E4006

Hello!
Promlem - Error opening file:
"E4006: Error in formula".
But in the file are not formulas.

Version: 5.20.08

file:
https://drive.google.com/file/d/0B_KCuP ... sp=sharing