Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


using MS FlexGrid -- Urgent

Posted on 1998-07-28
Medium Priority
Last Modified: 2013-11-20
Where or how can I get a control which would be like MSFlex Grid control, but with editable cells?
Question by:lxiao
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3

Accepted Solution

guruprasad031298 earned 180 total points
ID: 1319868
You can use the DBGrid control, which allows in-place editing or code MSFlexGrid to allow in-place editing (more work involved). If you want some code about in-place editing on MSFlexGrid, let me know.

The DBGrid control is by Apex Software Corp and is bundled with VC++ ver 5.0. In case if you don't have one in your machine or want to buy one, you can reach them through 1-800-858-APEX.

Hope this helps ....

Author Comment

ID: 1319869
I have TRUE DBGrid Evaluation copy, but I don't have a DB to support. My usage is simple, MSFlexGrid does very well except it's not editable. I would prefer in-place editing. How?

Author Comment

ID: 1319870
I have TRUE DBGrid Evaluation copy, but I don't have a DB to support. My usage is simple, MSFlexGrid does very well except it's not editable. I would prefer in-place editing. How?
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.


Expert Comment

ID: 1319871
Try using this. This is one of the answer I suggested to a question at expert-exchange already. It worked well. Should work good for you too. May be rquires some minor adjustment for edit control positioning.

void CMyView::OnDblClickStdgrid()
    // Embed editable CEdit Control

    // Construct edit control
    pEdit = new CStdEqpEdit(&m_StdGrid, row);  // Pass the flexgrid control & the                                                                       // selected row for further processing

     * Conversion from Twips to Pixel scale. Divisor values are specific to this
     * grid and may not work for others. Generic conversion routine couldn't be
     * written for this purpose. Make sure not to change this

    long lLeft = (long) (m_StdGrid.GetCellLeft () / 15);
    long lTop = (long) (m_StdGrid.GetCellTop () / 15);
    long lHeight = (long) (m_StdGrid.GetCellHeight() / 15);
    long lWidth = (long) (m_StdGrid.GetCellWidth() / 14.3);

    CRect rect (lLeft, lTop, lLeft + lWidth, lTop + lHeight);

    // Create the edit control on the fly
    pEdit->Create (WS_CHILD | WS_VISIBLE | WS_BORDER, rect,                                                       this,IDC_SEQ_NUM_EDIT);
    pEdit->SetWindowText (m_StdGrid.GetText());

    // Change the font of the edit control to that of the grid cell for consistency
    CString sFontName = m_StdGrid.GetCellFontName();
    int iFontSize = (int) (m_StdGrid.GetCellFontSize() * FONT_SCALE);
    CFont *pFontEdit = new CFont();
    pFontEdit->CreatePointFont (iFontSize, sFontName);
    pEdit->SetFont (pFontEdit);

    // Set the focus to the edit control

    Hope this helps


Author Comment

ID: 1319872
Thanks. I'll try.

Author Comment

ID: 1319873
I created the CEdit control. But once it gets into the Grid area, it disappears. What's wrong?

Expert Comment

ID: 1319874
Make sure you have subclassed the standard edit control, by using the classwizard - add new class functionality and derive the new class from CEdit, so that all the messages will be routed to this new class.

Add an OnSetFocus message handler to this Edit control. Then debug through the code to see what's wrong. Once you make sure the edit control behaves in the proper way, it's easy to figure out the rest.

Have a nice weekend

Author Comment

ID: 1319875
The edit control size looks fine. But the position is wrong. How can I find the right position without using magic numbers? Thanks.

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: Finishing the grid – keyboard support for arrow keys to manoeuvre, entering the numbers.  The PreTranslateMessage function is to be used to intercept and respond to keyboard events. Continuing from the fourth article about sudoku. …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question