Re: excel - C / C++ / MFC Discussion Boards

David Crow14-Apr-10 3:08

14-Apr-10 3:08

Code-o-mat wrote:
What i did was to create a few dialogs with a whole bunch of edit controls on them that let the user hammer in all kinds of data, mostly numbers, when the OK button is hit, i called UpdateData to move the user's entries into integer values and then check these for correctness and display a message box if something's wrong. This works ok as long as the user entered something into the edit fields, but if the user leaves one empty, then during the Dataexchange process a nice little "Please enter an integer" message box is spit up...

While not a direct solution to your problem, you should consider disabling the OK button until all the edit controls are non-empty. This works for other controls, too. You can ensure that items in comboboxes and listboxes have been selected, checkboxes have been checked, etc, all before enabling the OK button.

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"Man who follows car will be exhausted." - Confucius

Re: Avoid "Data Exchange" validation

Maximilien14-Apr-10 4:46

Maximilien

14-Apr-10 4:46

Code-o-mat wrote:
before calling DoDataExhcnage put a "0" into every numeric edit field on the dialog that is empty

Unless 0 (zero) is a valid input.

Watched code never compiles.

Changing Printer Settings to ensure Landscape print [modified]

maycockt13-Apr-10 23:27

maycockt

13-Apr-10 23:27

Hi,

My application requires printing of data on different printers.
Is it possible to ensure that after a printer has been chosen (that may not be the default printer), the print layout is in Landscape mode?

