Re: Link automatisiert erzeugen
Am 04.07.2014 13:11, schrieb Boris Kirkorowicz: Hallo, aus einer Liste übernehme ich per CP u.a. auch IDs, die ich zur Bildung von URLs nutze, also etwa so: ID: 123456 URL: http://server.doain.tld/?query=123456 Bislang mache ich das manuell mit viel Kopiererei und Gewühle durch die Menüpunkte und Dialoge. Wie kann man das vereinfachen, am liebsten so weit wie möglich automatisieren? Ich gehe mal davon aus, daß Du von Calc redest: A1 = http://server.doain.tld/?query= A2 = 123450 A3 = 123451 A4 = 123452 A5 = 123453 A6 = 123454 A7 = 123455 A8 = 123456 : B2 = =HYPERLINK($A$1A2;$A$1A2) B3 = =HYPERLINK($A$1A3;$A$1A3) B4 = =HYPERLINK($A$1A4;$A$1A4) B5 = =HYPERLINK($A$1A5;$A$1A5) : Wolfgang -- - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: Link automatisiert erzeugen
Hallo Boris, wenn Du von Writer oder Calc sprichst: Werden sie soweit ich weiß in der Grundeinstellung automatisch gesetzt, wenn http:// erkannt wird von dem Programm oder für writer weiß ich es nicht, oder Calc - Einfügen - Hyperlink, da geht eine Box auf in der Du eintragen kannst, was im Text stehen soll und wohin der Link gehen soll. Ich habe es nicht weiter automatisiert. Gruß Christian Am 04.07.2014 13:11, schrieb Boris Kirkorowicz: Hallo, aus einer Liste übernehme ich per CP u.a. auch IDs, die ich zur Bildung von URLs nutze, also etwa so: ID: 123456 URL:http://server.doain.tld/?query=123456 Bislang mache ich das manuell mit viel Kopiererei und Gewühle durch die Menüpunkte und Dialoge. Wie kann man das vereinfachen, am liebsten so weit wie möglich automatisieren? - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Absurd thing about macro security
I did a fresh install of my operating system a couple of weeks ago, so I now run Apache OpenOffice on Ubuntu 14.04 rather than Ubuntu 12.04. Anyway, one of the first things I did, was to throw LibreOffice out the window and install Apache OpenOffice. There are a few spreadsheets that I edit every day, almost, and the first thing I experience after a fresh operating system install is usually that I need to add macro paths to the macro security paths list. I usually add them one by one when I need them and for now I only need to run macros in spreadsheets at ”~/Kontor/Ekonomi/” (in English: ~/Office/Economy/). However, to open those spreadsheets I click on a link located in a folder on my desktop, ”~/Skrivbord/Frekvent använt/” (in English: ”~/Desktop/Frequently used/”). All I did so far was that I added the ”~/Kontor/Ekonomi/” path to the macro security list thing, and it worked perfectly for those weeks. Until today. Now, when opening one of those spreadsheets, it says that it won't run any of my macros. So now I just gave up and added ”~/Skrivbord/Frekvent använt/” and Apache OpenOffice seemt to be happy with that. But why, WHY, WHY, WHY did it work before today? I've been opening those links all the time since I put them there, without any kinds of problems! The only thing that is different now from before, is that I moved my computer a few meters and that I use two screens instead of one now. How could that matter? Best regards Johnny Rosenberg
Re: Absurd thing about macro security
Can you tell us what does ur macro actually do? Most of these settings are declared on the XCU whicch are XML. The schema could have changed or something along those lines like the path on the ~/.openoffice/ folder. However maybe you run your macros within AOO which could be a different service, so until we dont get that information we cant tell which change could have an effect on your macro. On 7/5/14, Johnny Rosenberg gurus.knu...@gmail.com wrote: I did a fresh install of my operating system a couple of weeks ago, so I now run Apache OpenOffice on Ubuntu 14.04 rather than Ubuntu 12.04. Anyway, one of the first things I did, was to throw LibreOffice out the window and install Apache OpenOffice. There are a few spreadsheets that I edit every day, almost, and the first thing I experience after a fresh operating system install is usually that I need to add macro paths to the macro security paths list. I usually add them one by one when I need them and for now I only need to run macros in spreadsheets at ”~/Kontor/Ekonomi/” (in English: ~/Office/Economy/). However, to open those spreadsheets I click on a link located in a folder on my desktop, ”~/Skrivbord/Frekvent använt/” (in English: ”~/Desktop/Frequently used/”). All I did so far was that I added the ”~/Kontor/Ekonomi/” path to the macro security list thing, and it worked perfectly for those weeks. Until today. Now, when opening one of those spreadsheets, it says that it won't run any of my macros. So now I just gave up and added ”~/Skrivbord/Frekvent använt/” and Apache OpenOffice seemt to be happy with that. But why, WHY, WHY, WHY did it work before today? I've been opening those links all the time since I put them there, without any kinds of problems! The only thing that is different now from before, is that I moved my computer a few meters and that I use two screens instead of one now. How could that matter? Best regards Johnny Rosenberg -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org