Closed gaertner-siu closed 1 year ago
Hello—
You would need to define a format style. Use the CreateFormatStyle() method to first create a new style. This new style will allow you to add the font, borders, numeric format, etc. to the style. Then you can assign the style to any cell that you want. See the Cell Style section in the documentation for more information.
Greg
From: gaertner-siu @.> Sent: Friday, February 3, 2023 2:50 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Subject: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
I need to selectively "convert to number" in particular cells. Looking at the documentation, SetCellNumberFormat has been deprecated.
Is there a function that can be used to "convert to number" on a cell?
— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/79, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33KASPM6JZTK7U2MEYTWVVOOVANCNFSM6AAAAAAUQUGCRA. You are receiving this because you are subscribed to this thread.Message ID: @.**@.>>
Greg,
Thanks for pointing me to the CreateFormatStyle(). Using that with AddStyleNumericFormat() is working for my use case. However, I'm having a problem where opening the XLSX file and saving it:
lnWb = loExcel.OpenXlsxWorkbook(lcFile)
loExcel.SaveWorkbook(lnWb)
Is removing the header row. What is causing the header row to be removed?
Thanks, Chris
From: ggreen86 @.> Sent: Friday, February 3, 2023 4:55 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: Gaertner, Christopher J @.>; Author @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
[EXTERNAL EMAIL ALERT]: Verify sender before opening links or attachments. Hello-
You would need to define a format style. Use the CreateFormatStyle() method to first create a new style. This new style will allow you to add the font, borders, numeric format, etc. to the style. Then you can assign the style to any cell that you want. See the Cell Style section in the documentation for more information.
Greg
From: gaertner-siu @.<mailto:@.>> Sent: Friday, February 3, 2023 2:50 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: Subscribed @.<mailto:@.>> Subject: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
I need to selectively "convert to number" in particular cells. Looking at the documentation, SetCellNumberFormat has been deprecated.
Is there a function that can be used to "convert to number" on a cell?
- Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/79, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33KASPM6JZTK7U2MEYTWVVOOVANCNFSM6AAAAAAUQUGCRA. You are receiving this because you are subscribed to this thread.Message ID: @.**@.mailto:***@***.******@***.***>>
- Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fggreen86%2FXLSX-Workbook-Class%2Fissues%2F79%23issuecomment-1416502035&data=05%7C01%7Cgaertner%40siu.edu%7C180bc544094c47a7d2a508db0639be90%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638110617302433099%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=61G4uR%2BKqcwkxskv5PIv2pTsH5BZE1SQtU0ddSnORbU%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FADBBZNHU2F5KACQYFSVYVXDWVWEF7ANCNFSM6AAAAAAUQUGCRA&data=05%7C01%7Cgaertner%40siu.edu%7C180bc544094c47a7d2a508db0639be90%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638110617302433099%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=8ir5RAnzTIvOqxog2GW04CM%2F%2BVELYDyASgCAnPhnCmA%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>>
Chris
I tried to duplicate the problem and I am not able to. I created a test spreadsheet with 3 columns and 5 rows with text and values in the cells. I then opened the spreadsheet with the class and immediately saved it. The saved version is the same as the original – the header row is not missing. Are you using the latest version of the class? If your problem still persists, can you send me the workbook that is causing the problem? Thank you.
Greg
From: gaertner-siu @.> Sent: Wednesday, February 8, 2023 11:27 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
Greg,
Thanks for pointing me to the CreateFormatStyle(). Using that with AddStyleNumericFormat() is working for my use case. However, I'm having a problem where opening the XLSX file and saving it:
lnWb = loExcel.OpenXlsxWorkbook(lcFile) loExcel.SaveWorkbook(lnWb)
Is removing the header row. What is causing the header row to be removed?
Thanks, Chris
From: ggreen86 @.<mailto:@.>> Sent: Friday, February 3, 2023 4:55 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: Gaertner, Christopher J @.<mailto:@.>>; Author @.<mailto:@.>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
[EXTERNAL EMAIL ALERT]: Verify sender before opening links or attachments. Hello-
You would need to define a format style. Use the CreateFormatStyle() method to first create a new style. This new style will allow you to add the font, borders, numeric format, etc. to the style. Then you can assign the style to any cell that you want. See the Cell Style section in the documentation for more information.
Greg
From: gaertner-siu @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Sent: Friday, February 3, 2023 2:50 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Cc: Subscribed @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Subject: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
I need to selectively "convert to number" in particular cells. Looking at the documentation, SetCellNumberFormat has been deprecated.
Is there a function that can be used to "convert to number" on a cell?
- Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/79, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33KASPM6JZTK7U2MEYTWVVOOVANCNFSM6AAAAAAUQUGCRA. 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://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fggreen86%2FXLSX-Workbook-Class%2Fissues%2F79%23issuecomment-1416502035&data=05%7C01%7Cgaertner%40siu.edu%7C180bc544094c47a7d2a508db0639be90%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638110617302433099%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=61G4uR%2BKqcwkxskv5PIv2pTsH5BZE1SQtU0ddSnORbU%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FADBBZNHU2F5KACQYFSVYVXDWVWEF7ANCNFSM6AAAAAAUQUGCRA&data=05%7C01%7Cgaertner%40siu.edu%7C180bc544094c47a7d2a508db0639be90%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638110617302433099%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=8ir5RAnzTIvOqxog2GW04CM%2F%2BVELYDyASgCAnPhnCmA%3D&reserved=0. 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/79#issuecomment-1422895517, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33JPNPSRSDRVJMZQVCTWWPCMPANCNFSM6AAAAAAUQUGCRA. You are receiving this because you commented.Message ID: @.**@.>>
Greg,
I've attached 3 files: the DBF source file, the #1 Excel version after the following code executes:
lcTable = 'i:\appdev\icss\billing\bill_xl_file.dbf'
lcFile = 'i:\appdev\icss\billing\'+DTOC(m.run_date,1)+'_'+ALLTRIM(su_list.desc)+'_bill_entries.xlsx'
loExcel = NEWOBJECT("VFPxWorkbookXLSX", "C:\CM75\Thor\Thor\Tools\Components\XLSX Workbook\VFPxWorkbookXLSX.vcx")
lnWb = loExcel.SaveTabletoWorkbook(lcTable, lcFile, .T., .T.)
RELEASE loExcel
And then the #2 Excel version (with the headers missing) after the following code executes immediately after:
loExcel = NEWOBJECT("VFPxWorkbookXLSX", "C:\CM75\Thor\Thor\Tools\Components\XLSX Workbook\VFPxWorkbookXLSX.vcx")
lnWb = loExcel.OpenXlsxWorkbook(lcFile)
loExcel.SaveWorkbook(lnWb)
RELEASE loExcel
Thanks, Chris
From: ggreen86 @.> Sent: Saturday, February 11, 2023 10:41 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: Gaertner, Christopher J @.>; Author @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
[EXTERNAL EMAIL ALERT]: Verify sender before opening links or attachments. Chris
I tried to duplicate the problem and I am not able to. I created a test spreadsheet with 3 columns and 5 rows with text and values in the cells. I then opened the spreadsheet with the class and immediately saved it. The saved version is the same as the original - the header row is not missing. Are you using the latest version of the class? If your problem still persists, can you send me the workbook that is causing the problem? Thank you.
Greg
From: gaertner-siu @.<mailto:@.>> Sent: Wednesday, February 8, 2023 11:27 AM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: ggreen86 @.<mailto:@.>>; Comment @.<mailto:@.>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
Greg,
Thanks for pointing me to the CreateFormatStyle(). Using that with AddStyleNumericFormat() is working for my use case. However, I'm having a problem where opening the XLSX file and saving it:
lnWb = loExcel.OpenXlsxWorkbook(lcFile) loExcel.SaveWorkbook(lnWb)
Is removing the header row. What is causing the header row to be removed?
Thanks, Chris
From: ggreen86 @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Sent: Friday, February 3, 2023 4:55 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Cc: Gaertner, Christopher J @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>; Author @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
[EXTERNAL EMAIL ALERT]: Verify sender before opening links or attachments. Hello-
You would need to define a format style. Use the CreateFormatStyle() method to first create a new style. This new style will allow you to add the font, borders, numeric format, etc. to the style. Then you can assign the style to any cell that you want. See the Cell Style section in the documentation for more information.
Greg
From: gaertner-siu @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***>>> Sent: Friday, February 3, 2023 2:50 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***>>> Cc: Subscribed @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***>>> Subject: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
I need to selectively "convert to number" in particular cells. Looking at the documentation, SetCellNumberFormat has been deprecated.
Is there a function that can be used to "convert to number" on a cell?
- Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/79, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33KASPM6JZTK7U2MEYTWVVOOVANCNFSM6AAAAAAUQUGCRA. You are receiving this because you are subscribed to this thread.Message ID: @.**@.mailto:***@***.******@***.***<mailto:***@***.******@***.***%3cmailto:***@***.******@***.***<mailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***>>>>
- Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fggreen86%2FXLSX-Workbook-Class%2Fissues%2F79%23issuecomment-1416502035&data=05%7C01%7Cgaertner%40siu.edu%7C180bc544094c47a7d2a508db0639be90%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638110617302433099%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=61G4uR%2BKqcwkxskv5PIv2pTsH5BZE1SQtU0ddSnORbU%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FADBBZNHU2F5KACQYFSVYVXDWVWEF7ANCNFSM6AAAAAAUQUGCRA&data=05%7C01%7Cgaertner%40siu.edu%7C180bc544094c47a7d2a508db0639be90%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638110617302433099%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=8ir5RAnzTIvOqxog2GW04CM%2F%2BVELYDyASgCAnPhnCmA%3D&reserved=0. 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/79#issuecomment-1422895517, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33JPNPSRSDRVJMZQVCTWWPCMPANCNFSM6AAAAAAUQUGCRA. You are receiving this because you commented.Message ID: @.**@.mailto:***@***.******@***.***>>
- Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fggreen86%2FXLSX-Workbook-Class%2Fissues%2F79%23issuecomment-1426818756&data=05%7C01%7Cgaertner%40siu.edu%7C8425de74eb5d444c00f408db0c4ecb58%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638117304811094962%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nSbHTFtvtVcWMCV%2B1AB25FzHAhZfEY8Bcx4IRokU5P4%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FADBBZNAZD3Y7IAKHMDZISA3WW66KXANCNFSM6AAAAAAUQUGCRA&data=05%7C01%7Cgaertner%40siu.edu%7C8425de74eb5d444c00f408db0c4ecb58%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638117304811094962%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=QImbZ9sVgSfCfYP8jsPN4TIdmBuwPmWQkh7eyLFvTTk%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>>
Chris--
The attachments are not making it through. Please try to anduril58 hotmail com thank you.
Greg
Chris—
Looking at the file, the first row (header) is actually being saved to the copy. However, the setting frozen split to keep the header at the top is what is causing the issue. If the Freeze Pane and Split is reset (removed) then the first row appears. The problem is with the internal setting for the freeze top row – using “frozenSplit” rather than “frozen”. I am now testing to ensure that this will fix the issue and not create another issue when setting the freeze.
Thank you.
Greg
From: gaertner-siu @.> Sent: Monday, February 13, 2023 10:16 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
Greg,
I've attached 3 files: the DBF source file, the #1 Excel version after the following code executes:
lcTable = 'i:\appdev\icss\billing\bill_xl_file.dbf' lcFile = 'i:\appdev\icss\billing\'+DTOC(m.rundate,1)+''+ALLTRIM(su_list.desc)+'_bill_entries.xlsx' loExcel = NEWOBJECT("VFPxWorkbookXLSX", "C:\CM75\Thor\Thor\Tools\Components\XLSX Workbook\VFPxWorkbookXLSX.vcx") lnWb = loExcel.SaveTabletoWorkbook(lcTable, lcFile, .T., .T.) RELEASE loExcel
And then the #2 Excel version (with the headers missing) after the following code executes immediately after:
loExcel = NEWOBJECT("VFPxWorkbookXLSX", "C:\CM75\Thor\Thor\Tools\Components\XLSX Workbook\VFPxWorkbookXLSX.vcx") lnWb = loExcel.OpenXlsxWorkbook(lcFile) loExcel.SaveWorkbook(lnWb) RELEASE loExcel
Thanks, Chris
From: ggreen86 @.<mailto:@.>> Sent: Saturday, February 11, 2023 10:41 AM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.>> Cc: Gaertner, Christopher J @.<mailto:@.>>; Author @.<mailto:@.>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
[EXTERNAL EMAIL ALERT]: Verify sender before opening links or attachments. Chris
I tried to duplicate the problem and I am not able to. I created a test spreadsheet with 3 columns and 5 rows with text and values in the cells. I then opened the spreadsheet with the class and immediately saved it. The saved version is the same as the original - the header row is not missing. Are you using the latest version of the class? If your problem still persists, can you send me the workbook that is causing the problem? Thank you.
Greg
From: gaertner-siu @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Sent: Wednesday, February 8, 2023 11:27 AM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Cc: ggreen86 @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>; Comment @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
Greg,
Thanks for pointing me to the CreateFormatStyle(). Using that with AddStyleNumericFormat() is working for my use case. However, I'm having a problem where opening the XLSX file and saving it:
lnWb = loExcel.OpenXlsxWorkbook(lcFile) loExcel.SaveWorkbook(lnWb)
Is removing the header row. What is causing the header row to be removed?
Thanks, Chris
From: ggreen86 @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***>>> Sent: Friday, February 3, 2023 4:55 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***>>> Cc: Gaertner, Christopher J @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***>>>; Author @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***>>> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
[EXTERNAL EMAIL ALERT]: Verify sender before opening links or attachments. Hello-
You would need to define a format style. Use the CreateFormatStyle() method to first create a new style. This new style will allow you to add the font, borders, numeric format, etc. to the style. Then you can assign the style to any cell that you want. See the Cell Style section in the documentation for more information.
Greg
From: gaertner-siu @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***>>>> Sent: Friday, February 3, 2023 2:50 PM To: ggreen86/XLSX-Workbook-Class @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***>>>> Cc: Subscribed @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***<mailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***%3cmailto:***@***.***>>>> Subject: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
I need to selectively "convert to number" in particular cells. Looking at the documentation, SetCellNumberFormat has been deprecated.
Is there a function that can be used to "convert to number" on a cell?
- Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/79, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33KASPM6JZTK7U2MEYTWVVOOVANCNFSM6AAAAAAUQUGCRA. You are receiving this because you are subscribed to this thread.Message ID: @.**@.mailto:***@***.******@***.***<mailto:***@***.******@***.***%3cmailto:***@***.******@***.***<mailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***<mailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***>>>>>
- Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fggreen86%2FXLSX-Workbook-Class%2Fissues%2F79%23issuecomment-1416502035&data=05%7C01%7Cgaertner%40siu.edu%7C180bc544094c47a7d2a508db0639be90%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638110617302433099%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=61G4uR%2BKqcwkxskv5PIv2pTsH5BZE1SQtU0ddSnORbU%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FADBBZNHU2F5KACQYFSVYVXDWVWEF7ANCNFSM6AAAAAAUQUGCRA&data=05%7C01%7Cgaertner%40siu.edu%7C180bc544094c47a7d2a508db0639be90%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638110617302433099%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=8ir5RAnzTIvOqxog2GW04CM%2F%2BVELYDyASgCAnPhnCmA%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.mailto:***@***.******@***.***<mailto:***@***.******@***.***%3cmailto:***@***.******@***.***<mailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***%3cmailto:***@***.******@***.***>>>>
- Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/79#issuecomment-1422895517, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33JPNPSRSDRVJMZQVCTWWPCMPANCNFSM6AAAAAAUQUGCRA. You are receiving this because you commented.Message ID: @.**@.mailto:***@***.******@***.***<mailto:***@***.******@***.***%3cmailto:***@***.******@***.***>>>
- Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fggreen86%2FXLSX-Workbook-Class%2Fissues%2F79%23issuecomment-1426818756&data=05%7C01%7Cgaertner%40siu.edu%7C8425de74eb5d444c00f408db0c4ecb58%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638117304811094962%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nSbHTFtvtVcWMCV%2B1AB25FzHAhZfEY8Bcx4IRokU5P4%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FADBBZNAZD3Y7IAKHMDZISA3WW66KXANCNFSM6AAAAAAUQUGCRA&data=05%7C01%7Cgaertner%40siu.edu%7C8425de74eb5d444c00f408db0c4ecb58%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638117304811094962%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=QImbZ9sVgSfCfYP8jsPN4TIdmBuwPmWQkh7eyLFvTTk%3D&reserved=0. 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/79#issuecomment-1428118588, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33KYSUCADIP2LTXNDGDWXJF4TANCNFSM6AAAAAAUQUGCRA. You are receiving this because you commented.Message ID: @.**@.>>
The issue with the missing row (first row) was due to the freeze row method in creating the initial workbook. When the workbook was read in, the setting for the freeze row command (split) was causing the row to be masked; the row was still there and not missing but you could not see it due to the split. This has been fixed now in Release 35.
Greg,
I can confirm R35 fixes the issue.
Thanks! Chris
From: ggreen86 @.> Sent: Monday, February 13, 2023 2:13 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: Gaertner, Christopher J @.>; Author @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Convert to number? (Issue #79)
[EXTERNAL EMAIL ALERT]: Verify sender before opening links or attachments.
- Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fggreen86%2FXLSX-Workbook-Class%2Fissues%2F79%23event-8508484549&data=05%7C01%7Cgaertner%40siu.edu%7C49a2145b4ee641471fc908db0dfeb9db%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638119159924621533%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=icjMsxOq4Pb5tRCDU99EOcah5d6iBQCuK6q8L3eOpGk%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FADBBZNDWOUEVU655OH2JNI3WXKIVJANCNFSM6AAAAAAUQUGCRA&data=05%7C01%7Cgaertner%40siu.edu%7C49a2145b4ee641471fc908db0dfeb9db%7Cd57a98e7744d43f9bc9108de1ff3710d%7C0%7C0%7C638119159924621533%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=B9FeQ5nJllbilFw%2F%2BxwHDzVXqASGIa5KANnhCU9eclo%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>>
I need to selectively "convert to number" in particular cells. Looking at the documentation, SetCellNumberFormat has been deprecated.
Is there a function that can be used to "convert to number" on a cell?