Closed ARuddOS closed 1 year ago
Adam—
Currently there is not a method that will set the cell to ignore the warning message. I have created a test spreadsheet with the warning set to be ignored and it does not appear to be difficult to add this feature. Cannot make any promises, but I will look into adding this for the next beta release.
Greg
From: ARuddOS @.> Sent: Monday, June 12, 2023 10:08 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Subject: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Hi,
I cannot see anything in the release notes that would allow the suppression of "Number As Text warnings" on cells, but that may be just because I cannot see it rather than it not being there!
Is there any way to suppress these warnings? In Excel automation it can be done cell be cell, and it has to be by cell by cell as far as I have found, this command would remove the error in cell A1:
m.oExcel = CREATEOBJECT("Excel.Application") m.oExcel.WorkBooks.Add() m.oExcel.WorkBooks(1).Sheets(1).Cells(1,1).Errors(3).Ignore=.T.
Is there an equivalent in your class please?
Thanks
Adam
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IR7P2BHSRQVDPSAPLXK4PCHANCNFSM6AAAAAAZDOAL4A. You are receiving this because you are subscribed to this thread.Message ID: @.**@.>>
Thanks, it would be much appreciated, as is the class in general, so much quicker creating xlsx files than doing the same via Excel automation.
We are planning to use your class to create spreadsheets from our billing software, the invoice numbers are text but are predominantly numbers with leading zeros. We set the cell format to be text so that Excel shows the leading zeros, and then it is fairly niche but I personally find the little green flag on each cell with the warning to be distracting!
From: ggreen86 @.> Sent: Monday, June 12, 2023 10:49 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: Adam Rudd @.>; Author @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Adam—
Currently there is not a method that will set the cell to ignore the warning message. I have created a test spreadsheet with the warning set to be ignored and it does not appear to be difficult to add this feature. Cannot make any promises, but I will look into adding this for the next beta release.
Greg
From: ARuddOS @.> Sent: Monday, June 12, 2023 10:08 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Subject: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Hi,
I cannot see anything in the release notes that would allow the suppression of "Number As Text warnings" on cells, but that may be just because I cannot see it rather than it not being there!
Is there any way to suppress these warnings? In Excel automation it can be done cell be cell, and it has to be by cell by cell as far as I have found, this command would remove the error in cell A1:
m.oExcel = CREATEOBJECT("Excel.Application") m.oExcel.WorkBooks.Add() m.oExcel.WorkBooks(1).Sheets(1).Cells(1,1).Errors(3).Ignore=.T.
Is there an equivalent in your class please?
Thanks
Adam
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IR7P2BHSRQVDPSAPLXK4PCHANCNFSM6AAAAAAZDOAL4A. You are receiving this because you are subscribed to this thread.Message ID: @.**@.>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1588152329, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAQH5BTXJANQ7HB47PYWTXLXK6FERANCNFSM6AAAAAAZDOAL4A. You are receiving this because you authored the thread.Message ID: @.***>
Adam—
I have added a new method (SetIgnoreWarnings) to assign the ignore for a cell in Beta 4. See the Demo() method, line 174 for some examples of calling the method. Please perform some testing to set the ignore setting and let me know if it works. If you have any problems, please send an example spreadsheet for me to debug. Thank you.
Greg
From: ARuddOS @.> Sent: Tuesday, June 13, 2023 3:21 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Thanks, it would be much appreciated, as is the class in general, so much quicker creating xlsx files than doing the same via Excel automation.
We are planning to use your class to create spreadsheets from our billing software, the invoice numbers are text but are predominantly numbers with leading zeros. We set the cell format to be text so that Excel shows the leading zeros, and then it is fairly niche but I personally find the little green flag on each cell with the warning to be distracting!
From: ggreen86 @.<mailto:@.>> Sent: Monday, June 12, 2023 10:49 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: Adam Rudd @.<mailto:@.>>; Author @.<mailto:@.>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Adam—
Currently there is not a method that will set the cell to ignore the warning message. I have created a test spreadsheet with the warning set to be ignored and it does not appear to be difficult to add this feature. Cannot make any promises, but I will look into adding this for the next beta release.
Greg
From: ARuddOS @.<mailto:@.>> Sent: Monday, June 12, 2023 10:08 AM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: Subscribed @.<mailto:@.>> Subject: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Hi,
I cannot see anything in the release notes that would allow the suppression of "Number As Text warnings" on cells, but that may be just because I cannot see it rather than it not being there!
Is there any way to suppress these warnings? In Excel automation it can be done cell be cell, and it has to be by cell by cell as far as I have found, this command would remove the error in cell A1:
m.oExcel = CREATEOBJECT("Excel.Application") m.oExcel.WorkBooks.Add() m.oExcel.WorkBooks(1).Sheets(1).Cells(1,1).Errors(3).Ignore=.T.
Is there an equivalent in your class please?
Thanks
Adam
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IR7P2BHSRQVDPSAPLXK4PCHANCNFSM6AAAAAAZDOAL4A. You are receiving this because you are subscribed to this thread.Message ID: @.**@.mailto:***@***.******@***.***>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1588152329, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAQH5BTXJANQ7HB47PYWTXLXK6FERANCNFSM6AAAAAAZDOAL4A. You are receiving this because you authored the thread.Message ID: @.<mailto:@.>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1588692593, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33LODEOMPQB64OKY7U3XLAIEXANCNFSM6AAAAAAZDOAL4A. You are receiving this because you commented.Message ID: @.**@.>>
Brilliant, thanks! That works well for me for the NumberAsText warnings.
If I may suggest one tweak that may be useful, there are several warnings that can be suppressed and other users may want to suppress other types too.
This is the full list: https://learn.microsoft.com/en-us/office/vba/api/Excel.XlErrorChecks
Now I see the list I think the XlTextDate may also be useful for us where our users have entered a date in a free text field in our system. Not a biggie though, we do not suppress that one through Excel Automation at the moment.
From: ggreen86 @.> Sent: 14 June 2023 02:20 To: ggreen86/XLSX-Workbook-Class @.> Cc: Adam Rudd @.>; Author @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Adam—
I have added a new method (SetIgnoreWarnings) to assign the ignore for a cell in Beta 4. See the Demo() method, line 174 for some examples of calling the method. Please perform some testing to set the ignore setting and let me know if it works. If you have any problems, please send an example spreadsheet for me to debug. Thank you.
Greg
From: ARuddOS @.> Sent: Tuesday, June 13, 2023 3:21 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Thanks, it would be much appreciated, as is the class in general, so much quicker creating xlsx files than doing the same via Excel automation.
We are planning to use your class to create spreadsheets from our billing software, the invoice numbers are text but are predominantly numbers with leading zeros. We set the cell format to be text so that Excel shows the leading zeros, and then it is fairly niche but I personally find the little green flag on each cell with the warning to be distracting!
From: ggreen86 @.<mailto:@.>> Sent: Monday, June 12, 2023 10:49 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: Adam Rudd @.<mailto:@.>>; Author @.<mailto:@.>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Adam—
Currently there is not a method that will set the cell to ignore the warning message. I have created a test spreadsheet with the warning set to be ignored and it does not appear to be difficult to add this feature. Cannot make any promises, but I will look into adding this for the next beta release.
Greg
From: ARuddOS @.<mailto:@.>> Sent: Monday, June 12, 2023 10:08 AM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: Subscribed @.<mailto:@.>> Subject: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Hi,
I cannot see anything in the release notes that would allow the suppression of "Number As Text warnings" on cells, but that may be just because I cannot see it rather than it not being there!
Is there any way to suppress these warnings? In Excel automation it can be done cell be cell, and it has to be by cell by cell as far as I have found, this command would remove the error in cell A1:
m.oExcel = CREATEOBJECT("Excel.Application") m.oExcel.WorkBooks.Add() m.oExcel.WorkBooks(1).Sheets(1).Cells(1,1).Errors(3).Ignore=.T.
Is there an equivalent in your class please?
Thanks
Adam
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IR7P2BHSRQVDPSAPLXK4PCHANCNFSM6AAAAAAZDOAL4A. You are receiving this because you are subscribed to this thread.Message ID: @.**@.mailto:***@***.******@***.***>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1588152329, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAQH5BTXJANQ7HB47PYWTXLXK6FERANCNFSM6AAAAAAZDOAL4A. You are receiving this because you authored the thread.Message ID: @.<mailto:@.>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1588692593, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33LODEOMPQB64OKY7U3XLAIEXANCNFSM6AAAAAAZDOAL4A. You are receiving this because you commented.Message ID: @.**@.>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1590289566, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAQH5BS3AVHH4X6X44XAN6DXLEGT7ANCNFSM6AAAAAAZDOAL4A. You are receiving this because you authored the thread.Message ID: @.***>
Adam—
Thank you for the feedback. I actually use the official reference for spreadsheets when determining what each segment in the XML should have:
ECMA Office Open XML Part 1 - Fundamentals And Markup Language Reference (for ignored errors, see section 18.3.1.50, page 1643)
This also gives all the suppressions available for spreadsheet cells. The list Microsoft gives does not actually list the attribute names which is necessary for the segment in the sheet.xml. I considered adding all of them; but I was not sure of the need or whether they would be used. To incorporate a solution for all of them would have been a bit more complicated as each warning would have possibility of sharing the same cells or not. So in short, I took the easy way out at this time…
Greg
From: ARuddOS @.> Sent: Wednesday, June 14, 2023 4:40 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Brilliant, thanks! That works well for me for the NumberAsText warnings.
If I may suggest one tweak that may be useful, there are several warnings that can be suppressed and other users may want to suppress other types too.
This is the full list: https://learn.microsoft.com/en-us/office/vba/api/Excel.XlErrorChecks
Now I see the list I think the XlTextDate may also be useful for us where our users have entered a date in a free text field in our system. Not a biggie though, we do not suppress that one through Excel Automation at the moment.
From: ggreen86 @.<mailto:@.>> Sent: 14 June 2023 02:20 To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: Adam Rudd @.<mailto:@.>>; Author @.<mailto:@.>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Adam—
I have added a new method (SetIgnoreWarnings) to assign the ignore for a cell in Beta 4. See the Demo() method, line 174 for some examples of calling the method. Please perform some testing to set the ignore setting and let me know if it works. If you have any problems, please send an example spreadsheet for me to debug. Thank you.
Greg
From: ARuddOS @.<mailto:@.>> Sent: Tuesday, June 13, 2023 3:21 AM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: ggreen86 @.<mailto:@.>>; Comment @.<mailto:@.>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Thanks, it would be much appreciated, as is the class in general, so much quicker creating xlsx files than doing the same via Excel automation.
We are planning to use your class to create spreadsheets from our billing software, the invoice numbers are text but are predominantly numbers with leading zeros. We set the cell format to be text so that Excel shows the leading zeros, and then it is fairly niche but I personally find the little green flag on each cell with the warning to be distracting!
From: ggreen86 @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Sent: Monday, June 12, 2023 10:49 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Cc: Adam Rudd @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>; Author @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Adam—
Currently there is not a method that will set the cell to ignore the warning message. I have created a test spreadsheet with the warning set to be ignored and it does not appear to be difficult to add this feature. Cannot make any promises, but I will look into adding this for the next beta release.
Greg
From: ARuddOS @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Sent: Monday, June 12, 2023 10:08 AM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Cc: Subscribed @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Subject: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Hi,
I cannot see anything in the release notes that would allow the suppression of "Number As Text warnings" on cells, but that may be just because I cannot see it rather than it not being there!
Is there any way to suppress these warnings? In Excel automation it can be done cell be cell, and it has to be by cell by cell as far as I have found, this command would remove the error in cell A1:
m.oExcel = CREATEOBJECT("Excel.Application") m.oExcel.WorkBooks.Add() m.oExcel.WorkBooks(1).Sheets(1).Cells(1,1).Errors(3).Ignore=.T.
Is there an equivalent in your class please?
Thanks
Adam
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IR7P2BHSRQVDPSAPLXK4PCHANCNFSM6AAAAAAZDOAL4A. You are receiving this because you are subscribed to this thread.Message ID: @.**@.mailto:***@***.******@***.***<mailto:***@***.******@***.***%3cmailto:***@***.******@***.***>>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1588152329, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAQH5BTXJANQ7HB47PYWTXLXK6FERANCNFSM6AAAAAAZDOAL4A. You are receiving this because you authored the thread.Message ID: @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1588692593, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33LODEOMPQB64OKY7U3XLAIEXANCNFSM6AAAAAAZDOAL4A. You are receiving this because you commented.Message ID: @.**@.mailto:***@***.******@***.***>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1590289566, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAQH5BS3AVHH4X6X44XAN6DXLEGT7ANCNFSM6AAAAAAZDOAL4A. You are receiving this because you authored the thread.Message ID: @.<mailto:@.>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1590742270, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33JJG4CT4IAJVLAY223XLF2EFANCNFSM6AAAAAAZDOAL4A. You are receiving this because you commented.Message ID: @.**@.>>
Fair enough, I am happy with the one that you have added anyway, thanks for looking at it.
The one I asked for is fairly niche but does seem to be the most common, the example in the XML docs are all based on NumberAsText, the others are even more obscure and I agree probably not worth spending time on unless specifically needed.
From: ggreen86 @.> Sent: 14 June 2023 14:23 To: ggreen86/XLSX-Workbook-Class @.> Cc: Adam Rudd @.>; Author @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Adam—
Thank you for the feedback. I actually use the official reference for spreadsheets when determining what each segment in the XML should have:
ECMA Office Open XML Part 1 - Fundamentals And Markup Language Reference (for ignored errors, see section 18.3.1.50, page 1643)
This also gives all the suppressions available for spreadsheet cells. The list Microsoft gives does not actually list the attribute names which is necessary for the segment in the sheet.xml. I considered adding all of them; but I was not sure of the need or whether they would be used. To incorporate a solution for all of them would have been a bit more complicated as each warning would have possibility of sharing the same cells or not. So in short, I took the easy way out at this time…
Greg
From: ARuddOS @.> Sent: Wednesday, June 14, 2023 4:40 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Brilliant, thanks! That works well for me for the NumberAsText warnings.
If I may suggest one tweak that may be useful, there are several warnings that can be suppressed and other users may want to suppress other types too.
This is the full list: https://learn.microsoft.com/en-us/office/vba/api/Excel.XlErrorChecks
Now I see the list I think the XlTextDate may also be useful for us where our users have entered a date in a free text field in our system. Not a biggie though, we do not suppress that one through Excel Automation at the moment.
From: ggreen86 @.<mailto:@.>> Sent: 14 June 2023 02:20 To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: Adam Rudd @.<mailto:@.>>; Author @.<mailto:@.>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Adam—
I have added a new method (SetIgnoreWarnings) to assign the ignore for a cell in Beta 4. See the Demo() method, line 174 for some examples of calling the method. Please perform some testing to set the ignore setting and let me know if it works. If you have any problems, please send an example spreadsheet for me to debug. Thank you.
Greg
From: ARuddOS @.<mailto:@.>> Sent: Tuesday, June 13, 2023 3:21 AM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: ggreen86 @.<mailto:@.>>; Comment @.<mailto:@.>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Thanks, it would be much appreciated, as is the class in general, so much quicker creating xlsx files than doing the same via Excel automation.
We are planning to use your class to create spreadsheets from our billing software, the invoice numbers are text but are predominantly numbers with leading zeros. We set the cell format to be text so that Excel shows the leading zeros, and then it is fairly niche but I personally find the little green flag on each cell with the warning to be distracting!
From: ggreen86 @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Sent: Monday, June 12, 2023 10:49 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Cc: Adam Rudd @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>; Author @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Adam—
Currently there is not a method that will set the cell to ignore the warning message. I have created a test spreadsheet with the warning set to be ignored and it does not appear to be difficult to add this feature. Cannot make any promises, but I will look into adding this for the next beta release.
Greg
From: ARuddOS @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Sent: Monday, June 12, 2023 10:08 AM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Cc: Subscribed @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Subject: [ggreen86/XLSX-Workbook-Class] Number As Text warning (Issue #88)
Hi,
I cannot see anything in the release notes that would allow the suppression of "Number As Text warnings" on cells, but that may be just because I cannot see it rather than it not being there!
Is there any way to suppress these warnings? In Excel automation it can be done cell be cell, and it has to be by cell by cell as far as I have found, this command would remove the error in cell A1:
m.oExcel = CREATEOBJECT("Excel.Application") m.oExcel.WorkBooks.Add() m.oExcel.WorkBooks(1).Sheets(1).Cells(1,1).Errors(3).Ignore=.T.
Is there an equivalent in your class please?
Thanks
Adam
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IR7P2BHSRQVDPSAPLXK4PCHANCNFSM6AAAAAAZDOAL4A. You are receiving this because you are subscribed to this thread.Message ID: @.**@.mailto:***@***.******@***.***<mailto:***@***.******@***.***%3cmailto:***@***.******@***.***>>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1588152329, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAQH5BTXJANQ7HB47PYWTXLXK6FERANCNFSM6AAAAAAZDOAL4A. You are receiving this because you authored the thread.Message ID: @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1588692593, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33LODEOMPQB64OKY7U3XLAIEXANCNFSM6AAAAAAZDOAL4A. You are receiving this because you commented.Message ID: @.**@.mailto:***@***.******@***.***>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1590289566, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAQH5BS3AVHH4X6X44XAN6DXLEGT7ANCNFSM6AAAAAAZDOAL4A. You are receiving this because you authored the thread.Message ID: @.<mailto:@.>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1590742270, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33JJG4CT4IAJVLAY223XLF2EFANCNFSM6AAAAAAZDOAL4A. You are receiving this because you commented.Message ID: @.**@.>>
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/88#issuecomment-1591202901, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BAQH5BX3AOPJMHYYCYQNIZLXLG3MLANCNFSM6AAAAAAZDOAL4A. You are receiving this because you authored the thread.Message ID: @.***>
Hi,
I cannot see anything in the release notes that would allow the suppression of "Number As Text warnings" on cells, but that may be just because I cannot see it rather than it not being there!
Is there any way to suppress these warnings? In Excel automation it can be done cell be cell, and it has to be by cell by cell as far as I have found, this command would remove the error in cell A1:
m.oExcel = CREATEOBJECT("Excel.Application") m.oExcel.WorkBooks.Add() m.oExcel.WorkBooks(1).Sheets(1).Cells(1,1).Errors(3).Ignore=.T.
Is there an equivalent in your class please?
Thanks
Adam