Alaska Software Inc. - Circular References when I remove Rows with LibXl and HBLib
Alaska Software Inc. - Circular References when I remove Rows with LibXl and HBLib
Username: Password:
AuthorTopic: Circular References when I remove Rows with LibXl and HBLib
=?UTF-8?Q?C=c3=a9sar_Calvo?= Circular References when I remove Rows with LibXl and HBLib
on Sat, 19 May 2018 22:48:33 +0200
IF I do oSheet:SheetRemoveRow(0,0)

of this methods

METHOD xlSheet:SheetRemoveCol( nColFirst, nColLast )
    LOCAL uRet := nil
    DEFAULT nColFirst TO 0
    DEFAULT nColLast TO 0
 
uRet:=FpQCall({'LibXL','xlSheetRemoveColA'},'__bo__sl__sl__sl',::hHandle,nColFirst,nColLast)
RETURN uRet

When I opne the excel file there is a message where says 'circular 
references'

Does anybody knows what is the problem and the way of solve it?

Thansk.
=?UTF-8?Q?C=c3=a9sar_Calvo?= Re: Circular References when I remove Rows with LibXl and HBLib
on Sun, 20 May 2018 08:35:56 +0200
El 19/05/2018 a las 22:48, César Calvo escribió:
> 
> IF I do oSheet:SheetRemoveRow(0,0)
> 
> of this methods
> 
> METHOD xlSheet:SheetRemoveCol( nColFirst, nColLast )
>     LOCAL uRet := nil
>     DEFAULT nColFirst TO 0
>     DEFAULT nColLast TO 0
> 
> uRet:=FpQCall({'LibXL','xlSheetRemoveColA'},'__bo__sl__sl__sl',::hHandle,nColFirst,nColLast) 
> 
> RETURN uRet
> 
> When I opne the excel file there is a message where says 'circular 
> references'
> 
> Does anybody knows what is the problem and the way of solve it?
> 
> Thansk.
> 
> 

When I delete the row MEDICIE_COPIA is made to MEDIELE where there are 
Circulars References in G37.

I don´t know why.


MEDIELE.xlsx
MEDIELE_COPIA.xlsx
Zupan Miran Re: Circular References when I remove Rows with LibXl and HBLib
on Sun, 20 May 2018 11:04:45 +0200
I delete (remove) row with this command

   oSheet:Cells:Rows(1):Delete()

Miran Zupan

---
Ta e-pošta je bila pregledana z Avast protivirusnim programom.
https://www.avast.com/antivirus
=?UTF-8?Q?C=c3=a9sar_Calvo?= Re: Circular References when I remove Rows with LibXl and HBLib
on Sun, 20 May 2018 11:57:42 +0200
El 20/05/2018 a las 11:04, Zupan Miran escribió:
> I delete (remove) row with this command
> 
>    oSheet:Cells:Rows(1):Delete()
> 
> Miran Zupan
> 
> ---
> Ta e-pošta je bila pregledana z Avast protivirusnim programom.
> https://www.avast.com/antivirus
> 

Hello Mirian.
Your code works for ActiveX of Alaska but I am trying to do that for the 
source of Hubert Brandel (HB Class for LibXL)
Do you know this source code?
Thanks.
César.
Jim LeeRe: Circular References when I remove Rows with LibXl and HBLib
on Sun, 20 May 2018 22:11:10 +0200
hi

> uRet:=FpQCall({'LibXL','xlSheetRemoveColA'},'__bo__sl__sl__sl',::hHandle,nColFirst,nColLast)

i recommend to ask Pablo at www.xbwin.com -> Newsgroup for that Syntax ...
i still have Problem with it e.g. "__bo" ?
=?UTF-8?Q?C=c3=a9sar_Calvo?= Re: Circular References when I remove Rows with LibXl and HBLib
on Sun, 20 May 2018 22:22:19 +0200
El 20/05/2018 a las 22:11, Jim Lee escribió:
> hi
> 
>> uRet:=FpQCall({'LibXL','xlSheetRemoveColA'},'__bo__sl__sl__sl',::hHandle,nColFirst,nColLast)
> 
> i recommend to ask Pablo at www.xbwin.com -> Newsgroup for that Syntax ...
> i still have Problem with it e.g. "__bo" ?
> 
> 
> 

