OmniTrader Forum : OmniTrader 2017 Technical Support : OT crashes while exporting to Excel (*.xls) Format

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 Archives OmniTrader 2017 Technical Support OT crashes while exporting to Excel (*.xls) Format		Last Activity 1/4/2023 9:49 AM 10 replies, 2050 viewings

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

< Previous Thread :: Next Thread >

Printer friendly version

^ Top

Vinay

Elite

Posts: 640

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 - 715 downloads)

^ Top

Barry Cohen

Sage

Posts: 6338

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

Elite

Posts: 640

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 - 667 downloads)

^ Top

Barry Cohen

Sage

Posts: 6338

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

Elite

Posts: 640

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

Elite

Posts: 640

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

Veteran

Posts: 175

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

Legend

Posts: 515

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

Elite

Posts: 640

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

Veteran

Posts: 175

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

Elite

Posts: 640

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]

< Previous Thread :: Next Thread >

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

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