Excel form report

  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel form report

    Afternoon all.

    I'm having a few issues with the excel form report that was introduced in 2019

    Ive come to realise conditional formatting is a no go on the current excel form report so i have gone around this by doing if statements.

    One issue i cannot get passed though is the fact that profiles (that are reported in form and location) are reporting max values only in the spreadsheet although i have selected outtol to be selected only. Anyone else have this issue?


  • #2
    Anyone have any ideas. Quite possibly a bug within the program.?

    Top image being the profile in the report and below a snip from the outputted excel form report.



    • #3
      change lower limit from 1 to -1


      • #4
        Unable to do this as you are changing the tolerance band. +1 / -1 is not the same as upper +1.00 / lower +1.00

        I've just changed the profiles to xact measure and it works fine. It looks like this is bug in the software with legacy dimensions. (pcdmis2020)


        • #5
          Good Morning All,

          Newbie here so it is my first post here

          I have an issue with Excel Form Report and i have no idea what to do.
          I have a program written in 2018 R2 that have ~2000 dimensions reported.
          Then in 2019 Hexagon added Excel form report which is very handy for us.
          My management asked me to do 2 separate Excel reports and report some dimensions on one report(KPC, PTC, etc) and others on second report.
          So i made 2 Excel report commands on the and and in Data Tab i picked right dimensions for each report.
          Problem is every time i run program each report some random dimensions being added to each report that i don't need(software tick them in data tab on its own)

          Is there any way to "lock" each report command or anyone have rough idea what can cause it?



          Related Topics