Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

ActiveReport - Excel Format Gives 'Problems came up in the following areas during load:' Message When Opening.


David Briars

Recommended Posts

In an ActiveReport I am clicking on the following menu options:

Export

XML (Excel)

All Records

When I go to open the created .XLS file in Excel I see the following error box:

image.png.3fb8033d2b4d8f625868d3794865ebc3.png 

Notes:

  • Running WF 8207.28.
  • This doesn't occur for all export attempts. I cannot determine what is different about the attempts that give this error message.
Link to comment
Share on other sites

Many thanks to all, for your thoughts on what is probably an 'edge case'.

Here is an update, on some of my analysis today.

The .log file is not obtainable, at least for me, with the usual browsing in File Explorer.

However, typing in the path directly in File Explorer does get me to the folder where the .log file lives.

The MS Excel log file doesn't seem to give me a clue as to which/what is the 'bad value':

image.thumb.png.a612bde134699aeacb373ead177f0872.png 

The ActiveReport focexec in question, creates and displays HTML tags via the 'JAVASCRIPT=' WebFOCUS StyleSheet command.

The Export...XML (Excel) menu option works fine in some runs of the report, and other times we get the MS Excel 'Problems During Load' error message.

While I cannot readily see any differences between the two sets of runs, perhaps it is some combinations of data and the code that results from 'JAVASCRIPT='?

The ActiveReport EXPORT...CSV works AOK for the exports that wouldn't work in Excel.

And, the UX is nearly the same as EXPORT...XML (Excel).

I've asked my users then, to use EXPORT...CSV going forward, in these edge cases.

Once again, many thanks all.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...