質問する

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