|
Could you tell me (i mean a sample code), as an example, how to have my range of cells get the "centered" property  ? Because there is no SetStyle or something like that ... 
Thank you very much (if you do not have time, don't bother, it is not that important..) 
~RaGE();
|
|
|
|
|
The property to be set is HorizontalAlignment.
So if you have a pointer to your range, calling
range->SetHorizontalAlignment(COleVariant(xlHAlignCenter));
should work. Without use of MFC or similar, it could be more like
VARIANT var;
var.vt = ???;
var.??? = xlHAlignCenter;
range->set_HorizontalAlignment(var);
But I don't know of what type xlHAlignCenter is, so you should figure that out before setting the Variant parameter.
We are men. We are different. We have only one word for soap. We do not own candles. We have never seen anything of any value in a craft shop. We do not own magazines full of photographs of celebrities with their clothes on. - Steve
|
|
|
|
|
Schlaubi wrote:
range->SetHorizontalAlignment(COleVariant(xlHAlignCenter));
That's what I've tried from the beginning, but compiler does not know about xlHAlignCenter, so even the type cast would not fit. Anyway, i have found in Article ID: Q179706 in the MSDN, that the value for xlVAlignCenter (so the vertical alignement) is -4108, assumed this would be the same for horizontal alignement, tried ... and it worked !
So i'm done, even if i would really love to have a table giving indications like
xlHAlignCenter=-4108; 
Lots of thank for your help, i own you a ![Beer | [beer]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/beer.gif) ...
~RaGE();
|
|
|
|
|
Rage wrote:
So i'm done, even if i would really love to have a table giving indications like
No problem
f.i. for Excel:
Search the corresponding olb / tlb file, in my case it's excel9.olb, located in program files\microsoft office\office. Then open the file with oleview, delivered with MS VS. Now you have a perfect overview of all interfaces and enums. In your case, the enum xlhalign provides you all values you need. As for all other constants, too.
We are men. We are different. We have only one word for soap. We do not own candles. We have never seen anything of any value in a craft shop. We do not own magazines full of photographs of celebrities with their clothes on. - Steve
|
|
|
|
|
 That's simply great !!!
Vielen Dank  !
~RaGE();
|
|
|
|
|
No problem!
C'est toujours un grand plaisir de aider. (Sorry for that bad French, but my French lessons are already 5 years gone);
We are men. We are different. We have only one word for soap. We do not own candles. We have never seen anything of any value in a craft shop. We do not own magazines full of photographs of celebrities with their clothes on. - Steve
|
|
|
|
|
Hello,
I need to place all the tabs of a property sheet in the same line and make the user scroll over them, and after reading the MSDN I've written this:
int CPSParametritzacions::OnCreate(LPCREATESTRUCT lpCreateStruct)
{
this->EnableStackedTabs(FALSE);
if (CPSAutoRedimensionable::OnCreate(lpCreateStruct) == -1) return -1;
return 0;
}But it doesn't work...
I'm almost sure that I am missing something...
Thank you in advance.
|
|
|
|
|
what happens if you follow the MSDN example exactly. i.e.
int CMyPropertySheet::OnCreate(LPCREATESTRUCT lpCreateStruct)<br />
{<br />
EnableStackedTabs(FALSE);<br />
if (CPropertySheet::OnCreate(lpCreateStruct) == -1)<br />
return -1;<br />
return 0;<br />
}
If I have seen further it is by standing on the shoulders of Giants. - Isaac Newton 1676
|
|
|
|
|
int CPSParametritzacions::OnCreate(LPCREATESTRUCT lpCreateStruct)
{
this->EnableStackedTabs(FALSE);
if (CPSAutoRedimensionable::OnCreate(lpCreateStruct) == -1) return -1;
return 0;
}
int CMyPropertySheet::OnCreate(LPCREATESTRUCT lpCreateStruct)
{
EnableStackedTabs(FALSE);
if (CPropertySheet::OnCreate(lpCreateStruct) == -1)
return -1;
return 0;
}
the only differences I see are in bold font... and I don't believe they are significant...
The fact is that this must not be the reason... (it's obvious why), but the other one... My problem is that the CPSAutoRedimensionable class it's a class derived from the base class property sheet and that I don't know why I can't call directly CPropertySheet::OnCreate from my CPSParametritzacions class.
Thank you in advance, and thank you for your interest too.
|
|
|
|
|
Hi....
I am doing a Project in which I want to close a selected port which is opened by another application. How can I Solve the Same? Which function to be used??Please Help
Thanks in Advance.
SAN
|
|
|
|
|
Do you have the source code to the other application? If so it would be easy to do. If not, I'm not sure if this could even be done.
Rob
|
|
|
|
|
What I need to do is move my existing resources from the executable into separate resource DLLs, separated by language. Does anyone have links to any tutorials, guides, or other articles about resource DLLs in general?
Jon Sagara
I have no complaint with the “mentoring concept” or the marriage concept or the sex concept. But if you pay for any of those, something’s wrong.
-- John T. Reed in The real estate B.S. artist detection checklist [^]
|
|
|
|
|
|
Microsoft Press used to have a book on Localization/Globalization.
It was pretty good at the time.
C++/MFC/InstallShield since 1993
|
|
|
|
|
dear all,
i want to write a small utility which runs in the background and detects
system shutdown.
but i have no idea about how to go about it
any suggestion will be greatly appreciated
thanx
|
|
|
|
|
|
thanx for ur timely reply
can u post some sample or direct me to some url which shows the same
thanx a ton
|
|
|
|
|
I'm trying to create a popup menu for my tree control. I've got some code and the sample I have seems to use a CPoint pointer for the x and y locations of the mouse. Can I get access to a CPoint object somehow in the code I have?
void CSacmanSetupDlg::OnRclickSacmanSetupTree(NMHDR* pNMHDR, LRESULT* pResult) <br />
{<br />
bool bDone = false;<br />
HTREEITEM hSelectedItem;<br />
<br />
CMenu newMenu;<br />
newMenu.CreatePopupMenu();<br />
bDone = newMenu.TrackPopupMenu(TPM_LEFTALIGN,15,15, <br />
AfxGetApp()->m_pMainWnd,NULL);<br />
hSelectedItem = this->m_SetUpTree.GetSelectedItem();<br />
<br />
*pResult = 0;<br />
}
Sample I'm working from...
void CAppButton::OnRButtonDown(UINT flags, CPoint point)<br />
{<br />
CMenu menu;<br />
CMenu *submenu;<br />
menu.LoadMenu(IDR_LAUNCH);<br />
submenu = menu.GetSubMenu(0);<br />
ClientToScreen(&point);<br />
submenu->TrackPopupMenu(TPM_LEFTALIGN|TPM_RIGHTBUTTON,<br />
point.x, point.y,<br />
AfxGetApp()->m_pMainWnd,NULL);<br />
}
|
|
|
|
|
GetCursorPos() will return the current position of the mouse in screen coordinates. From memory (so i may be wrong), TrackPopupMenu() wants coordinates in client coorindates, so you may need to convert it first.
Dave
|
|
|
|
|
Actually, TrackPopupMenu needs screen coordinates  (your memory must be fading... ). You can pass the results of GetCursorPos() straight to TrackPopupMenu().
However, for this app you might want to use GetMessagePos(), which returns the screen position of the mouse when the last message retrieved with GetMessage() was generated.
Cheers,
Ryan
|
|
|
|
|
Many thanks, I am unworthy!
|
|
|
|
|
El debugero says that Track PopupMenu is returning a zero...what gives? 
bool bDone = false;<br />
int x,y;<br />
HTREEITEM hSelectedItem;<br />
DWORD mousePosition;<br />
mousePosition = ::GetMessagePos();<br />
x = GET_X_LPARAM(mousePosition);<br />
y = GET_Y_LPARAM(mousePosition);<br />
<br />
<br />
CMenu newMenu;<br />
newMenu.CreatePopupMenu();<br />
bDone = newMenu.TrackPopupMenu(TPM_LEFTALIGN|TPM_RIGHTBUTTON,x,y, <br />
AfxGetApp()->m_pMainWnd,NULL);<br />
if(bDone)<br />
Beep(678,46);<br />
<br />
<br />
hSelectedItem = this->m_SetUpTree.GetSelectedItem();<br />
<br />
<br />
*pResult = 0;
|
|
|
|
|
If this is the exact code you're using, then the problem is that you're not adding items to the menu before you call TrackPopupMenu(). You have to either call newMenu.LoadMenu() to load a menu from a resource, or call newMenu.InsertMenu()/AppendMenu() to create the menu items at runtime.
At the moment, you're trying to display a menu with no items in it.
Ryan Binns
He who laughs last... thinks too slowly.
|
|
|
|
|
With this code I get a menu but it's about 1 mm thick. I don't see any functions that let me adjust the size or shape of the new menu...
void CSacmanSetupDlg::OnRclickSacmanSetupTree(NMHDR* pNMHDR, LRESULT* pResult) <br />
{<br />
int x,y;<br />
int menuHandle;<br />
bool bDone = false;<br />
char * newItem = "Does It Work?";<br />
<br />
UINT nPosition = 0;<br />
HTREEITEM hSelectedItem;<br />
DWORD mousePosition;<br />
<br />
mousePosition = ::GetMessagePos();<br />
x = GET_X_LPARAM(mousePosition);<br />
y = GET_Y_LPARAM(mousePosition);<br />
<br />
<br />
CMenu newMenu;<br />
<br />
newMenu.CreateMenu();<br />
newMenu.InsertMenu(nPosition,MF_POPUP,menuHandle,newItem);<br />
<br />
<br />
newMenu.EnableMenuItem(1,MF_BYPOSITION);<br />
newMenu.TrackPopupMenu(TPM_CENTERALIGN,x,y,<br />
::AfxGetMainWnd(),0);<br />
if(bDone)<br />
Beep(678,46);<br />
<br />
<br />
hSelectedItem = this->m_SetUpTree.GetSelectedItem();<br />
<br />
<br />
*pResult = 0;<br />
}
I'm vexed...
|
|
|
|
|
You can't adjust the size or shape of the menu (not without using owner-draw anyway), but 99.9% of the time you won't have to. Windows will automatically size the menu based on its contents.
What you have done here is created a menu with a single item in it - a submenu that has no items, and you haven't given the submenu a name. If an item's name has no characters, then nothing is displayed and the menu is very thin, which is exactly what is happening.
To add useful items to your menu, use the following:
<br />
newMenu.InsertMenu(nPosition, MF_BYPOSITION | MF_STRING, ID_MENU_ITEM, strMenuText);<br />
Where:
ID_MENU_ITEM is the menu item identifier of your menu item
strMenuText is the text of your menu item ("Cut", "Copy", etc...)
Ryan
He who laughs last thinks too slowly.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
