Math Calculation

I make sales drawings for a manufacturer. In these drawings I show both metric and imperial measurements. Example: 27' 8"  8433 mm. What I normally do is use a conversion calculator someone made in Excel. i type the distance in Excel, then type the answer in CoreI onto the sales drawing. I would prefer it if Corel Draw could just do it. So if it type the metric distance, Corel will automatically insert the correct feet & inches. Along with imputing the feet and inches, Corel puts in the converted metric distance. I tried this with importing a table from Excel into Corel. It did sometimes work, but would Crash Corel constantly. I use Corel Draw Graphics suite X7. 

  • Would you please clarify exactly what units you are starting with?

    In the examples you show, the dimensions all look to me as though the objects/structures you are documenting were "designed in feet and inches", and that the millimeter values were calculated from those - not the other way around.

    Side note: I'm going to guess that it is an accident that this was posted in Corel CONNECT X7 forum. I don't know how easy it is to get a thread moved, but it might be worth asking, or perhaps just starting a new thread over in the CorelDraw X7 forum. I think a lot more eyeballs would find it there.
    • I couldn't figure out how to change this posting from Corel Connect to a Corel Draw X7 post. I reposted this question in Corel Draw X7 as you suggested.
      • I wrote a little macro that lets one enter values for feet and inches. The macro then cooks up the text string, displays it, and copies it to the clipboard.

        The VBA form is still ugly. After I tidy it up a bit,  I'll post the GMS file.

        • The quick and easy method for using macro code if in written form.

          1. From CorelDRAW go Tool­s/Macros/Macro Manager (Alt+Shift+F11)
          2. Right click on Visual Basic for Applications and choose “New Macro Project”
          3. Name same as in written code or some other of your own choosing.
          Can use upper & lowercase names but NO SPACES. No need to add the
          extension then hit Save wait a ew secongds and it will appear at the bottom
          of macro manager.
          4. Click off of that then right click on it and choose “New Module”. Wait a few
          seconds and “Module1” will appear
          5. Click off that then right click and choose “New Macro”. Text will read

          Sub Macro 1()
          End macro

          6. Copy the code from this forum and insert in place of everything listed in the macro

          If given a .gms file then download to
          C:\Users\Your Name\AppData\Roaming\Corel\CorelDRAW Graphics Suite X7\Draw\GMS
          • This may give you a better idea of what I was looking for. Clicking on the imported Excel cells to edit the numbers will crash Corel after only editing the measurements a couple times.  Looking for something that works just inside Corel. So as I type in the feet and inches, the millimeters are automatically added. This way there is only 1 step, not 3. 

            • Short answer is no. No one step. Best I can tell is to use the macro Eskimo has made. Be patient as he fixes the bug mentioned.
              • This issue has been solved! see similar post I put into the Corel Draw X7 forum.