I have looked at examples from MSDN, mfcdvmdvcnet.exe (I can't remember the Q number), but that seems oriented to using the default printer, whereas I want to ensure that after printer selection the print format is landscape using the DEVMODE structure.

EDITTED TO ADD - is there also anyway to detect the name of the chosen printer after it has been selected if it is not the default printer?

EDITTED TO CLARIFY - I have two printers, printer1 - the default A4 printer, and printer2 - my A3 printer. When I print I want to select printer2 and set it to be Landscape. How do I, using EnumPrinters or an alternative, get the name of the now selected printer, printer2, and change the DEVMODE to ensure that Landscape is used?

If anyone has a pointer to some code, or an article, that would be great.

TIA

Tony

modified on Wednesday, April 14, 2010 6:06 AM

Re: Changing Printer Settings to ensure Landscape print

David Crow14-Apr-10 3:13

David Crow

14-Apr-10 3:13

maycockt wrote:
EDITTED TO ADD - is there also anyway to detect the name of the chosen printer after it has been selected if it is not the default printer?

Are you using PrintDlg() for this? If so, look at the hDevNames member of the PRINTDLG structure.

Re: Changing Printer Settings to ensure Landscape print

@Intersect☺™14-Apr-10 4:22

@Intersect☺™

14-Apr-10 4:22

This might help you I guess :

void CYourApp::SetupDefaultPrinter()
{
UpdatePrinterSelection(FALSE);
if (m_hDevMode == NULL)
DEVMODE* pDevMode = (LPDEVMODE)::GlobalLock(m_hDevMode);
if(pDevMode)
{
pDevMode->dmFields |= DM_ORIENTATION;
pDevMode->dmOrientation = DMORIENT_LANDSCAPE
::GlobalUnlock(m_hDevMode);
}
}

Njoy...

excel

trioum13-Apr-10 23:18

trioum

13-Apr-10 23:18

I have a excel file . having refrences on various cells like =a1+b1 and =c3*f2 like that
it has about 100 cells having reference. but when get the excel calculate event I could not find
which cell value change having reference .

Trioum

Re: excel

enhzflep13-Apr-10 23:46

enhzflep

13-Apr-10 23:46

trioum wrote:
but when get the excel calculate event I could not find
which cell value change having reference .

What do you mean by this?

Re: excel

@Intersect☺™14-Apr-10 4:24

@Intersect☺™

14-Apr-10 4:24

I didn't get you. Could you please explain in a bit details?

Re: excel

ThatsAlok14-Apr-10 19:31

ThatsAlok

14-Apr-10 19:31

trioum wrote:
but when get the excel calculate event I could not find
which cell value change having reference

are you looking fro function or reference cell ?

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

column width of ListView

arun_pk13-Apr-10 22:18

arun_pk

13-Apr-10 22:18

How to get column width of each columns in the ListView Control

Re: column width of ListView

CPallini13-Apr-10 22:24

CPallini

13-Apr-10 22:24

You may use, for instance, ListView_GetColumnWidth macro.
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

Re: column width of ListView

KarstenK13-Apr-10 22:54

KarstenK

13-Apr-10 22:54

http://www.google.de/search?q=width+of+column+ListView+Control&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:de:official&client=firefox-a[^]

D'Oh! | :doh:

Press F1 for help or google it.
Greetings from Germany

Opening File that is already exclusively opened

Harsh Shankar13-Apr-10 21:30

Harsh Shankar

13-Apr-10 21:30

Hi Guys,
As i was working i got a problem. as i have to open a file, i simply call CreateFile and it Opens it. now if some application like MS Excel ect have open it previously, it is not letting me open the file.. now if it is about sharing voilation, how notepad manages the file to open it?? i think i am clear to whar i require
Expecting some Quick responce..

HARSH

Programmers are in a race with the Universe to create bigger and better idiot-proof programs, while the Universe is trying to create bigger and better idiots. So far the Universe is winning.

Re: Opening File that is already exclusively opened

Code-o-mat13-Apr-10 21:54

Code-o-mat

13-Apr-10 21:54

My guess is that Notepad opens the file for reading only (and only tries to open it for writing if the user wants to save, at which point it will also fail), when Excel or Word or the likes opens the file it probably allows other processes to read the file, but not to write to them (this would explain how you get a "open for reading only" option from Word if you try to open a document that is opened by another word instance/another user's word...). Can it be that when you use CreateFile to open the file you try to open it for writing?

> The problem with computers is that they do what you tell them to do and not what you want them to do. <
> Sometimes you just have to hate coding to do it well. <

Message Removed

13-Apr-10 21:23

aks.

13-Apr-10 21:23

Message Removed

Re: MPEG-4

CPallini13-Apr-10 21:37

CPallini

13-Apr-10 21:37

aks. wrote:
What is the difference between MPEG-4 and MPEG-4 VKI version?

Maybe the same difference there is between a C++ forum and Google. Roll eyes | :rolleyes:

Re: MPEG-4

ThatsAlok14-Apr-10 19:31

ThatsAlok

14-Apr-10 19:31

CPallini wrote:
C++ forum and Google.

Heh heh

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

Need information how to do screen scraping in windows using VC++/C++

John50213-Apr-10 20:55

John502

13-Apr-10 20:55

Hi,

I had a requirement of do screen scraping on windows. I want to capture words which are available on active window along with the pixels.

So can any one help me out how to do this....?

Thanks
John.

Re: Need information how to do screen scraping in windows using VC++/C++

Hadi Dayvary14-Apr-10 3:20

Hadi Dayvary

14-Apr-10 3:20

First get the window handle of that pixel you want,
then get the text of this window

Hope it helps Smile | :)

www.logicsims.ir

Re: Need information how to do screen scraping in windows using VC++/C++

ThatsAlok14-Apr-10 19:32

ThatsAlok

14-Apr-10 19:32

John502 wrote:
I had a requirement of do screen scraping on windows. I want to capture words which are available on active window along with the pixels.

So can any one help me out how to do this....?

are you scrapping from custom window or generic window?

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

Re: Need information how to do screen scraping in windows using VC++/C++

John50220-Apr-10 3:41

John502

20-Apr-10 3:41

I want to scrape text from custom window... From the custom window it self i just want to find out where is that text (what i am trying to search) is avaialable. Once i get the pixel pisitions of that text then i want to scrape that..

This is my requirement... Please help me out with your suggestions...

Thanks
John...

Moving controls within the dialog.

shiv@nand13-Apr-10 19:41

shiv@nand

13-Apr-10 19:41

hi i want to move button control on mouse LButton down with no Resize and position must be saved within the dialog.
How it can be done.

Re: Moving controls within the dialog.

Emilio Garavaglia13-Apr-10 20:43

Emilio Garavaglia

13-Apr-10 20:43

First, commas, full-stops and semicolons has a meaning also in natural langage:
Your question can be:
"hi, I want to move A button control on mouse LButton down, with no Resize; position must be saved within the dialog.
How it can be done?"
or
"hi I want to move button controls on mouse LButton down with no Resize and position. Must be saved within the dialog.
How it can be done?"
And they are quite different questions.

Assuming the first, since a control is a window, just use MoveWindow (note: mouse coordinates are obtained in screen coordinates, while move window requires parent client coordinates, so do the proper translation with ScreenToClient).

I don't understand what you mean with "saved within the dialog": if you mean "saved within the dialog RESOURCE", then give a look to http://msdn.microsoft.com/en-us/library/ms648004(v=VS.85).aspx[^].
Consider also that, unless you are writing a "resource management tool", modifying the resource result in modifying the "exe", and this is not, in general, a good idea: what does it happen if multiple users attempt to to modify your "exe" if it is shared across a network?
It is better to save the control positions in a file stored in a user specific directory (you can get the path with SHGetFolderPath, giving CSIDL_APPDATA as a CSIDL) and, when loading the dialog, change the controls positions (again, with MoveWindow) accordingly to such file (if existent) before showing the dialog.

2 bugs found.
> recompile ...
65534 bugs found.
D'Oh! | :doh:

Re: Moving controls within the dialog.

CPallini13-Apr-10 20:45

CPallini

13-Apr-10 20:45

jiya-123 wrote:
hi i want to move button control on mouse LButton down with no Resize

Use MoveWindow [^] or SetWindowPos [^].

jiya-123 wrote:
position must be saved within the dialog.

To make new position persistent, you may store coordinate values in a configuration file.
Smile | :)

