Click here to Skip to main content
15,887,267 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 2:07
MsmVc30-Sep-09 2:07 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Richard MacCutchan30-Sep-09 3:34
mveRichard MacCutchan30-Sep-09 3:34 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 18:43
MsmVc30-Sep-09 18:43 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier30-Sep-09 19:10
Franck Paquier30-Sep-09 19:10 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 19:33
MsmVc30-Sep-09 19:33 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier30-Sep-09 20:00
Franck Paquier30-Sep-09 20:00 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 20:08
MsmVc30-Sep-09 20:08 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier30-Sep-09 20:37
Franck Paquier30-Sep-09 20:37 
Hi
I think like you do yourself when you watch an excel spread sheet.

Either you retrieve the Text dispalyed by the cell and you recognize that it is a time.

or you right click on the cell and look at the format of the cell.
and you see something like dd:mm:ss

Right now in your code you just query the double value of the cell it is not enough.
You have to explore your cell deeper in order to be able to make a decision.

To do that you can:
Getting the STRING/TEXT displayed by the cell.
and or the FORMAT associated with the cell.


Regards.
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 20:42
MsmVc30-Sep-09 20:42 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier30-Sep-09 21:43
Franck Paquier30-Sep-09 21:43 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier30-Sep-09 21:45
Franck Paquier30-Sep-09 21:45 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 23:03
MsmVc30-Sep-09 23:03 
Questionhtml help and ms front-page Pin
includeh1029-Sep-09 19:24
includeh1029-Sep-09 19:24 
AnswerRe: html help and ms front-page Pin
Hans Dietrich29-Sep-09 20:19
mentorHans Dietrich29-Sep-09 20:19 
QuestionWhere is regedit.exe located in Pocket PC? Pin
Le@rner29-Sep-09 19:03
Le@rner29-Sep-09 19:03 
AnswerRe: Where is regedit.exe located in Pocket PC? Pin
Game-point29-Sep-09 19:14
Game-point29-Sep-09 19:14 
QuestionDirectX - Direct Show programming? Pin
$uresh $hanmugam29-Sep-09 18:35
$uresh $hanmugam29-Sep-09 18:35 
QuestionHow to disable non-visible dialog items Pin
FloatingMarc29-Sep-09 16:19
FloatingMarc29-Sep-09 16:19 
AnswerRe: How to disable non-visible dialog items Pin
includeh1029-Sep-09 19:30
includeh1029-Sep-09 19:30 
GeneralRe: How to disable non-visible dialog items Pin
FloatingMarc29-Sep-09 21:56
FloatingMarc29-Sep-09 21:56 
QuestionRun Time error Pin
monkeywrench1029-Sep-09 16:14
monkeywrench1029-Sep-09 16:14 
AnswerRe: Run Time error Pin
Cedric Moonen29-Sep-09 20:25
Cedric Moonen29-Sep-09 20:25 
GeneralRe: Run Time error Pin
monkeywrench1030-Sep-09 3:31
monkeywrench1030-Sep-09 3:31 
QuestionUsing an API Pin
Donguy197629-Sep-09 15:34
Donguy197629-Sep-09 15:34 
AnswerRe: Using an API Pin
Saurabh.Garg29-Sep-09 16:13
Saurabh.Garg29-Sep-09 16:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.