cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X

Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

AkmarulSalleh
4-Participant

Mathcad Prime 10: Excel File Generated by WRITEEXCEL has wrong time stamp

Hello all,

I found out the WRITEEXCEL generate excel file with wrong time stamp. This is my worksheet.

test1.xlsx is a simple file, that contain 4x3 information.

AkmarulSalleh_0-1735977820463.png

 

Timestamp generated is 28 March 2009. Anyone facing the same issue?

AkmarulSalleh_1-1735977914663.png

 

Regards

 

 

14 REPLIES 14
LucMeekes
23-Emerald III
(To:AkmarulSalleh)

Depends on what timestamp you're looking at. Is it the creation date, or the latest access date?

 

Success!

Luc

Hello. It is the creation time. I just created test5.xlsx today, but the date for the file is 28 March 2009.

You can try this simple 1 line code, and verify if the date is correct. I still got 28 March 2009.. hmm... weird.. 

AkmarulSalleh_0-1735982912966.png

 

LucMeekes
23-Emerald III
(To:AkmarulSalleh)

Ok. Checked with Prime 10.0.0.0 Express.. Cannot confirm exactly, 'cause for me the date is one day earlier:

LucMeekes_0-1736071801386.png

The same occurs with Prime2 and 4 express (exact same date and time) so is probably true for all versions of Prime. Note that the date predates Prime1. Probably a design-time constant was used for setting the date. The bug does not occur in (real) Mathcad because the function doesn't exist there.

I propose you report it to PTC.

 

Success!

Luc

 

Werner_E
25-Diamond I
(To:LucMeekes)

Strange!

I tested with the full versions of Prime 10.0.1.0 and Prime 9 as well as with the Express version of Prime 6 and the command

Werner_E_0-1736107994617.png

resulted in a newly created Excel file with the correct system date as date of creation, date of last change and date of last access.

 

Using Win 10 pro and Excel 2016.

 

I can't duplicate the issue.

When I create an Excel file via WRITEEXCEl, it gets the correct system date.

You are sure that OS date/time are set correct on your system?

AkmarulSalleh_0-1736070728528.png

System Date is all correct. I never have this kind of issue, with other software. I'll ask Mathcad Technical support

 

LucMeekes
23-Emerald III
(To:Werner_E)

I didn't use Excel (at least not explicitly), just created the file from within Prime and checked the date in Windows's file explorer....

And, there's no Excel 2013 installed on my PC...

 

Luc.

LucMeekes
23-Emerald III
(To:Werner_E)

Tried on another machine.

Writing to "file.xlsx" produced an 8 kB file (new office format: zipped archive of xml files) with the old date.

Writing to "file.xls" produced a 1kB file (old format: binary etc) with the current date and time.

This may be a work-around.

 

Success!
L:uc

MP10.0.1.0

I have tried, but would not work. 

AkmarulSalleh_0-1736214451126.png

 

Regards,

Ak

 

Hi Ak

 

use the extension *.xlsx" as the error message says:

Capture.JPG

 

I get the current system date for the excel files.

LucMeekes
23-Emerald III
(To:AkmarulSalleh)

Ah, apparently they've dropped that possibility somewhere between Prime 4 (where it is possible) and Prime 9 (get the same error message as you).

 

Success!
Luc

Werner_E
25-Diamond I
(To:LucMeekes)

I just tested and Prime 6 still is able to create xls files, Prime 9 can't. Can't say about versions 7 and 8 (never installed them).

 

But as already said all files created, whether xls or xlsx and regardless with which version of Prime get the correct system date.

 

So it seems not to be a Prime only problem but must have to do with something else as well. It also seems to work OK for Terry as well.

Announcements

Top Tags