Re: Moving controls within the dialog.

Iain Clarke, Warrior Programmer13-Apr-10 20:55

Iain Clarke, Warrior Programmer

13-Apr-10 20:55

Well, what's actually stopping you?

I can see a few steps:

First, you need this to toggle on and off. If it was on all the time, anyone using this dialog will hate you. "I just tried to press OK, but the damn button keeps moving!"

You'll need to subclass your button(s), and override WM_LBUTTONDOWN,WM_MOUSEMOVE,WM_LBUTTONUP. For the button messages, either pass them on as normal, or toggle a "I'm dragging flag". In the mouse button, subtract the current position from the last position, and move the window by that much. Something like:

void CMyMovableButton::OnMouseMove (UINT fFlags, CPoint ptMouse)
{
    // Translate point into parent coords
    if (m_bDragging) // toggles in OnLButtonDown/Up
    {
        CWnd *pParent = GetParent ();
        // Translate coords to parent coords.
        MapWindowPoints (pParent, &ptMouse, 1);
        CPoint ptDelta = ptMouse - m_ptMouseLast; // you did save the lbutton down position, I hope!
        MoveWindow (ptDelta.x, ptDelta.y);
        SetWindowPos (NULL, ptDelta.x, ptDelta.y, 0,0, SWP_NOSIZE | SWP_NOZORDER);
        m_ptMouseLast = ptMouse;
    }
    else
        __super::OnMouseMove (fFlags, ptMouse);
}

You'll also need to store all your window positions when the dialog closes (or store them whenever a control has finished moving) so that you can use that information next time the dialog is used. Maybe make structure full of CPOints (ie, ptOKButton, ptCancelButton) and save that in the registry for use in you CMyMovableDlg::OnInitDialog function?

You might also want to look at CDiagramEditor - DIY vector and dialog editor[^] for an alternate way of doing all this.

It sounds like you have a lot of work ahead of you - and I know no shortcut. I hope you have a strong business case for this, and not just "wouldn't it be cool?"

Maybe when you're done, you could write an article based on it?

Good luck,

Iain.

I have now moved to Sweden for love (awwww).

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