Hi Sarath
I've checked an attached file I've sent to you and there are 4 CommandButtons on sheet1 (C42,N42,C66,G66)- to see CommandButtons you have to open file in Excel not in GridControl. This is one of 5000 documents I want to move to my EssentialStudio. The problem is how to do this automatically. So the answer isn't so simple.
1. As you can see some of cells has wrong formatting:
a) borders R8C4, R17C4, R18C4, R19C4 etc.
b) fonts on sheet2 R41C2,R42C2,R43C2
c) background R4C9,R5C9,R6C9, R17C4, R18C4, R19C4 etc.
How can I to solve it (I use ExcelLikeUI sample).
2. More complex problem is to move VBA macros with dynamic interface - CommandButtons. Is there any possibility to find out that a cell has CommandButton inside during reading excel file to GridControl?
Understand me Sarath. With such amount of bugs Xlsio is useless for me. So you must spent more time on competent solving problems from point 1.
I don't expect simple solution on point 2, because it is over functionality you deliver. I think about translating vba macros to c# and recompiling them. The main point is where is an information about CommandButton in cell and how to read it using e.g. GridExcelConverterControl?
Most important for me is to solve problems from point1. EssentialStudio (v.5.1) is great but Xlsio needs some corrections or I do something wrong.
About p.2 I send you another sample.
Regards
Roman
test104.zip