XLSX-Workbook-Class icon indicating copy to clipboard operation
XLSX-Workbook-Class copied to clipboard

Published 20 hours ago • verified publisher icon ggreen86

Property value is out of bound

Open Esox61 opened this issue 2 years ago • 17 comments

Hi Greg! I wanted to try your program, but at the Newobject line it says: "Property value is out of bound". I tried several versions, all with the same result. Can you tell me what the solution is?

Thx: Esox

Esox61 avatar Aug 25 '23 15:08 Esox61

What are you doing to get this message? Please provide me a sample of your code that produces this problem.

Greg

From: Esox61 @.> Sent: Friday, August 25, 2023 11:27 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Subject: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)

Hi Greg! I wanted to try your program, but at the Newobject line it says: "Property value is out of bound". I tried several versions, all with the same result. Can you tell me what the solution is?

Thx: Esox

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33KHH2Q2WUI74G5MPULXXC757ANCNFSM6AAAAAA36VJL6Y. You are receiving this because you are subscribed to this thread.Message ID: @.@.>>

ggreen86 avatar Aug 25 '23 15:08 ggreen86

I tried the XLSX-Workbook-Class\Program Demos\openappendsheet.prg in Vfp8 Clipboard01 .

Esox61 avatar Aug 25 '23 16:08 Esox61

I tried the same program and it successfully opens the selected workbook with no errors and resaves it; note that I made a change to the relative path of the vcx (see below). Can you please re-run on your PC and select ‘Suspend’. Then open the Debugger and show me the program step that it has stopped at and the local variable values via a screen shot.

@.***

Greg

From: Esox61 @.> Sent: Friday, August 25, 2023 12:01 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)

I tried the XLSX-Workbook [Clipboard01]https://user-images.githubusercontent.com/58699655/263326922-b999ae35-e9f5-4d31-bf5d-3d0817534748.png -Class\Program Demos\openappendsheet.prg.

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1693583423, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33OU24ATGMIU4ZTRQ3DXXDD3JANCNFSM6AAAAAA36VJL6Y. You are receiving this because you commented.Message ID: @.@.>>

ggreen86 avatar Aug 25 '23 18:08 ggreen86

I made a change to the relative path of the vcx (see below). Sorry, but see what?

Clipboard01 Is that what you thought?

Esox61 avatar Aug 25 '23 19:08 Esox61

I think you need to change the line:

   goExcel = NEWOBJECT("VFPxWorkbookXLSX", "VFPxWorkbookXLSX.vcx")

To

   goExcel = NEWOBJECT("VFPxWorkbookXLSX", "..\VFPxWorkbookXLSX.vcx")

Greg

From: Esox61 @.> Sent: Friday, August 25, 2023 3:03 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)

I made a change to the relative path of the vcx (see below). Sorry, but see what?

[Clipboard01]https://user-images.githubusercontent.com/58699655/263366754-a1473a97-0cb1-448f-bff2-059587fefc87.png Is that what you thought?

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1693807555, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IUAL57JWOTKQ3GAVLXXDZFXANCNFSM6AAAAAA36VJL6Y. You are receiving this because you commented.Message ID: @.@.>>

ggreen86 avatar Aug 25 '23 19:08 ggreen86

I did it, but the same error message came up :( Clipboard01

Esox61 avatar Aug 25 '23 19:08 Esox61

Not sure what your problem exactly is. I still think you are having a problem with the paths. Try this at the command line:

SET PATH TO <where you have the VFPxWorkbookXLSX.vcx located> goExcel = NEWOBJECT("VFPxWorkbookXLSX", "VFPxWorkbookXLSX.vcx")

From your screen shot below, I think “<where you have the VFPxWorkbookXLSX.vcx located>” should be “c:\fox”

This should create an object goExcel that can be viewed in the Debugger. Also, you should have many cursors created that start with ‘xl_’. If this works, then at the command line try:

lnWb = goExcel.OpenXlsxWorkbook(“c:\fox\program demos\proba.xlsx”)

This will then open the workbook and fill the “xl_” cursors with the workbook information (note that the workbook must exist).

If this works, then try at the command line:

goExcel.SaveWorkbookAs(lnWb, "c:\fox\program demos\probaCopy.xlsx")

This will then save the opened workbook as a copy.

Greg

From: Esox61 @.> Sent: Friday, August 25, 2023 3:57 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)

