11-03-2015 09:54 AM
I am trying to copy paste the forecast values table as spreadsheet not image in excel and it doesnt paste. It only pastes "obs" for some reason. what am i missing here?
11-03-2015 11:44 AM
Under Forecasting View - hit "Copy Table" icon.
This will bring up a this dialog:
In MS Excel you will be able to paste the table into a spreadsheet:
Works fine with Forecasting for Desktop 13.2 (at least for me). If you experience a different behavior you may want to contact Technical Support.
11-06-2015 10:37 AM
this works fine on my end what i meant is if you are in the modeling view-> tables->forecast values you can highlight and then right click copy, but then try to paste in excel it doesnt work.
thanks for all your responses
11-06-2015 12:12 PM - edited 11-06-2015 03:23 PM
This seems to be a defect indeed - thanks for bringing it to our attention.
Here a one way to work around it:
Step 1: copy the data
Step 2: Paste the data
Step 3: click on (Crtl) pull down in Excel
Step 4: select "Use Text Import Wizard..."
Step 5: make sure to use "Tab" as delimiter
Step 6: you will need to clean up the label manually
Hope this helps.