I am trying to find some code samples on Tidestone's Formula one ActiveX control esp. working with databases..If anyone has some information or have knowledge, please respond with information details...Pleeeaazzzzzeeee!!!
Thanks Much
Srinath
Reply to [email protected]
Hi, I want to put a picture to a Formula One ActiveX control (TideStone Company). Could anyone tell me exactly (with a code sample, if possible) how to do this...
Does O/S window XP support Formula one ActiveX control? What version?
Would anyone know?
leave DDX_Control line will be OK.
why
I have two ActiveX controls that I want to be one ActiveX control. One of the controls is an data collector and the other control is a data viewer, the two of them together willl collect and display data.
How could I create a new ActiveX control that will combine the two? It needs to expose all the properties and methods that are exposed on the original two.
I am now using the tidestone formula one activeX control in VC.
I use the ObjCreate function to create a dropdown list box
object in the specified cell of the F1.Now I use the InsertItem function to add some items to the listbox.I can get the item count
correctly.But when I clik the dropdown list,nothing appers in the dropdown list.I am wondering why?Could you help me to figure it
out?
Thanks a lot.
Hello Everyone,
I have created one ActiveX controls with ATL ( the control inherits from FullControl), I can put it on the ActiveX container tool that Visual C++ ships, but If I try to copy from there and paste to Word ( for example), then it doesn´t show anything, can anyone tell me why this happens ?
Thanks a lot, Bye
Braulio
/* ---------------
Braulio Díez
Software Programmer
------------------- */
I have developed one activeX control for displaying tiff images in VC6.
Its working fine in IE, but not displaying in Mozilla Firefox and Nescape.
Can you plz give some suggessions how to get rid of this problem
I have one ActiveX Control which is used to calculate Idle time of a given user. My Ctrl internally using KeyBoard Hook and Mouse Hook. I have to download the ActiveX through a web browser. After the Actx ctrl download(along with web page), when i am refreshing the web page by pressing F5 or any another means it is displaying the webpage for 2 times only. From 3rd time onwards web browser is not displaying the web page. It is not displaying any web page(Gmail,Rediffmail etc...) also. Other web pages can be displayed in seperate web browser. In the same web browser in which i have downloaded the Actx Control is not displaying any page.
My Actx Ctrl is safe component.
Can any body solve my problem? (Very urgent)
Thanks in Advance.
hai friends .
i kept one activex control (label) to my dialog box, i want to change the property of the control eg.,(to change the for colour) via coding not in porperty window. and without creating the member variable of the control. and i created a class for to that control it inherited all the property of the control. class name is "CLabel"
i can set the porperty of the control by below coding with member variable- it is working
m_first_control.put_forcolour(255);
but i not able to set the property with ID
((CLabel*) GetDlgItem(first_control))->put_forcolour(255);
while trying this iam getting error "control not declare as ocx"
i want to set the property only with ID. can any one help me
I have a function that gets called when a pushbutton is clicked in a program. The pushbutton is next to a Formula One ActiveX table/grid. If multiple cells are selected by a user, things go wrong when the pushbutton is pressed. If anyone knows about these controls, is there one that determines/checks if a group or range of cells is selected like IsMultipleCellsSelected() or something (I'm obviously new at coding)
I have a list of most of the formula one controls/functions used, but I can't seem to find one that is applicable
// Operations
public:
double GetNumberRC(long nRow, long nCol);
void SetNumberRC(long nRow, long nCol, double newValue);
CString GetColText(long nCol);
void SetColText(long nCol, LPCTSTR lpszNewValue);
CString GetDefinedName(LPCTSTR Name);
void SetDefinedName(LPCTSTR Name, LPCTSTR lpszNewValue);
CString GetEntryRC(long nRow, long nCol);
void SetEntryRC(long nRow, long nCol, LPCTSTR lpszNewValue);
CString GetFormattedTextRC(long nRow, long nCol);
CString GetFormulaRC(long nRow, long nCol);
void SetFormulaRC(long nRow, long nCol, LPCTSTR lpszNewValue);
long GetLastColForRow(long nRow);
BOOL GetLogicalRC(long nRow, long nCol);
void SetLogicalRC(long nRow, long nCol, BOOL bNewValue);
CString GetRowText(long nRow);
void SetRowText(long nRow, LPCTSTR lpszNewValue);
CString GetTextRC(long nRow, long nCol);
void SetTextRC(long nRow, long nCol, LPCTSTR lpszNewValue);
short GetTypeRC(long nRow, long nCol);
long GetObjCellType(long ObjID);
void SetObjCellType(long ObjID, long nNewValue);
long GetObjCellRow(long ObjID);
void SetObjCellRow(long ObjID, long nNewValue);
long GetObjCellCol(long ObjID);
void SetObjCellCol(long ObjID, long nNewValue);
long GetObjSelection(short nSelection);
void EditPasteValues();
void GetAlignment(short* pHorizontal, BOOL* pWordWrap, short* pVertical, short* pOrientation);
void GetBorder(short* pLeft, short* pRight, short* pTop, short* pBottom, short* pShade, long* pcrLeft, long* pcrRight, long* pcrTop, long* pcrBottom);
void GetFont(BSTR* pName, short* pSize, BOOL* pBold, BOOL* pItalic, BOOL* pUnderline, BOOL* pStrikeout, long* pcrColor, BOOL* pOutline, BOOL* pShadow);
void GetLineStyle(short* pStyle, long* pcrColor, short* pWeight);
void GetPattern(short* pPattern, long* pcrFG, long* pcrBG);
void GetProtection(BOOL* pLocked, BOOL* pHidden);
void GetTabbedText(long nR1, long nC1, long nR2, long nC2, BOOL bValuesOnly, long* phText);
void SetTabbedText(long nStartRow, long nStartCol, long* pRows, long* pCols, BOOL bValuesOnly, LPCTSTR pText);
void AddColPageBreak(long nCol);
void AddPageBreak();
void AddRowPageBreak(long nRow);
void AddSelection(long nRow1, long nCol1, long nRow2, long nCol2);
void Attach(LPCTSTR Title);
void AttachToSS(long hSrcSS);
void CheckRecalc();
void ClearClipboard();
void ClearRange(long nRow1, long nCol1, long nRow2, long nCol2, long ClearType);
void CopyAll(long hSrcSS);
void CopyRange(long nDstR1, long nDstC1, long nDstR2, long nDstC2, long hSrcSS, long nSrcR1, long nSrcC1, long nSrcR2, long nSrcC2);
void DeleteDefinedName(LPCTSTR pName);
void DeleteRange(long nRow1, long nCol1, long nRow2, long nCol2, long ShiftType);
void Draw(long hDC, long x, long y, long cx, long cy, long nRow, long nCol, long* pRows, long* pCols, long nFixedRow, long nFixedCol, long nFixedRows, long nFixedCols);
void EditClear(long ClearType);
void EditCopy();
void EditCopyDown();
void EditCopyRight();
void EditCut();
void EditDelete(long ShiftType);
void EditInsert(long InsertType);
void EditPaste();
void FormatCurrency0();
void FormatCurrency2();
void FormatFixed();
void FormatFixed2();
void FormatFraction();
void FormatGeneral();
void FormatHmmampm();
void FormatMdyy();
void FormatPercent();
void FormatScientific();
void GetActiveCell(long* pRow, long* pCol);
short GetColWidth(long nCol);
// method 'SetColWidth' not emitted because of invalid return type or parameter type
short GetRowHeight(long nRow);
// method 'SetRowHeight' not emitted because of invalid return type or parameter type
void GetDefaultFont(BSTR* pBuf, short* pSize);
void GetHdrSelection(BOOL* pTopLeftHdr, BOOL* pRowHdr, BOOL* pColHdr);
void GetIteration(BOOL* pIteration, short* pMaxIterations, double* pMaxChange);
void GetPrintScale(short* pScale, BOOL* pFitToPage, long* pVPages, long* pHPages);
void GetSelection(short nSelection, long* pR1, long* pC1, long* pR2, long* pC2);
void HeapMin();
void InitTable();
void InsertRange(long nRow1, long nCol1, long nRow2, long nCol2, long InsertType);
void MoveRange(long nRow1, long nCol1, long nRow2, long nCol2, long nRowOffset, long nColOffset);
void ObjAddItem(long ObjID, LPCTSTR ItemText);
void ObjAddSelection(long ObjID);
void ObjBringToFront();
void ObjDeleteItem(long ObjID, short nItem);
void ObjGetCell(long ObjID, short* pControlCellType, long* pRow, long* pCol);
void ObjGetPos(long ObjID, float* pX1, float* pY1, float* pX2, float* pY2);
void ObjGetSelection(short nSelection, long* pID);
void ObjInsertItem(long ObjID, short nItem, LPCTSTR ItemText);
void ObjNew(short ObjType, float nX1, float nY1, float nX2, float nY2, long* pID);
void ObjNewPicture(float nX1, float nY1, float nX2, float nY2, long* pID, long hMF, long nMapMode, long nWndExtentX, long nWndExtentY);
void ObjPosToTwips(float nX1, float nY1, float nX2, float nY2, long* pX, long* pY, long* pCX, long* pCY, short* pShown);
void ObjSendToBack();
void ObjSetCell(long ObjID, short CellType, long nRow, long nCol);
void ObjSetPicture(long ObjID, long hMF, short nMapMode, long nWndExtentX, long nWndExtentY);
void ObjSetPos(long ObjID, float nX1, float nY1, float nX2, float nY2);
void ObjSetSelection(long ObjID);
void OpenFileDlg(LPCTSTR pTitle, long hWndParent, BSTR* pBuf);
void RangeToTwips(long nRow1, long nCol1, long nRow2, long nCol2, long* pX, long* pY, long* pCX, long* pCY, short* pShown);
void Read(LPCTSTR pPathName, short* pFileType);
void ReadFromBlob(long hBlob, short nReservedBytes);
void Recalc();
void RemoveColPageBreak(long nCol);
void RemovePageBreak();
void RemoveRowPageBreak(long nRow);
void SaveWindowInfo();
void SetActiveCell(long nRow, long nCol);
void SetAlignment(short HAlign, BOOL bWordWrap, short VAlign, short nOrientation);
void SetBorder(short nOutline, short nLeft, short nRight, short nTop, short nBottom, short nShade, unsigned long crOutline, unsigned long crLeft, unsigned long crRight, unsigned long crTop, unsigned long crBottom);
void SetColWidth(long nCol1, long nCol2, short nWidth, BOOL bDefColWidth);
void SetColWidthAuto(long nRow1, long nCol1, long nRow2, long nCol2, BOOL bSetDefaults);
void SetDefaultFont(LPCTSTR Name, short nSize);
void SetFont(LPCTSTR pName, short nSize, BOOL bBold, BOOL bItalic, BOOL bUnderline, BOOL bStrikeout, unsigned long crColor, BOOL bOutline, BOOL bShadow);
void SetHdrSelection(BOOL bTopLeftHdr, BOOL bRowHdr, BOOL bColHdr);
void SetIteration(BOOL bIteration, short nMaxIterations, double nMaxChange);
void SetLineStyle(short nStyle, unsigned long crColor, short nWeight);
void SetPattern(short nPattern, unsigned long crFG, unsigned long crBG);
void SetPrintAreaFromSelection();
void SetPrintScale(short nScale, BOOL bFitToPage, short nVPages, short nHPages);
void SetPrintTitlesFromSelection();
void SetProtection(BOOL bLocked, BOOL bHidden);
void SetRowHeight(long nRow1, long nRow2, short nHeight, BOOL bDefRowHeight);
void SetRowHeightAuto(long nRow1, long nCol1, long nRow2, long nCol2, BOOL bSetDefaults);
void SetSelection(long nRow1, long nCol1, long nRow2, long nCol2);
void ShowActiveCell();
void Sort3(long nRow1, long nCol1, long nRow2, long nCol2, BOOL bSortByRows, long nKey1, long nKey2, long nKey3);
void SwapTables(long hSS2);
void TransactCommit();
void TransactRollback();
void TransactStart();
void TwipsToRC(long x, long y, long* pRow, long* pCol);
void SSUpdate();
short SSVersion();
void Write(LPCTSTR PathName, short FileType);
void WriteToBlob(long* phBlob, short nReservedBytes);
void SetRowHidden(long nRow1, long nRow2, BOOL bHidden);
void SetColHidden(long nCol1, long nCol2, BOOL bHidden);
void SetColWidthTwips(long nCol1, long nCol2, short nWidth, BOOL bDefColWidth);
CString GetDefinedNameByIndex(short nName);
CString GetSheetName(short nSheet);
void SetSheetName(short nSheet, LPCTSTR lpszNewValue);
unsigned long GetPaletteEntry(long nEntry);
void SetPaletteEntry(long nEntry, unsigned long newValue);
void EditInsertSheets();
void EditDeleteSheets();
void InsertSheets(long nSheet, long nSheets);
void DeleteSheets(long nSheet, long nSheets);
short GetColWidthTwips(long nCol);
void SetColWidthTwips(long nCol, short nNewValue);
long NextColPageBreak(long Col);
long NextRowPageBreak(long Row);
long ObjFirstID();
long ObjNextID(long ObjID);
short ObjGetItemCount(long ObjID);
long ObjGetType(long ObjID);
short ObjGetSelectionCount();
CString FormatRCNr(long Row, long Col, BOOL DoAbsolute);
long SS();
CString GetObjItem(long ObjID, short nItem);
void SetObjItem(long ObjID, short nItem, LPCTSTR lpszNewValue);
CString GetObjItems(long ObjID);
void SetObjItems(long ObjID, LPCTSTR lpszNewValue);
CString GetObjName(long ObjID);
void SetObjName(long ObjID, LPCTSTR lpszNewValue);
CString GetObjText(long ObjID);
void SetObjText(long ObjID, LPCTSTR lpszNewValue);
short GetObjValue(long ObjID);
void SetObjValue(long ObjID, short nNewValue);
BOOL GetObjVisible(long ObjID);
void SetObjVisible(long ObjID, BOOL bNewValue);
long ObjNameToID(LPCTSTR Name);
long DefinedNameCount();
CString GetAutoFillItems(short nIndex);
void SetAutoFillItems(short nIndex, LPCTSTR lpszNewValue);
void SetValidationRule(LPCTSTR Rule, LPCTSTR Text);
void GetValidationRule(BSTR* Rule, BSTR* Text);
short AutoFillItemsCount();
void CopyRangeEx(long nDstSheet, long nDstR1, long nDstC1, long nDstR2, long nDstC2, long hSrcSS, long nSrcSheet, long nSrcR1, long nSrcC1, long nSrcR2, long nSrcC2);
void Sort(long nR1, long nC1, long nR2, long nC2, BOOL bSortByRows, const VARIANT& Keys);
BOOL GetColHidden(long nCol);
void SetColHidden(long nCol, BOOL bNewValue);
BOOL GetRowHidden(long nRow);
void SetRowHidden(long nRow, BOOL bNewValue);
void DeleteAutoFillItems(short nIndex);
void ODBCConnect(BSTR* pConnect, BOOL bShowErrors, short* pRetCode);
void ODBCDisconnect();
void ODBCQuery(BSTR* pQuery, long nRow, long nCol, BOOL bForceShowDlg, BOOL* pSetColNames, BOOL* pSetColFormats, BOOL* pSetColWidths, BOOL* pSetMaxRC, short* pRetCode);
BOOL GetSheetSelected(long nSheet);
void SetSheetSelected(long nSheet, BOOL bNewValue);
void PrintPreviewDC(long hDC, short nPage, short* pPages);
void PrintPreview(long hWnd, long x, long y, long cx, long cy, short nPage, short* pPages);
CString GetEntrySRC(long nSheet, long nRow, long nCol);
void SetEntrySRC(long nSheet, long nRow, long nCol, LPCTSTR lpszNewValue);
CString GetFormattedTextSRC(long nSheet, long nRow, long nCol);
CString GetFormulaSRC(long nSheet, long nRow, long nCol);
void SetFormulaSRC(long nSheet, long nRow, long nCol, LPCTSTR lpszNewValue);
BOOL GetLogicalSRC(long nSheet, long nRow, long nCol);
void SetLogicalSRC(long nSheet, long nRow, long nCol, BOOL bNewValue);
double GetNumberSRC(long nSheet, long nRow, long nCol);
void SetNumberSRC(long nSheet, long nRow, long nCol, double newValue);
CString GetTextSRC(long nSheet, long nRow, long nCol);
void SetTextSRC(long nSheet, long nRow, long nCol, LPCTSTR lpszNewValue);
short GetTypeSRC(long nSheet, long nRow, long nCol);
void WriteRange(long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, LPCTSTR pPathName, short FileType);
void InsertHTML(long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, LPCTSTR pPathName, BOOL bDataOnly, LPCTSTR pAnchorName);
CString GetFormulaLocalRC(long nRow, long nCol);
void SetFormulaLocalRC(long nRow, long nCol, LPCTSTR lpszNewValue);
CString GetFormulaLocalSRC(long nSheet, long nRow, long nCol);
void SetFormulaLocalSRC(long nSheet, long nRow, long nCol, LPCTSTR lpszNewValue);
CString GetDefinedNameLocal(LPCTSTR Name);
void SetDefinedNameLocal(LPCTSTR Name, LPCTSTR lpszNewValue);
void CopyDataFromArray(long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, BOOL bValuesOnly, const VARIANT& Array);
void CopyDataToArray(long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, BOOL bValuesOnly, const VARIANT& Array);
void ODBCError(BSTR* pSQLState, long* pNativeError, BSTR* pErrorMsg);
void ODBCPrepare(LPCTSTR SQLStr, short* pRetCode);
void ODBCBindParameter(long nParam, long nCol, short CDataType, short* pRetCode);
void ODBCExecute(long nRow1, long nRow2, short* pRetCode);
void ObjNewPolygon(float X1, float Y1, float X2, float Y2, long* pID, const VARIANT& ArrayX, const VARIANT& ArrayY, BOOL bClosed);
void ObjSetPolygonPoints(long nID, const VARIANT& ArrayX, const VARIANT& ArrayY, BOOL bClosed);
CString GetTabbedTextEx(long nR1, long nC1, long nR2, long nC2, BOOL bValuesOnly);
CF1RangeRef SetTabbedTextEx(long nStartRow, long nStartCol, BOOL bValuesOnly, LPCTSTR pText);
long ObjCreate(long ObjType, float nX1, float nY1, float nX2, float nY2);
long ObjCreatePicture(float nX1, float nY1, float nX2, float nY2, long hMF, long nMapMode, long nWndExtentX, long nWndExtentY);
long ReadEx(LPCTSTR pPathName);
long WriteToBlobEx(short nReservedBytes);
long ObjCreatePolygon(float X1, float Y1, float X2, float Y2, const VARIANT& ArrayX, const VARIANT& ArrayY, BOOL bClosed);
CF1ObjPos ObjGetPosEx(long ObjID);
short ObjPosShown(float X1, float Y1, float X2, float Y2);
CF1RangeRef GetSelectionEx(short nSelection);
CF1Rect ObjPosToTwipsEx(float X1, float Y1, float X2, float Y2);
CF1Rect RangeToTwipsEx(long nRow1, long nCol1, long nRow2, long nCol2);
short RangeShown(long nR1, long nC1, long nR2, long nC2);
long TwipsToRow(long nTwips);
long TwipsToCol(long nTwips);
short PrintPreviewDCEx(long hDC, short nPage);
short PrintPreviewEx(long hWnd, long x, long y, long cx, long cy, short nPage);
void ODBCConnectEx(LPDISPATCH pConnectObj, BOOL bShowErrors);
void ODBCQueryEx(LPDISPATCH pQueryObj, long nRow, long nCol, BOOL bForceShowDlg);
short ODBCPrepareEx(LPCTSTR SQLStr);
short ODBCBindParameterEx(long nParam, long nCol, long CDataType);
short ODBCExecuteEx(long nRow1, long nRow2);
CString OpenFileDlgEx(LPCTSTR pTitle, long hWndParent);
CF1BookView CreateBookView();
void EditPasteSpecial(long PasteWhat, long PasteOp);
CF1NumberFormat GetFirstNumberFormat();
void GetNextNumberFormat(LPDISPATCH pNumberFormat);
CF1Rect RangeToPixelsEx(long nRow1, long nCol1, long nRow2, long nCol2);
void WriteEx(LPCTSTR PathName, long FileType);
void WriteRangeEx(long nSheet, long nRow1, long nCol1, long nRow2, long nCol2, LPCTSTR pPathName, long FileType);
void GetFontEx(BSTR* pName, long* pCharSet, short* pSize, BOOL* pBold, BOOL* pItalic, BOOL* pUnderline, BOOL* pStrikeout, long* pcrColor, BOOL* pOutline, BOOL* pShadow);
void SetFontEx(LPCTSTR pName, long CharSet, short nSize, BOOL bBold, BOOL bItalic, BOOL bUnderline, BOOL bStrikeout, unsigned long crColor, BOOL bOutline, BOOL bShadow);
void GetDefaultFontEx(BSTR* pBuf, long* pCharSet, short* pSize);
void SetDefaultFontEx(LPCTSTR Name, long CharSet, short nSize);
CF1CellFormat CreateNewCellFormat();
CF1CellFormat GetCellFormat();
void SetCellFormat(LPDISPATCH CellFormat);
CString ErrorNumberToText(long SSError);
};
I used one ActiveX control (graph control) in my dll.
Problem is that control was not displaying in that dll.
I test that graph control in a simple appication. It is working and displayed in that application.but it is not displaying in my dll.what is the problem.
Plz give me solution.
I have included one activex control by right clicking on dialog box and i have included the class files for that too.
But, when ever i try to call any method of that activex control, assertion failure occurs. This happens for all activex controls.
The assertion failure occurs at InvokeHelper method.That is exactly at
line -- ASSERT(m_pCtrlSite != NULL); of InvokeHelper method.
Anybody please help me to get rid of this..
Please tell me how can I embed standart Windows control (Cedit) in ActiveX control.
And do you know how can I embed one ActiveX control in another?
I use microsoft ADO data control and microsoft data grid control, these two activeX control must use together but i need to put them into one new ActiveX control
if anyone know how to compine two activex control into one activex control please tell me
i am developing one activeX control, but the prolem is whenever I am pressing the Tab button from keyboard, i am geting Dr. Watson error and my complete application closes after that. Also I tried to debug and I could found that when I am trying to raise the Validate event, Dr. Watson error occurs.
Does any one have any solution for this.
I was wondering if anybody had any experience with Formula 1 activeX control. I have a question to ask, but I want to know if anyone actually knows anything about this subject.
Joe Rossini
I have developed one application which uses one ActiveX control.That ActiveX control also I developed.Now I move my main execution file which is statically linked to another machine. When I run the execution file in that computer it gives message that "It is an unsupported operation".
Next I copied OCX file to the second computer and register the OCX file using regsvr32. It gives success message. But when I run the main EXE file it gives the same message.
Because my main Exe file depends on the OCX file , how I can able to run my exe file in the second machine which will use the OCX file.
Any help from gurus is highly appreciated.
I have some proplems when call function from
regular MFC dll :
- I have build a regular static MFC dll MyDll.dll containing class
CMyDialog::CDialog with one ActiveX control
- I enabled container by command
AfxEnableControlContainer();
in CMyDllApp::InitInstance() and Export a function
CreateDialog(){
CMyDialog dlg;
dlg.DoModal();
}
I build another MFC application using MyDll.dll by import fuction CreateDialog();
- I created a dialog with a button to call function CreateDialog();
- It does not work (it does not display anything)
but
- when I insert another ActiveX control into App dialog(beside button call DLL fucntion), it
works properly.
and
- When I delete ActiveX control from DLL dialog
it also work properly
Please tell my why it is!!!