That's what I did.
And end the function with " Return lStatus " so you can test for an early exit.
Search found 158 matches
- Fri Apr 17, 2015 4:00 pm
- Forum: eXpress++ Support
- Topic: DC_Aarray2Excel cancel button inoperative
- Replies: 6
- Views: 9704
- Fri Apr 17, 2015 7:47 am
- Forum: eXpress++ Support
- Topic: DC_Aarray2Excel cancel button inoperative
- Replies: 6
- Views: 9704
Re: DC_Aarray2Excel cancel button inoperative
After much trial and error, if this line: oBook:SaveAs(cExcelFile,xlWorkbookNormal,cPassword) is bypassed after testing lStatus and getting .f., either oBook cannot be closed and destroyed or oExcel cannot be 'quit' or destroyed, can't tell which, and this locks the exe. The 'cancel' button now exit...
- Thu Apr 16, 2015 9:35 pm
- Forum: eXpress++ Support
- Topic: DC_Aarray2Excel cancel button inoperative
- Replies: 6
- Views: 9704
Re: DC_Aarray2Excel cancel button inoperative
Thanks, Roger, this destroys the dialog window.
But Excel is still running (oExcel not destroyed?).
The result is that the exe freezes until Excel is closed with 'task manager'.
Is it also possible to return .f. if lStatus = .f. to allow testing for a cancel?
But Excel is still running (oExcel not destroyed?).
The result is that the exe freezes until Excel is closed with 'task manager'.
Is it also possible to return .f. if lStatus = .f. to allow testing for a cancel?
- Thu Apr 16, 2015 5:35 pm
- Forum: eXpress++ Support
- Topic: DC_Aarray2Excel cancel button inoperative
- Replies: 6
- Views: 9704
DC_Aarray2Excel cancel button inoperative
The cancel button in the progress window for DC_Array2Excel does not terminate the process of building the spreadsheet.
- Fri Feb 27, 2015 9:49 am
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 61110
Re: Decimal and zeros added to text when using DC_Excel2Arra
I will give this a try.
Thank you very much.
Thank you very much.
- Thu Feb 26, 2015 8:14 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 61110
Re: Decimal and zeros added to text when using DC_Excel2Arra
Browsing the links you posted gave me hope that there is a solution to this, but it is way above my capacity to learn. This is why people like me buy libraries and language enhancements. I really appreciate your input. I guess until more people are affected by the problem and it is resolved I'll hav...
- Thu Feb 26, 2015 6:25 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 61110
Re: Decimal and zeros added to text when using DC_Excel2Arra
Thanks, Wolfgang.
Your code is remarkably close to the method I am using with the exception that I use DC_Excel2Array to create the array.
I will try creating the array using just your Xbase code to see if makes a difference but I suspect, as was originally discussed, that Excel is the culprit.
Your code is remarkably close to the method I am using with the exception that I use DC_Excel2Array to create the array.
I will try creating the array using just your Xbase code to see if makes a difference but I suspect, as was originally discussed, that Excel is the culprit.
- Thu Feb 26, 2015 6:20 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 61110
Re: Decimal and zeros added to text when using DC_Excel2Arra
Good suggestion about the csv file. Saving a spreadsheet in that format does yield text data correctly, and it could be easily manipulated, but getting an entire industry to change their pricing format from xls to csv, or trying to get everyone that uses my software to open every price sheet and sav...
- Thu Feb 26, 2015 3:28 pm
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 61110
Re: Decimal and zeros added to text when using DC_Excel2Arra
Thanks, but it is not a format problem. The problem is that a character string in a spreadsheet cell, formatted as text, containing the data "12345", when converted to an array item, becomes "12345.0000" (text) in the array. The solution is not to truncate the decimal and zeros from the character st...
- Thu Feb 26, 2015 11:14 am
- Forum: eXpress++ Support
- Topic: Decimal and zeros added to text when using DC_Excel2Array
- Replies: 38
- Views: 61110
Re: Decimal and zeros added to text when using DC_Excel2Arra
I use DC_Excel2Array because I have no idea how to extract one value from a cell in a spreadsheet and store it in a field, variable, or array. Is there a way to do this in Xbase? I could then write a function to somehow compare the length of the string, value, number of decimals, etc. and then make ...