[api-dev] HTML and Spreadsheet

2005-11-16 Thread Rudolf Huber
Hello, I am trying to get the following routine with the functions HTTP and Spreadsheet to run under OOo 1.1.4. Neither the HTML- nor the CSV-filter-options function. When I look at the spreadsheet I see no link; however, when I check the menue Edit-Sheet-Select the sheet names show the LINK for

Re: [api-dev] HTML and Spreadsheet

2005-11-16 Thread Rudolf Huber
. Regards, Rudi - Original Message - From: "Niklas Nebel" <[EMAIL PROTECTED]> To: Sent: Wednesday, November 16, 2005 11:17 AM Subject: Re: [api-dev] HTML and Spreadsheet > Rudolf Huber wrote: > > I am trying to get the following routine with the functions HTTP a

[api-dev] Unanswered Request - Fw: [api-dev] HTML and Spreadsheet - BASIC

2006-02-16 Thread Rudolf Huber
help me. Have a nice week-end. Rudi - Original Message - From: "Rudolf Huber" <[EMAIL PROTECTED]> To: Sent: Wednesday, November 16, 2005 9:15 AM Subject: [api-dev] HTML and Spreadsheet > Hello, > > I am trying to get the following routine with the functions

Re: [api-dev] Unanswered Request - Fw: [api-dev] HTML and Spreadsheet - BASIC

2006-02-19 Thread Rudolf Huber
" format, > > I was not successful up-to-now. Maybe somebody can help me. > > Have a nice week-end. > > > > Rudi > > > > > > - Original Message - > > From: "Rudolf Huber" <[EMAIL PROTECTED]> > > To: > > Sent: Wedne

Re: [api-dev] answered Request - Fw: [api-dev] HTML and Spreadsheet - BASIC

2006-03-06 Thread Rudolf Huber
Hi Stephan, the message which I get always is the link could not be updated I tried various settings, including all security settings under EXTRAS-options and options under IE Version 6. I looked at the setup-procedures regarding security. I run this macro under WindowsME and Ver

Fw: [api-dev] Unanswered Request - Fw: [api-dev] HTML and Spreadsheet - BASIC

2006-03-17 Thread Rudolf Huber
Hello Stephan, unfortunately, I have to bother you again. I tried all imaginable possiblities to get the result. I went through all options om thje menue "extras" of OO1.1.4. Everytime I get the following replay in the cell: the link could not be updated This message I get up to e

Re: Fw: [api-dev] Unanswered Request - Fw: [api-dev] HTML and Spreadsheet - BASIC

2006-03-20 Thread Rudolf Huber
Hi Stephan, I really appreciate your promp reaction; here are the parameter of "tools-extras-internet": Tools-Internet-Proxy: Proxy-Server: Manuell Http-Proxy: www-proxy.t-online.de Port: 80 Ftp-Proxy:ftp-proxy.t-online.de Port: 80

[api-dev] Sort problem

2007-11-19 Thread Rudolf Huber
Hi everybody, I tried your routines for the sort. In one of the examples it said that the routines only work for small tables. How, I have a calc-table for appr. 1200 lines. How can I handles such a table. As you can see, I took your example with minorchanges: Dim oSheetDSC,oDSCRange As Ob

Re: [api-dev] Sort problem

2008-01-02 Thread Rudolf Huber
problem Hello Hubert! Where did you find this example? Am 19.11.2007 21:09 schrieb Rudolf Huber: Option Explicit Sub Sorttest() Dim oSheetDSC,oDSCRange As Object 'If you want to create typed variables you must 'declare the type of each variable: Dim oSheetDSC As Object, oDSC

[api-dev] Error exception

2008-09-14 Thread Rudolf Huber
Hallo, I have four calc tables in one program, each has 3000 rows and 30 columns. Close to the end the routine, the system throws an error execption. If I add a meaningless statement the routine ends one statement before. Can somebody help me. Thanks. Rudi

Re: [api-dev] Error exception

