Topic Options
#5277 - 09/23/05 04:44 PM GL financial won't export to Excel
Kate Spontak Offline
Adagio Pro

Registered: 03/23/02
Posts: 10
Loc: New Jersey
Client has created a complex spreadsheet that will not export to Excel.
It appears to be feeding in to the spreadsheet, but only the lines and one number appears.
Copy of file sent to Softrak support.

Top
#5278 - 09/23/05 06:57 PM Re: GL financial won't export to Excel
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4514
Loc: Wynnewood, PA
Out of curiousity, are there more than 64,000 records, or more columns than Excel can handle?

Top
#5279 - 09/23/05 07:00 PM Re: GL financial won't export to Excel
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
On specifications converted from DOS double underlines become '========

This causes a problem with Excel direct and not all lines are exported. This will be corrected in a future release.

In the meantime, edit the financial statement and clear the contents of the cells with the '====== values. You might try '--------- or '________ instead.

Double underlines can also be faked by Format | Cells |Borders |Top and Bottom and then adjusting the row size.


Top
#5280 - 09/23/05 07:01 PM Re: GL financial won't export to Excel
Ralph Allan Offline
Adagio Virtuoso

Registered: 06/02/04
Posts: 694
Loc: Prince George BC
A couple of thoughts:

- Does this problem only occur with Export to Excel Direct? It might be a memory limitation since Excel has to be running. See if the Export to Excel file works.

- I was able to do a cut & paste from Adagio FR to Excel. All the data seems fine, but it loses the cell formating.


Top
#5281 - 09/30/05 08:51 PM Re: GL financial won't export to Excel
Kate Spontak Offline
Adagio Pro

Registered: 03/23/02
Posts: 10
Loc: New Jersey
The issue was the '====== in both visible and hidden cells. Once all instances were removed, the export worked.

Top
#5282 - 09/30/05 09:31 PM Re: GL financial won't export to Excel
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Kate Spontak,

This will be fixed in the next Adagio Service Pack.


Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (1 invisible), 84 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14482 Topics
70726 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31