質問する

arindam's profile - activity

2019-08-25 20:12:55 +0200 質問に回答する Calc: vlookup gives Err.502 though I'm sure the syntax is correct.

Error 502 occurs when you are passing incorrect/insufficient arguments to a function which it deserves. For your case, V

2019-07-24 14:18:24 +0200 質問に回答する How to enable grammar check on Libre writer?

This is a common question and lots of ask from users. This has been explained with screenshot to enable grammar check au

2019-07-15 10:43:48 +0200 質問に回答する LibreOffice requires a Java runtime environment (JRE) to perform this task. Why do I get this message and how can I fix it?

I have covered this in detail for Windows and Linux on how to fix the JRE error. https://libreofficehelp.com/how-to-fix

2019-06-18 13:12:00 +0200 質問に回答する how to change page orientation ? no help... Draw/Changing Page Orientation Landscape or Portrait

Right click on the page canvas and select Page -> Properties Or From menu, select Page -> Properties. In the Page

2019-06-18 13:02:18 +0200 編集された回答 Record a macro

Record Macro Option: From Menu: Tools -> Macros -> Record Macros. Once you click, a small window would appear whi

2019-06-18 11:56:07 +0200 質問に回答する Deinstallation Removing Files?

Uninstalling LibreOffice will not delete anything you created. But still physically take backup of all of your files to

2019-06-18 11:55:00 +0200 質問に回答する Record a macro

Record Macro Option: From Menu: Tools -> Macros -> Record Macros. Once you click, a small window would appear whi

2019-06-18 11:09:31 +0200 質問に回答する How to create a macro that will mark current location, allow movement to another page, then return to current location.

Try this - assuming you have a bookmark named "Bookmark 1" from Insert Menu -> Bookmark Sub writer_bookmark() ViewC

2019-06-17 12:31:20 +0200 コメント付き質問 How to create a macro that will mark current location, allow movement to another page, then return to current location.

Clarify where you are trying to write - Writer, Calc.... ?

2019-06-17 12:27:11 +0200 バッジを受け取った  批評家 (source)
2019-06-17 12:27:06 +0200 コメント付き回答 Can't change theme via firefox

Do not spam the community. Flagged.

2019-06-17 12:26:41 +0200 バッジを受け取った  市民パトロール (source)
2019-05-22 15:54:55 +0200 バッジを受け取った  ネクロマンサー (source)
2019-05-22 14:33:30 +0200 質問に回答する Impress presentations: Video autoplay and animation preview

Inserting videos in Impress slides covered in this article. https://libreofficehelp.com/insert-video-impress-presentati

2019-05-22 14:31:52 +0200 コメント付き回答 calc function to change the cell background color to an rgb value based on 3 cells : solved

Follow the steps on where to put the code here: http://www.debugpoint.com/2014/09/writing-a-macro-in-libreoffice-calc-ge

2018-11-28 15:41:55 +0200 バッジを受け取った  ネクロマンサー (source)
2018-09-07 15:19:14 +0200 バッジを受け取った  素晴らしい回答 (source)
2018-09-07 14:40:48 +0200 バッジを受け取った  ネクロマンサー (source)
2018-09-07 14:28:15 +0200 質問に回答する How to delete recently viewed documents from opening page?

Recent documents list you can clear entirety using below steps. Please note below steps can not be undone once cleared.

2018-08-30 17:36:57 +0200 バッジを受け取った  ネクロマンサー (source)
2018-08-30 12:22:04 +0200 質問に回答する How do I wrap text around an image

If it is for Writer - multiple options of Wrapping is available for texts. Details described with examples: https://lib

2018-08-27 09:30:04 +0200 コメント付き質問 How to duplicate last row with formulas in a macro ?

Your question is not clear. Are you saying that you want to copy the formula of "1" in Sums column (which is lowest) and

2018-08-26 13:32:23 +0200 バッジを受け取った  素晴らしい回答 (source)
2018-08-26 12:27:34 +0200 質問に回答する Repeat a given alphanumeric sequence so many times eg abcd abcd abcd in excel

Yes, it is possible. Have a look.

2018-08-26 12:23:36 +0200 質問に回答する How do I sort data in LO

Yes it is possible. have a look below.

2018-08-26 10:52:33 +0200 バッジを受け取った  ネクロマンサー (source)
2018-08-26 09:12:45 +0200 質問に回答する Show the value from a list for the adjacent cell

It can be done using VLOOKUP but you have to reformat your F column. In F column, keep only one item per row. Then, in

2018-08-26 08:55:12 +0200 質問に回答する formula for running total in calc

Here's a example and tutorial on running total column in Calc: https://libreofficehelp.com/create-running-total-column-