Thanks Jim.

I will try this with Pablo, sure him help us.

He is a personal friend an a great person.

Regards.
César.
Hubert BrandelRe: Circular References when I remove Rows with LibXl and HBLib
on Tue, 22 May 2018 08:42:38 +0200
Hi,

the syntax explanation is on the dll web site:

bool removeCol(int colFirst, int colLast)
Removes columns from colFirst to colLast. Returns false if error occurs. 
Get error info with Book::errorMessage().

bool there means 0 is false,
1 (maybe <> 0) is true.
the __sl should work, but will give back a number, so the code had to as
if 0 <> uRet ...
Pablos code offers __bo so i used it.

Many compilers can just use a long with IF ... but we can't.

If you think, that the function from the dll does not work correct,
ask www.libxl.com for a check. I (my class) only translate the Xbase++ 
parameters to the lib.

I am not an excel expert and noraly don't need it.

Regards
Hubert



Am 20.05.2018 um 22:11 schrieb Jim Lee:
> hi
> 
>> uRet:=FpQCall({'LibXL','xlSheetRemoveColA'},'__bo__sl__sl__sl',::hHandle,nColFirst,nColLast)
> 
> i recommend to ask Pablo at www.xbwin.com -> Newsgroup for that Syntax ...
> i still have Problem with it e.g. "__bo" ?
> 
> 
>
César Calvo Re: Circular References when I remove Rows with LibXl and HBLib
on Tue, 22 May 2018 15:20:10 +0200
Hello Hubert, with this code the message in 
Infobox(oBook:BookErrorMessage()) is ok but see the excel
After delete Row there is circulars references.
LibXl has opened a ticket.
Regards.

oBook := xlCreateXLSXBook(cName,ckey)

oBook:BookSetKey(cName,ckey)

if oBook # NIL  LOG !
   oBook:BookSetKey(cName,cKey)
   if ! oBook:BookLoad(cFil)
      msgbox("LibXL.DLL no va","Error")
      else
      oSheet := oBook:BookGetSheet(0)

      cVal := oSheet:SheetReadStr(0,0)
      cVal := Upper(SubStr(cVal,1,6))

      oSheet:SheetRemoveRow(0,0)

      Infobox(oBook:BookErrorMessage())

      oBook:BookSave( cFil )
      oBook:destroy()
   endif

endif

"Hubert Brandel" escribió en el mensaje de 
noticias:4df55875$6336681f$3781a2@news.alaska-software.com...

Hi,

the syntax explanation is on the dll web site:

bool removeCol(int colFirst, int colLast)
Removes columns from colFirst to colLast. Returns false if error occurs.
Get error info with Book::errorMessage().

bool there means 0 is false,
1 (maybe <> 0) is true.
the __sl should work, but will give back a number, so the code had to as
if 0 <> uRet ...
Pablos code offers __bo so i used it.

Many compilers can just use a long with IF ... but we can't.

If you think, that the function from the dll does not work correct,
ask www.libxl.com for a check. I (my class) only translate the Xbase++
parameters to the lib.

I am not an excel expert and noraly don't need it.

Regards
Hubert



Am 20.05.2018 um 22:11 schrieb Jim Lee:
> hi
>
>> uRet:=FpQCall({'LibXL','xlSheetRemoveColA'},'__bo__sl__sl__sl',::hHandle,nColFirst,nColLast)
>
> i recommend to ask Pablo at www.xbwin.com -> Newsgroup for that Syntax ...
> i still have Problem with it e.g. "__bo" ?
>
>
>


MEDIELE.xlsx