質問する

# librebel's profile - activity

 2019-08-09 10:56:43 +0200 バッジを受け取った ● 素晴らしい回答 (source) 2019-02-20 12:36:12 +0200 ベストアンサーマーク Request: .odb Database for own Questions and Answers on Ask.LibreOffice Hello Everybody, If you frequently answer questions here on Ask.LibreOffice ( respect! ), you often have to re-check parts of an answer that you already had given before on a previous question. Since searching for the content of a previous answer on my user profile page becomes more tedious while the list grows, i would like to store some of my questions & answers inside an .odb database on disk. Could it be, that one of my fellow frequent answerers on Ask.LibreOffice has already made such a handy .odb database, and if so, could i get a copy of it ? :D Much obliged in advance, lib 2018-08-22 21:55:45 +0200 バッジを受け取った ● 有名な質問 (source) 2018-07-27 01:03:39 +0200 バッジを受け取った ● 有名な質問 (source) 2018-06-11 11:33:16 +0200 バッジを受け取った ● 卓越した質問 (source) 2018-06-11 11:33:16 +0200 バッジを受け取った ● 人気の質問 (source) 2018-05-11 18:55:53 +0200 バッジを受け取った ● よくわかっていらっしゃる (source) 2018-05-11 18:55:53 +0200 バッジを受け取った ● 良い回答 (source) 2018-03-26 03:55:11 +0200 コメント付き回答 macro to modify autofilter in calc e.g.: Sub Calc_filter_data1() Calc_filterActiveCell( "data1” ) End Sub Then assign your keyboard shortcut to that 2018-03-26 03:54:06 +0200 コメント付き回答 macro to modify autofilter in calc Hello @newbie-01, It appears that you attempted to run the macro without passing the required parameter. According to t 2018-03-20 18:51:17 +0200 コメント付き回答 How can I customise a message box hello @ptoye, the twelfth argument passed to the Messagebox() function can be an Array of Strings containing your custom 2018-03-20 14:41:54 +0200 バッジを受け取った ● 良い回答 (source) 2018-03-20 08:15:34 +0200 コメント付き回答 Where can i find a list of property names that are supported for each UNO DispatchCommand URL? How wonderful, thank you for this great find @Mike Kaganski! This is precisely what i had been looking for. If you wou 2018-03-20 07:11:06 +0200 質問に回答する [feature-request] Highlight a phrase and with keycombo put brackets on both sides Hello @AndersFrispel, Pending the enhancement request, you could assign your own Keyboard Shortcut to a macro such as t 2018-03-20 05:43:09 +0200 コメント付き回答 How to change color or font for some part of the text in the msgbox? yes something is going wrong there with the FontDescriptor... will look into it shortly, thanks for the feedback. e.g. 2018-03-20 04:41:24 +0200 コメント付き回答 How to change color or font for some part of the text in the msgbox? YW @Ratslinger, i should really look into that matter of the font sizes... Without the aforementioned patch, does the p 2018-03-20 03:57:59 +0200 質問に回答する macro to modify autofilter in calc Having no experience in Excel, i hope i interpreted your intention correctly ... Please try if the following method prov 2018-03-19 23:42:27 +0200 コメント付き回答 Where can i find a list of property names that are supported for each UNO DispatchCommand URL? Thank you @LibreLauro, i would greatly appreciate it if you could upload the slots.sxc file either as a separate Answer 2018-03-19 21:43:36 +0200 ベストアンサーマーク Where can i find a list of property names that are supported for each UNO DispatchCommand URL? A list of UNO dispatch command URLs is published here. These command URLs can be passed to DispatchHelper.executeDispatch(). The Arguments parameter passed to this same function is an array of PropertyValues. Where can i find which Property Names/Values are allowed in the Arguments parameter for each of the DispatchCommand URLs ? 2018-03-19 20:23:48 +0200 バッジを受け取った ● 素晴らしい回答 (source) 2018-03-18 04:56:10 +0200 コメント付き回答 Changing a variable in a macro with a macro Much obliged, i used to do that for real during my sleep for a couple of years... it could be stress-related. I always a 2018-03-18 03:31:12 +0200 編集された回答 Changing a variable in a macro with a macro Hello again @ERas, i made a few adjustments to the code; the method column_SelectNext() is now the method to be connect 2018-03-18 03:29:28 +0200 質問に回答する Changing a variable in a macro with a macro Hello again @ERas, i made a few adjustments to the code; the method column_SelectNext() is now the method to be connect 2018-03-18 02:27:58 +0200 編集された回答 how to download libreOffice built-in-help Hello @eskimo64, Please see the answers for this Question. Deleting documents should be done from within your Operatin 2018-03-18 02:18:14 +0200 質問に回答する how to download libreOffice built-in-help Hello @eskimo64, Please see the answers for this Question. Deleting documents should be done from within your Operatin 2018-03-18 01:29:55 +0200 コメント付き質問 macro to modify autofilter in calc Hello @newbie-01, and welcome to LibreOffice :) Please confirm that you really mean the AutoFilter function in Calc, th 2018-03-17 17:31:17 +0200 コメント付き回答 Selecting unspecific cells in a macro incrementing the column would require another approach; please make a new question for that, with a reference to this qu 2018-03-17 15:23:11 +0200 質問に回答する cell indentification Hello @ROSt52, You could use the Excel R1C1 notation for that, see menu Tools : Options : LibreOffice Calc : Formula : 2018-03-17 15:01:46 +0200 コメント付き回答 Selecting unspecific cells in a macro yes.. Column index 0 refers to Column A, Column index 1 refers to Column B, etc. For this to work, the above macro shou 2018-03-17 05:29:35 +0200 質問に回答する Selecting unspecific cells in a macro Hello @ERas, After hiding your previous block of cells, you could just call the following Basic macro to select the nex 2018-03-16 11:41:19 +0200 コメント付き回答 Why does my URL string have its %20 change to blank? You're right @Lupp, thanks for the tip, i'll retract this answer. 2018-03-16 01:42:13 +0200 質問に回答する Why does my URL string have its %20 change to blank? Hello @Christian Pauls, When you insert the Hyperlink, it should display a dialog where you can set both the URL and th 2018-03-15 17:14:59 +0200 コメント付き回答 Is there are value for a null object in LoBasic? "What do I put here???" Nothing :) Seriously, TryCreateObject = Nothing 2018-03-15 15:21:14 +0200 バッジを受け取った ● 素晴らしい回答 (source) 2018-03-15 15:02:49 +0200 コメント付き回答 How to use R1C1 formulae in Calc macros? i updated my original answer to include a method for setting this option by macro. ( see EDIT ) 2018-03-15 14:59:22 +0200 編集された回答 How to use R1C1 formulae in Calc macros? Hello @ptoye, i reproduced this behaviour on my LibreOffice version 5.4.5.1: the option "Tools : Options : LibreOffic 2018-03-14 16:25:09 +0200 質問に回答する How to use R1C1 formulae in Calc macros? Hello @ptoye, i reproduced this behaviour on my LibreOffice version 5.4.5.1: the option "Tools : Options : LibreOffic 2018-03-13 17:04:50 +0200 コメント付き質問 not able to work with vlookup from 2 different files Hello @rao, It would help if you gave the entire formula that produced this error. Err:507 indicates a "Missing Pair"; 2018-03-12 23:37:34 +0200 質問に回答する how do I edit a hyperlink in impress? Hello @, Select the text of the hyperlink to edit, then press CTRL+K ( perhaps on a Mac this would be Command+K ... ) 2018-03-12 21:27:02 +0200 質問に回答する Need Help Please! ***Percentage Drop Down Menu*** Hello @Matt- , In cell D2, just try the formula =C2*$D$1 ( then drag the small cell handle downwards ); HTH, lib 2018-03-12 18:41:04 +0200 編集された回答 Directions for adding Smart Links in Calc don't work Hello @kejones4, It seems you followed the instructions for creating "Smart Links" from Apple.com. In LibreOffice Calc