Ask Your Question

arindam's profile - activity

2018-11-28 15:41:55 +0100 received badge  Necromancer (source)
2018-09-07 15:19:14 +0100 received badge  Nice Answer (source)
2018-09-07 14:40:48 +0100 received badge  Necromancer (source)
2018-09-07 14:28:15 +0100 answered a question 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 +0100 received badge  Necromancer (source)
2018-08-30 12:22:04 +0100 answered a question 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 +0100 commented question 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 +0100 received badge  Nice Answer (source)
2018-08-26 12:27:34 +0100 answered a question 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 +0100 answered a question How do I sort data in LO

Yes it is possible. have a look below.

2018-08-26 10:52:33 +0100 received badge  Necromancer (source)
2018-08-26 09:12:45 +0100 answered a question 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 +0100 answered a question 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 +0100 answered a question 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 +0100 edited answer 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 +0100 answered a question 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 +0100 answered a question 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 +0100 answered a question 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 +0100 answered a question 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 +0100 received badge  Necromancer (source)
2018-08-18 18:24:19 +0100 answered a question 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 +0100 answered a question 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 +0100 answered a question 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 +0100 commented question 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 +0100 answered a question 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 +0100 answered a question 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 +0100 answered a question 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 +0100 answered a question 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 +0100 received badge  Nice Answer (source)
2017-10-11 05:58:51 +0100 received badge  Enthusiast
2017-10-10 07:30:07 +0100 edited answer 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 +0100 edited answer 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 +0100 answered a question 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 +0100 received badge  Necromancer (source)
2014-09-28 17:59:54 +0100 answered a question 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.

2014-09-18 05:18:10 +0100 received badge  Editor (source)
2014-09-18 05:17:22 +0100 answered a question calc: open and save csv-file with given filter options

Ok. I think I have a solution for you. It took near 30 min playing around and worked finally! It tested in Ubuntu 14.04 and LO Version: 4.2.6.3.

Here it goes. I have created a simple csv file 'test.csv' with below content: image description

Now, I have edited some part of your code as below. Note in the URL section I have added "file://" in the path. Also commented out your "fileprops(1)", I think it only accepts 1 occurrence.

Sub test()
  Dim objManager As Object
  sURL = "file:///home/arindam/Documents/test.csv"
  dim fileProps(0) as new com.sun.star.beans.PropertyValue
   fileProps(0).Name = "FilterName"
   fileProps(0).Value = "Text - txt - csv (StarCalc)"
   'fileProps(1).Name = "FilterOptions"
   'fileProps(1).Value = "44,34,76,1,,0,false,true,true,false"
   starDeskTop.loadComponentFromURL(sURL, "_blank", 0,fileProps())
end sub

After I ran - here is the output: image description

I will write a detailed blogpost later in my site. I gotta sleep now, its late. Let everyone know if it worked, Cheers.

2014-09-17 09:58:44 +0100 received badge  Supporter (source)
2014-09-17 05:00:44 +0100 received badge  Necromancer (source)
2014-09-17 05:00:44 +0100 received badge  Teacher (source)
2014-09-16 19:17:18 +0100 commented question Display went haywire

Here's what I did: I figured that Unity is too heavy for my desktop configuration. Thus I installed Gnome Metacity, then it never happened again,

2014-09-16 19:14:01 +0100 answered a question How to convert Macro of VBA of MS Excel to LibreOffice Calc?

I have fairly good knowledge about VBA and did lots of works personally and professionally. I also tried macro writing in LO Calc, but man, the tutorial, materials are hard to come by.

Thus I am preparing a series of tutorials on Macro writing in LibreOffice using basic to help the entire community once and for all.

Its still work-in-progress, you can have a look here: http://www.debugpoint.com/category/pr...

2014-08-25 14:08:40 +0100 received badge  Notable Question (source)
2014-08-25 06:39:13 +0100 commented question Display went haywire

@rautamiekka - I did not try in Write or presentation.

@horst - I have nVidia card and driver is installed properly. I will check if I can get something from log.

2014-08-24 23:47:32 +0100 received badge  Popular Question (source)
2014-08-24 17:05:01 +0100 asked a question Display went haywire

So, I was working in my Ubuntu 14.04 desktop. I had Mozilla, LeafPad and Libre Office CALC was open. I did a alt-tab to get back to CALC and click on an empty cell. Then it became this. It happened multiple times. The CALC spreadsheet had only small amount of data.

Any idea?

image description