2018-08-26 08:54:49 +0200 質問に回答する Create cumulative sum/ running total in column

Here's a example and tutorial on running total column in Calc: https://libreofficehelp.com/create-running-total-column-

2018-08-24 12:59:53 +0200 編集された回答 calc function to change the cell background color to an rgb value based on 3 cells : solved

Try this: Tested in LO 6.x. Put your RGB values 0-255 - in A1, A2 and A3 cells respectively. Dim my_cell as object my_

2018-08-24 12:55:56 +0200 質問に回答する calc function to change the cell background color to an rgb value based on 3 cells : solved

Try this: Tested in LO 6.x. Dim my_cell as object my_cell = ThisComponent.Sheets(0).getCellByPosition(2,0) 'C1 - targe

2018-08-23 09:07:15 +0200 質問に回答する watermark writer 5

Here's how you can add a transparent bookmark in LibreOffice Writer. (Tested in LibreOffice 6.x): https://libreofficeh

2018-08-23 09:06:57 +0200 質問に回答する How to add watermark

Here's how you can add a transparent bookmark in LibreOffice Writer. (Tested in LibreOffice 6.x): https://libreofficeh

2018-08-23 09:06:13 +0200 質問に回答する how do I put a watermark in the background?

Here's how you can add a transparent bookmark in LibreOffice Writer. (Tested in LibreOffice 6.x): https://libreofficehe

2018-08-18 18:39:29 +0200 バッジを受け取った  ネクロマンサー (source)
2018-08-18 18:24:19 +0200 質問に回答する Again and again: Last Cursor position NOT saved in Writer

It is possible and working fine in LO Writer 6.1. Detailed guide is present below: https://libreofficehelp.com/how-to-s

2018-08-18 18:24:03 +0200 質問に回答する save cursor position

It is possible and working fine in LO Writer 6.1. Detailed guide is present below: https://libreofficehelp.com/how-to-s

2018-08-18 17:43:26 +0200 質問に回答する How do you draw a line in LibreOffice Draw ?

A beginner's guide on drawing different types of line in Draw - here: https://libreofficehelp.com/how-to-draw-lines-in-

2018-08-16 12:55:32 +0200 コメント付き質問 LibreOffice 6.1 crashed on my Win10 desktop

Hello Do you have any screenshot/error text of the crash ?

2018-08-15 18:14:02 +0200 質問に回答する How do I set page size in Impress

Please refer detailed steps with screenshots on how to change slide size/page size in LibreOffice Impress: https://libre

2018-06-21 06:04:12 +0200 質問に回答する Count cells with string

You can achieve it using COUNTIF or COUNTIFS. Details you can find here: https://libreofficehelp.com/count-cells-string

2018-05-29 06:18:34 +0200 質問に回答する Calc dynamic drop down list?

Read here with examples: Data validation in a single dropdown from a list of values https://libreofficehelp.com/data-v

2018-05-27 16:03:23 +0200 質問に回答する Does LibreOffice Calc have a data validation feature like Excel?

Yes. It is very much possible. Look here: https://libreofficehelp.com/data-validation-using-dropdown-list-libreoffice-c

2017-12-16 06:16:57 +0200 バッジを受け取った  素晴らしい回答 (source)
2017-10-11 05:58:51 +0200 バッジを受け取った  熱心な人
2017-10-10 07:30:07 +0200 編集された回答 Find lines with excessive word spacing in justified paragraphs

Yes. it is possible. you need to create a style from spacing section and try to find that style in the document from the

2017-10-10 07:29:55 +0200 編集された回答 Find lines with excessive word spacing in justified paragraphs

Yes. it is possible. you need to create a style from spacing section and try to find that style in the document from the

2017-10-09 11:47:21 +0200 質問に回答する Find lines with excessive word spacing in justified paragraphs

Yes. it is possible. you need to create a style from spacing section and try to find that style in the document from the

2014-09-28 18:26:12 +0200 バッジを受け取った  ネクロマンサー (source)
2014-09-28 17:59:54 +0200 質問に回答する LibreOffice Calc copy range from one workbook to another.

To get a range use this:

        my_range = ThisComponent.Sheets(0).getCellRangebyName("A1:B1")
        arr = my_range.getDataArray()

To set the value to another range:

        my_range = ThisComponent.Sheets(0).getCellRangebyName("A3:B3")
        my_range.setDataArray(arr)

Remember - the range operation should be performed in a same size of array only. In above example, A1 cell value stored in arr(0,0) and B1 is stored in arr(0,1).

Visit: http://www.debugpoint.com/category/li... for more macro tutorials.