2008-09-15 Thread Rudolf Huber
Hi Tobias, first thanks for the very fast response. The routine works with 4 tables. The two sorts run without a problem. After table "Tabelle1", I can add three tables ("Tabelle4", "Tabelle2" and "Tabelle3", where I want to scratch double-rows). Before I want to remove the double-rows (after

Re: [api-dev] Error exception

2008-09-21 Thread Rudolf Huber
thanks again. Greetings, Rudi - Original Message - From: "Rudolf Huber" <[EMAIL PROTECTED]> To: Sent: Monday, September 15, 2008 10:18 AM Subject: Re: [api-dev] Error exception Hi Tobias, first thanks for the very fast response. The routine works with 4 table

Fw: [api-dev] Error exception

2008-09-22 Thread Rudolf Huber
Hi Tobias, I found the error. I am sorry, that I bothered you. Greetings, Rudi - Original Message - From: "Rudolf Huber" <[EMAIL PROTECTED]> To: Sent: Sunday, September 21, 2008 8:52 AM Subject: Re: [api-dev] Error exception Hi Tobias, I now can elaborate

[api-dev] New additional sheet

2008-09-24 Thread Rudolf Huber
Hallo, As you can see, I am trying to add an additional sheet to my existing table. I tried many variations as you can see below. What is the correct version to handle this case: Dim Tabelle10 As Object If oTabellenListe.hasByName("Tabelle10") Then MsgBox "Tabelle10 ist vorh

[api-dev] NumberFormats with decimals after the comma in calc-table

2008-10-08 Thread Rudolf Huber
Hallo, I tried various options to get the correct declaration for NumberFormat in calc. The LocalSetting.Language and Country is "de" for Germany. In my table I get the value before the comma correctly, however, the after comma values show zeros. Below, you see the code for the format: ZahlenF

Re: [api-dev] NumberFormats with decimals after the comma in calc-table

2008-10-08 Thread Rudolf Huber
after the comma in calc-table On 10/ 8/08 03:04 PM, Rudolf Huber wrote: I tried various options to get the correct declaration for NumberFormat in calc. The LocalSetting.Language and Country is "de" for Germany. In my table I get the value before the comma correctly, however, the aft

Re: [api-dev] NumberFormats with decimals after the comma in calc-table

2008-10-09 Thread Rudolf Huber
di - Original Message - From: "Niklas Nebel" <[EMAIL PROTECTED]> To: Sent: Wednesday, October 08, 2008 5:27 PM Subject: Re: [api-dev] NumberFormats with decimals after the comma in calc-table On 10/ 8/08 04:52 PM, Rudolf Huber wrote: first of all I thank you for the pro

Re: [api-dev] NumberFormats with decimals after the comma in calc-table

2008-10-09 Thread Rudolf Huber
- Original Message - From: "Niklas Nebel" <[EMAIL PROTECTED]> To: Sent: Thursday, October 09, 2008 11:51 AM Subject: Re: [api-dev] NumberFormats with decimals after the comma in calc-table On 10/ 9/08 09:01 AM, Rudolf Huber wrote: these are the the other

Re: [api-dev] NumberFormats with decimals after the comma in calc-table

2008-10-09 Thread Rudolf Huber
hursday, October 09, 2008 6:31 PM Subject: Re: [api-dev] NumberFormats with decimals after the comma in calc-table On 10/ 9/08 01:59 PM, Rudolf Huber wrote: I can stop the routine and look at the actual value Hoch = Val(Hoch) and get the correct result; it shows the values after the comma

[api-dev] Calc with two tables

2008-12-04 Thread Rudolf Huber
ear on the sheet. I do not know, why the macro ignores the definitions for the tables Tabelle11 und Tabelle31. Thank you in advance. Regards, Rudolf Huber

Re: [api-dev] Calc with two tables

2008-12-04 Thread Rudolf Huber
04, 2008 2:25 PM Subject: Re: [api-dev] Calc with two tables Rudolf Huber wrote: Hallo, the following sequence leads to an "indexoutofboundexception". In the beginning I have the opening statements: Dim Desktop As Object Dim Platzhalter() Dim Url As String Dim o

Re: [api-dev] Calc with two tables

2008-12-08 Thread Rudolf Huber
ment. I also tried getByName instead of getByIndex. I got the same outofboundexception.. I really appreciate your help. Regards, Rudi - Original Message - From: "Andrew Douglas Pitonyak" <[EMAIL PROTECTED]> To: Sent: Sunday, December 07, 2008 7:36 PM Subject: Re: [api

Re: [api-dev] Calc with two tables

2008-12-14 Thread Rudolf Huber
r. Have I nice week. Thank you again. Rudi - Original Message - From: "Andrew Douglas Pitonyak" To: Sent: Saturday, December 13, 2008 2:48 AM Subject: Re: [api-dev] Calc with two tables Rudolf Huber wrote: Halle Andrew, again thank you for your answer. I got twice the

[api-dev] Calc and HTML - OOo_3.2.0_Win32

2010-07-25 Thread Rudolf Huber
Hi, In calc I try to run to the following routine: sCompany = "http://"; sFilter = "HTML (StarCalc)" sOptions = "" Table.LinkMode = com.sun.star.sheet.SheetLinkMode.NONE Table.Link(sCompany, "", sFilter, sOptions, 1) The routine runs very slow. Is t

Re: [api-dev] Calc and HTML - OOo_3.2.0_Win32

2010-07-27 Thread Rudolf Huber
Hi Niklas, I will test it the coming weekend. Anyhow; thanks. Rudi - Original Message - From: "Niklas Nebel" To: Sent: Tuesday, July 27, 2010 7:51 PM Subject: Re: [api-dev] Calc and HTML - OOo_3.2.0_Win32 On 07/25/10 22:05, Rudolf Huber wrote: In calc I try to