I did it, but the same error message came up :( [Clipboard01]https://user-images.githubusercontent.com/58699655/263376839-6d344b2a-a1de-4c46-bd39-7493c843b10f.png

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1693864883, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33MH7YNQ7LB3SAZKT6TXXD7QJANCNFSM6AAAAAA36VJL6Y. You are receiving this because you commented.Message ID: @.@.>>

ggreen86 avatar Aug 25 '23 20:08 ggreen86

I did what you described. I typed in the command "set path to "c:\fox". Here is the VFPxWorkbookXLSX.vcx, which the program finds. However, it cannot create the goExcelt object, instead it gives the usual error message: Property valueis out of bounds. :(

Esox61 avatar Aug 26 '23 03:08 Esox61

I tried it on other PC, the result is same :( Which version did you try it? I use Vfp 8.

Esox61 avatar Aug 27 '23 16:08 Esox61

I tried to open the TestForm form: Clipboard02 Does this help you identify the error?

Esox61 avatar Aug 28 '23 05:08 Esox61

Hello—

I am able to open the form without an error. When I first opened it, it prompted me for the location of the workbook class – I selected the location and then the form opened as shown:

@.***

Greg

From: Esox61 @.> Sent: Monday, August 28, 2023 1:37 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)

I tried to open the TestForm form: [Clipboard02]https://user-images.githubusercontent.com/58699655/263602394-7e9ef68e-1b05-48a0-8d9c-c8a476b00969.png Does this help you identify the error?

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1695040295, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33JZFNHQQGXYCCCMFQTXXQU6JANCNFSM6AAAAAA36VJL6Y. You are receiving this because you commented.Message ID: @.@.>>

ggreen86 avatar Aug 28 '23 11:08 ggreen86

I think the version of VFP is your problem. I am using VFP9 SP2. I believe there are features in version 9 that are being used that are not available in version 8.

From: Esox61 @.> Sent: Sunday, August 27, 2023 12:24 PM To: ggreen86/XLSX-Workbook-Class @.> Cc: ggreen86 @.>; Comment @.> Subject: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)

I tried it on other PC, the result is same :( Which version did you try it? I use Vfp 8.

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1694707389, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IUOYXSEIHJO3JZEWLXXNYB7ANCNFSM6AAAAAA36VJL6Y. You are receiving this because you commented.Message ID: @.@.>>

ggreen86 avatar Aug 28 '23 11:08 ggreen86

Thank you for your answers! I'm very sad! :(

Esox61 avatar Aug 28 '23 13:08 Esox61

Hi Esox61,

VFP9 is now already 19 years old. Nineteen! Seems to me that there would have been really enuf time to recompile your stuff. Come on, give it a try! 😊

(If you really don't have a VFP9 at the office, there are several downloads floating around the Internet, and MS doesn't care about VFP)

With kind regards from Bavaria

Jürgen Wondzinski Visual FoxProhttp://www.msdn.com/vfoxpro Evangelist Microsoft "Most Valuable Professionalhttp://mvp.microsoft.com/de-de/overview.aspx" from 1996 to 2009, "Servoy Valued Professionalhttp://www.servoy.com/“ 2011 My XING Profilehttps://www.xing.com/profile/Juergen_Wondzinski, and LinkedInhttp://www.linkedin.com/in/wondzinski and Facebookhttp://www.facebook.com/juergen.wondzinski and Twitterhttp://www.twitter.com/wondzinski and….. GCS d+ s:+ a+++ C++ !U P--- L E? W++ N++ o-- K--? w+++ O? !M--? V-- PS PE !Y? !PGP t 5 X R tv- b DI+ D? G e++ h-- r+++ y+++

Von: Esox61 @.> Gesendet: Montag, 28. August 2023 15:24 An: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Betreff: Re: [ggreen86/XLSX-Workbook-Class] Property value is out of bound (Issue #98)

Thanks for your answers! I'm very sad! :(

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/98#issuecomment-1695695271, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABROXQ3ATVCM7WE5CJJ6I5LXXSLXFANCNFSM6AAAAAA36VJL6Y. You are receiving this because you are subscribed to this thread.Message ID: @.@.>>

Woody-Soft avatar Aug 29 '23 08:08 Woody-Soft

Hi Jürgen!

Yes, you are right, Vfp9 has been around for a long time. I heard at the time that there were compatibility problems between Vfp8 and Vfp9, so I didn't dare to switch. (Anyway, yesterday I installed Vfp9 as a trial, tried VFPxWorkbookXLSX.vcx and it runs under Vfp9 on my machine.)

I wish you all the best: Esox61

Esox61 avatar Aug 29 '23 09:08 Esox61

@Esox61 And have not been solved? Please tell me what are them for me to try'em. Thanks....

jhernancanom avatar Aug 29 '23 17:08 jhernancanom

@jhernancanom Greg tried to help a lot and finally the solution is to run this vcx only under Vfp9.

Esox61 avatar Aug 29 '23 18:08 Esox61