|
Hi all.
I am using a class found here http://www.codeproject.com/database/cspreadsheet.asp to create an excel spreadsheet ( i believe it uses ODBC )
It works great except I cannot, from my code, get the cells to autofit. That is, when you load up the file in Excel, a lot of the contents of the cells get cut off, because the cell is not big enough. I need to be able to tell it to autofit (automatically through code) or be able to specify the width of each column of cells. If I bring up the file in excel, and select all of the cells, then click on Column->Autofit, it makes it look right instantly ... However, I am planning on rolling out a program that generates reports and I don't want to have to tell the users that they have to do this every time they open a report.
Any help in the right direction would be appreciated!
-Shultas
|
|
|
|
|
Hi
ODBC, ADO or OLEDB will only allow you to manipulate data in and out Excel files, to go beyond that, you should use Automation, then you will be able to do, programmatically, anything you have to do.
You can take a look here to start, SAMPLE: XLCLIENT: Automation Client for Excel, also search the MSDN for more info.
Fabian
|
|
|
|
|
Hi
I am now on stage to integrate the HTMLHelp build with HTML Workshop >> Help.chm
In my project i had included the htmlhelp.h file and also the library htmlhelp.lib (both taken from HTML Help Workshop folder).
Now what to do?
Where to call the initialise or state that this is the html help file which has to be linked with teh project?
WHere to use following API i.eHTMLHelp?
HtmlHelp();
Urgent, Please help me in this respect?
Sandeep
Leave your mark wherever you go
|
|
|
|
|
Help topics are usually linked to different elements (dialogs, views) of your app. Here's what I do (which is slightly different from MS' process):
For every dialog (eg: CMyDialog), define a unique constant (eg: Help_MyDialog). Keep these constants in the file MyAppHelp.h. Include this file as a map in your HtmlHelp project. Ids in the file will map to your .chm's topic ids.
Add a "Help" button to your dialog. It's handler should execute this:
HWND hWndHelp = HtmlHelp (NULL, strHelpFile, HH_HELP_CONTEXT, Help_MyDialog); where strHelpFile is the full path to your app's .chm file.
Add a handler for the WM_HELPINFO message. This message is sent whent the user clicks the F1 key. In its handler, just call your Help button handler.
/ravi
My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com
|
|
|
|
|
in MainFrm.cpp
==============
BOOL CMainFrame::PreCreateWindow(CREATESTRUCT& cs)
{
if( !CFrameWnd::PreCreateWindow(cs) )
return FALSE;
cs.style = WS_OVERLAPPED | WS_CAPTION
| WS_BORDER | WS_SYSMENU
| WS_MINIMIZEBOX | WS_MAXIMIZEBOX | WS_THICKFRAME ;
cs.cy = 600;
cs.cx = 1000;
return TRUE;
}
void CMainFrame::OnGetMinMaxInfo(MINMAXINFO FAR* lpMMI)
{
POINT m_ptMinTrackSize;
m_ptMinTrackSize.x = 500;
m_ptMinTrackSize.y = 300;
lpMMI->ptMinTrackSize = m_ptMinTrackSize;
CFrameWnd::OnGetMinMaxInfo(lpMMI);
}
in ProgView.cpp
===============
pWnd = GetTopWindow();
for(pWnd = GetTopWindow(); pWnd;) {
pWnd->GetWindowRect(&Rect);
ScreenToClient(&Rect);
id = pWnd->GetDlgCtrlID( );
if ((id == IDC_1) || (id == IDC_2);
Rect.OffsetRect(dx,0);
Rect.right = Rect.right + dx / 2;
Rect.bottom= Rect.bottom + dy;
}
if ((id == IDC_3) || (id == IDC_4);
Rect.OffsetRect(0,dy);
}
//...
pWnd->MoveWindow(&Rect);
pWnd = pWnd->GetNextWindow();
}
in Prog.rc
==========
IDD_PROG_FORM DIALOG DISCARDABLE 0, 0, 600, 300
STYLE WS_CHILD | WS_THICKFRAME
FONT 8, "MS Sans Serif"
BEGIN
CONTROL "List1",IDC_1,...
CONTROL "List1",IDC_2,...
CONTROL "",IDC_3,...
CTEXT "",IDC_4,...
END
I do not arrive has resources control on the window IDD_PROG_FORM:
A resize with mouse do not change the dimension of IDD_PROG_FORM and I have so " scroll bar " appear
When I reduce too much the main window.
Need of help thank you
|
|
|
|
|
I just wonder how ::Ellipse and ::ArcTo were implemented(or CDC::Ellipse, CDC::ArcTo in MFC library), I really wish I could have a chance to see the source code of those functions, or less than that, an idea how it was possible to draw an ellipse(not a circle) on the screen, by being given a mere boundary rectangle.
I guess there got to be a lot of plane geometry involved, hell, wouldn't it be terribly time consuming to calculate coordinates of every single point on the arc?
|
|
|
|
|
|
Hi,
For most of the devices, the GDI will just delegate the drawing to the device itself because the drawing has been optimized by the manufacturer of that piece of hardware. Check the API GetDeviceCaps, it tells you if the hardware device is capable to draw the primitive, in this case, of an ellipse.
Fabian
|
|
|
|
|
I’m trying to cal the function CreateProcessWithLogonW() who has the parameter LPCWSTR lpDomain to give the domain name. I got the current domain name in a CString variable. My problem is to convert the CString domain name to the LPCWSTR domain name to cal the function.
I have tried to use the TEXT() macro and #define UNICODE to convert the CString to an unicode string, but I cant get it to work. Is there any one that can help me with this?
|
|
|
|
|
|
Hello all
I'm new to doc/view architechture. I want to create a simple text editor which have to enable me to enter text, open files, edit,cut and copy. I'm using MFC AppWizard and accepting the defaults. It's creating a basic skeleton and when I ran it it show's up a simple editor, but when I open a file it's not showing the contents. Similarly its not allowing me to enter anything.
When creating the application if I change the base class of myview to CEditView then I'm able to do all the above operations. But I want to implement all the functionality just by deriving from CView.
Can anyone help me in this regard? Any example code or article which explains how to do will be of great help.
Thank you very much for your help.
Hari.
|
|
|
|
|
To create just a text editor using CView will require alot of (unnecessary) work! If that's actually all you you want to do then use CEditView (as you suggested) or CRichEditView when creating the application in the wizard. If your problem is actually that you wish to display graphics as well, then the CRichEditView will take care of that too.
Otherwise, take a look at some of the examples here on Code Project: there are many that show you how to over ride "OnPaint", which is what you're going to have to do if you wish to manually code to at least display text in a CView.
Another method (not necessarily the best: you need to be more specific as to your problem) is to write text / draw to a bit map and then simply display that in the CView. Search for "double buffering", "bitmap" or "graphics" in Code Project. "Code Guru" is another good site to try. 
|
|
|
|
|
Hello Clevedon_Peanut
Thanks you very much for the reply. I'll try for samples in codeproject and codeguru.
Thanks
Hari.
|
|
|
|
|
How to set a web proxy in a CHtmlView based SDI program? What's more, i do not want to change the IE's proxy settings.
Another question is I overloaded the OnDownloadComplete function, but if the destination page contains more than one forms, the function works as many times as the count of forms. How could i make the function work only when everything on the web page has been downloaded?
H... I... & i
|
|
|
|
|
Hi all,
I am developing a container application using MFC. The AppWizard generted code is working fine, almost for all OLE objects. But in my case the the scenario is that i have some BYTES in hand, so using those bytes i am suppose to load that object in container. I used the API's CreateILockBytesOnHGlobal() and StgOpenStorageOnILockBytes() to prepare the IStorage object. It is preparing the IStorage object, but problem is that after CoCreateInstance() i want to launch local server using OleRun() and this is not launching the local server.
(AppWizard generated code does the same thing, i want to do it manualy)
Any body please tell me why is that local server is not launching
Thank in advance
Vishal More
|
|
|
|
|
I want to use CSocket. but when i called Create() function, it always return 0, i gave the following code fragment here.
what is the wrong? did i do any mistake? Help is needed. if you can provide me sample code i will be happy.
CSocket serverSocket, clientConnection;
if(!serverSocket.Create(4001)){
m_StaticText.SetWindowText("Server Create error...");
return;
}
if(!serverSocket.Listen()){
m_StaticText.SetWindowText("Server Listen error...");
return;
}
if(!serverSocket.Accept(clientConnection)){
m_StaticText.SetWindowText("Server Accept error...");
return;
}
|
|
|
|
|
use AfxSocketInit() to intilize the socket before use socket's function. and there are some samples in the MFC, such as chatter, it would be good to you.
best regard.
laia
|
|
|
|
|
how can i check to see if
<br />
CString mydate="12/05/2004";<br />
is a Tuesday ?
cheers,
|
|
|
|
|
COleDateTime::ParseDateTime() and COleDateTime::GetDayOfWeek()
Sonork 100.11743 Chicken Little
"You're obviously a superstar." - Christian Graus about me - 12 Feb '03
Within you lies the power for good - Use it!
|
|
|
|
|
Can anyone tell me how to add events handlers to the ScrollBar control.
It doesn't seem to generate any useable messages like Button's BN_CLICKED and Edit's EN_CHANGE. All it has is NM_THEMECHANGED.
Do i have to derive a control from the CScrollBar class and ad my own or something?
Darryl
|
|
|
|
|
Scrollbars generate WM_HSCROLL or WM_VSCROLL messages depending on thier orientation. Look up those messages in MSDN for more info.If you are using MFC check out CWnd::OnHScoll and CWnd::OnVScroll.
Sonork 100.11743 Chicken Little
"You're obviously a superstar." - Christian Graus about me - 12 Feb '03
Within you lies the power for good - Use it!
|
|
|
|
|
Big thanx man  , you've crack it for me. It was a real bugbare in my conceptuality. I wrote the app today relativly painlessly and so far it works fine.
Now i guess it's a honeymoon/getting to know MFC kind of thing for me now 
Thanx again
Darryl
|
|
|
|
|
Hi.
Is there anyway I can open automatically a text document with a win32 app and diaply it in window on top?
For example you give a path name like "c:\file.txt" and it opens this file in a window. I knwo
I could create my own window and write to it but is there any shortcut for this?
I am not even sure how to do the later way too. Can you give some indications please. thank you.
|
|
|
|
|
::ShellExecute(NULL, "open", "C:\\File.text", NULL, NULL, SW_SHOWNORMAL);
Roger Allen - Sonork 100.10016
Strong Sad: I am sad I am flying
Who is your favorite Strong?
|
|
|
|
|
I made something like a HTTP server with WinSock. I managed to send html files but I have problem with sending images. There are some 0's so strings get "ended", you know...I think it could be done by sending "binary", but I don't know how to do it... 
Can you give me some theory or even some code? thanx
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
