Reading a True/False value from a Formula cell.

I work with VB.NET Here is my problem : My spreadsheet contains a checkbox object that feeds it''s true or false value to a cell. When I try to access it''s value from a different cell that links to it with a formula, I can''t get the result for both the FormulaNumberValue and FormulaStringValue don''t return any value that I can work with. Exemple : My checkbox objet feeds a True of False value to the sheet Wallet(E,24). My formula is in another sheet Transfert(B,13) and the formula is : Wallet!E24 Result when using FormulaNumberValue : -1.#QNAN Result when using FormulaStringValue : Nothing Is there something I am not thinking of that could help me solve my problem ? Thanks in advance.

2 Replies

AD Administrator Syncfusion Team May 18, 2006 04:31 PM UTC

Hi Benoît, Sorry for the delay in getting back to you. I was able to see the problem and have filed a bug report with the development team. You can track the status of this issue here http://www.syncfusion.com/support/issues/xlsio/Default.aspx?ToDo=view&questId=2095 Please let me know if you have any questions. Thanks, Stephen. >I work with VB.NET > >Here is my problem : > >My spreadsheet contains a checkbox object that feeds it''s true or false value to a cell. When I try to access it''s value from a different cell that links to it with a formula, I can''t get the result for both the FormulaNumberValue and FormulaStringValue don''t return any value that I can work with. > >Exemple : > >My checkbox objet feeds a True of False value to the sheet Wallet(E,24). My formula is in another sheet Transfert(B,13) and the formula is : Wallet!E24 > >Result when using FormulaNumberValue : -1.#QNAN >Result when using FormulaStringValue : Nothing > >Is there something I am not thinking of that could help me solve my problem ? > >Thanks in advance.


BV Benoît Verreault May 19, 2006 01:15 PM UTC

Thank you Stephen. For now I use a regular expression to extract the Worksheet and the Cell from the formula and use a second IWorksheet item to fetch the value from it''s source and it doesn''t seem to be slowing much the process, but I will definatly keep a close eye on the tracking of the issue. Have a good day.

Loader.
Up arrow icon