OmniTrader Forum OmniTrader Forum
forums calendars search
today this week
 
register logon control panel Forum Rules
You are currently browsing as a guest.
You should logon to access more features
A Self-Moderated Community - ALL MEMBERS, PLEASE READ!
Vote for Members who contribute the most to your trading, and help us moderate content within the Forums.


  Current location        Thread information  
OmniTrader 2016 Forums
OmniTrader 2017 Technical Support
OT crashes while exporting to Excel (*.xls) Format
Last Activity 5/13/2018 2:15 AM
10 replies, 549 viewings

Jump to page : 1
Now viewing page 1 [25 messages per page]
 
back reply
Printer friendly version

^ Top
Vinay

Legend
1001001001002525
Posts: 469

Joined: 12/9/2011
Location: Planet Earth

User Profile
 
Subject : OT crashes while exporting to Excel (*.xls) Format
Posted : 8/11/2017 8:41 AM
Post #42330

When I try to export Performance Summary Report to Microsoft Excel (*.xls) Format OT crashes with the following Run-time Error:





However exporting to other formats including Excel Data-only (*.xls & *.xlsx) formats works fine.


I have experienced this problem on both of two systems where I have installed OT with the following configuration:

1. Windows 7 (32-bit) with OT2017 (PR-2J)
2. Windows 10 (64-bit) with OT2017 (PR-2M)


[Edited by Vinay on 8/11/2017 8:45 AM]

Attached file : OT Error.jpg (44KB - 227 downloads)

^ Top
Barry Cohen

Sage
500010010010025
Posts: 5332

Joined: 1/19/2004

User Profile
 
Subject : RE: OT crashes while exporting to Excel (*.xls) Fo
Posted : 8/16/2017 2:04 PM
Post #42343 - In reply to #42330

Which format doesn't work for you? You said *.xls doesn't work, but also said it works.
^ Top
Vinay

Legend
1001001001002525
Posts: 469

Joined: 12/9/2011
Location: Planet Earth

User Profile
 
Subject : RE: OT crashes while exporting to Excel (*.xls) Fo
Posted : 8/17/2017 4:19 AM
Post #42354 - In reply to #42330

Barry,

The highlighted format in the following image causes the OT to crash. Exporting to all other formats works well.






[Edited by Vinay on 8/17/2017 4:20 AM]

Attached file : xls.jpg (60KB - 161 downloads)

^ Top
Barry Cohen

Sage
500010010010025
Posts: 5332

Joined: 1/19/2004

User Profile
 
Subject : RE: OT crashes while exporting to Excel (*.xls) Fo
Posted : 8/17/2017 11:58 AM
Post #42355 - In reply to #42354

Thanks Vinay, I reproduced & reported.
^ Top
Vinay

Legend
1001001001002525
Posts: 469

Joined: 12/9/2011
Location: Planet Earth

User Profile
 
Subject : RE: OT crashes while exporting to Excel (*.xls) Fo
Posted : 11/7/2017 10:04 AM
Post #42613 - In reply to #42330

Barry,

OT crashing is a serious issue. At least this should have been fixed by now.


^ Top
Vinay

Legend
1001001001002525
Posts: 469

Joined: 12/9/2011
Location: Planet Earth

User Profile
 
Subject : RE: OT crashes while exporting to Excel (*.xls) Fo
Posted : 5/11/2018 11:05 AM
Post #44661 - In reply to #42330

Any ETA when this is likely to be fixed?

^ Top
mholstius

Regular
252525
Posts: 91

Joined: 1/13/2017

User Profile
 
Subject : RE: OT crashes while exporting to Excel (*.xls) Fo
Posted : 5/11/2018 12:32 PM
Post #44664 - In reply to #44661

FWIW...
I've never had a problem when exporting to the;

Microsoft Excel Workbook Data-Only (.xlsx)

If you want Excel (97-2003) years, have you tried the;

Microsoft Excel (97-2003) Data-Only (*.xls)

Maybe that will work...???
Mark
^ Top
LSJ

Veteran
100100
Posts: 206
Online

Joined: 8/17/2006
Location: Citrus Springs, FL

User Profile
 
Subject : RE: OT crashes while exporting to Excel (*.xls) Fo
Posted : 5/11/2018 1:18 PM
Post #44667 - In reply to #42330

FWIW I use .xlsx and it works.

I'm using OT 2018 and Office 2016

[Edited by LSJ on 5/11/2018 1:20 PM]

^ Top
Vinay

Legend
1001001001002525
Posts: 469

Joined: 12/9/2011
Location: Planet Earth

User Profile
 
Subject : RE: OT crashes while exporting to Excel (*.xls) Fo
Posted : 5/12/2018 1:11 AM
Post #44674 - In reply to #44664

Mark... Microsoft Excel Workbook Data-Only (.xlsx) and Microsoft Excel (97-2003) Data-Only (*.xls) both work fine, the problem is with Microsoft Excel (97-2003)(*.xls) format. Please try this format (Microsoft Excel (97-2003)(*.xls)) while exporting and see what happens.




[Edited by Vinay on 5/12/2018 1:46 AM]

^ Top
mholstius

Regular
252525
Posts: 91

Joined: 1/13/2017

User Profile
 
Subject : RE: OT crashes while exporting to Excel (*.xls) Fo
Posted : 5/12/2018 5:01 AM
Post #44676 - In reply to #44674

Hmmmm

I don't mean any disrespect at all... just wondering why you'd be concerned about exporting to a version of excel that's 15 years out of date?

If the export doesn't work, are you just letting Nirvana know that they should remove it from the options?

Mark
^ Top
Vinay

Legend
1001001001002525
Posts: 469

Joined: 12/9/2011
Location: Planet Earth

User Profile
 
Subject : RE: OT crashes while exporting to Excel (*.xls) Fo
Posted : 5/13/2018 2:15 AM
Post #44678 - In reply to #44676

If they can not fix it then better they should remove this option so that OT doesn't crash and potentially corrupt the Profile and other files thereby causing all the hard work and time down the drain.

Regarding the version of Excel rather file format being 15 years old, it is still very widely used format and in any case OT is not known for being at the cutting edge of technology.

Jump to page : 1
Now viewing page 1 [25 messages per page]
back reply

Legend    Action      Notification  
Administrator
Forum Moderator
Registered User
Unregistered User
E-Mail this thread to a friend
Toggle e-mail notification


Nirvana Systems
For any problems or issues please contact our Webmaster at webmaster@nirvsys.com.