Ask Your Question

leeand00's profile - activity

2018-10-10 23:49:29 +0100 received badge  Famous Question (source)
2018-05-27 16:02:05 +0100 received badge  Famous Question (source)
2018-05-23 17:59:45 +0100 received badge  Notable Question (source)
2018-05-23 17:59:45 +0100 received badge  Popular Question (source)
2018-05-15 23:52:19 +0100 received badge  Famous Question (source)
2018-05-15 23:52:19 +0100 received badge  Notable Question (source)
2018-05-15 23:52:19 +0100 received badge  Popular Question (source)
2018-04-28 15:55:26 +0100 received badge  Notable Question (source)
2018-03-15 01:39:25 +0100 received badge  Notable Question (source)
2018-03-11 14:14:20 +0100 received badge  Popular Question (source)
2018-03-11 05:56:05 +0100 received badge  Popular Question (source)
2018-03-09 22:09:10 +0100 received badge  Popular Question (source)
2018-03-09 17:31:58 +0100 marked best answer Does LibreOffice Calc have a data validation feature like Excel?

I was looking at a feature in Excel that allows you to populate a dropdown combo-box with text from a range of cells;, I believe it's called data validation; is there an equivalent feature in LibreOffice Calc?

2018-03-09 15:58:20 +0100 edited question Does LibreOffice Calc have a data validation feature like Excel?

Does LibreOffice Calc have a data valiation feature like Excel? I was looking at a feature in Excel that allows you to p

2018-03-09 15:58:06 +0100 asked a question Does LibreOffice Calc have a data validation feature like Excel?

Does LibreOffice Calc have a data valiation feature like Excel? I was looking at a feature in Excel that allows you to p

2018-03-09 15:32:08 +0100 asked a question Copy to the system clipboard from a StarBasic macro in LibreOffice Calc?

Copy to the system clipboard from a StarBasic macro in LibreOffice Calc? Is it possible to copy a string to the system c

2018-03-09 13:53:16 +0100 asked a question Is it possible to assign specific style to the selected cells with a shortcut key in LibreOffice Calc?

Is it possible to assign specific style to the selected cells with a shortcut key in LibreOffice Calc? I'm working on a

2018-03-09 13:43:10 +0100 commented answer how to concatenate 12 hr time and the text "AM" or "PM"

Alright sorry, you're right...

2018-03-03 19:32:26 +0100 answered a question how to concatenate 12 hr time and the text "AM" or "PM"

Why do you want to concatenate it, when you can use a Format Code like the following on your column? M/DD/YYYY H:MM:SS

2018-01-31 06:02:43 +0100 answered a question Convert Anchor hyperlinks to references automatically?

Here's an updated version that gets the text inside the tables as well: ' Run THIS Sub Writer_Internalize_Hyperlinks_ne

2018-01-31 00:44:08 +0100 received badge  Famous Question (source)
2017-12-18 16:24:17 +0100 received badge  Notable Question (source)
2017-12-12 14:56:09 +0100 received badge  Enthusiast
2017-11-27 22:17:11 +0100 marked best answer Convert Anchor hyperlinks to references automatically?

I have an HTML document with Anchor hyperlinks in it that jump to a section on the page and back to the original source again.

I take this HTML text and paste it into LibreOffice, and then when checking the navigator all the anchor-hyperlinks are listed, but they aren't references...

I can, of course, convert these to references, one at a time, so that when I export a pdf of the document I can jump between the same spots in the document, but this process is lengthy and takes considerable time to do, the more references that I have; seeing as I'm using a computer, I'd like to automate this process if possible; are there any star-basic apis that will allow me to do this?

2017-11-27 16:59:04 +0100 asked a question Cross reference from HTML anchor to PDF document?

Cross reference from HTML anchor to PDF document? What is the most efficient way to take an HTML document that has HTML

2017-11-27 16:58:19 +0100 asked a question Cross reference from HTML anchor to PDF document?

Cross reference from HTML anchor to PDF document? What is the most efficient way to take an HTML document that has HTML

2017-11-26 22:06:14 +0100 received badge  Popular Question (source)
2017-11-25 17:47:10 +0100 asked a question Convert Anchor hyperlinks to references automatically?

Convert Anchor hyperlinks to references automatically? I have an HTML document with Anchor hyperlinks in it that jump to

2017-01-07 16:05:42 +0100 received badge  Notable Question (source)
2016-12-09 19:23:52 +0100 received badge  Popular Question (source)
2016-12-07 02:13:53 +0100 received badge  Scholar (source)
2016-12-07 00:16:57 +0100 asked a question Is there any way to paste bullets using plain text?

Is there a way to paste bullets in Writer using plain text that has been copied? I mean without having a bullet exist first?

2016-12-06 15:51:14 +0100 asked a question Drag handle fill for a selected range?

If I enter a formula into a cell such as =B1/B$41 and then grab the handle in the lower left corner and drag it down to a selected row in the same column so that subsequent cells will have =B2/B$41, =B3/B$41, =B4/B$41 etc... how can I do this auto fill automatically?

So far I've found selecting from the menu Sheet -> Fill Cells -> Series, but it doesn't fill in the formula, it only fills in the values.

2016-11-01 18:32:27 +0100 received badge  Popular Question (source)
2016-10-31 19:35:02 +0100 asked a question Why do lines specifying file extensions in writer keep getting autocorrected?

I keep coming across lines like this, that keep getting auto corrected in Writer 4.2.8.2, and I don't know what to do to stop this from happening for example:

MS-Access application files (*.mdb)

gets auto corrected to

MS-Access application filesmdb)


another example:

Workgroup Information (*.mdw) files

gets auto corrected to

Workgroup informationmdw)

2015-10-19 02:23:58 +0100 marked best answer What event on what object should I attach my GUI object retrieval code to?

I have a function that loads up references to GUI objects in a LibreOffice Base Form, and I was wondering which of these events (on the form?) I should attach it to if the rest of the code on the page depends upon references to these GUI objects.

There are many options for attaching the loading code to the form

' This method gets run when the page is loaded.
Sub Init()
  Doc = ThisComponent
  TheForm = Doc.DrawPage.Forms.GetByName("Form")

  CbBoxFeature = TheForm.getByName("CbBoxFeature")
  CbBoxDESPName = TheForm.getByName("CbBoxDESPName")
  cbUpdateToState = TheForm.getByName("cbUpdateToState")
  txtDetails = TheForm.getByName("txtDetails")
  lblStatus = TheForm.getByName("lblStatus")
End Sub

Here is my form loading code.

2015-09-09 17:45:32 +0100 received badge  Supporter (source)
2015-03-11 18:46:13 +0100 received badge  Famous Question (source)
2015-03-11 18:46:13 +0100 received badge  Notable Question (source)
2013-07-29 07:43:46 +0100 received badge  Famous Question (source)
2013-07-29 07:43:46 +0100 received badge  Notable Question (source)
2013-06-19 20:34:58 +0100 received badge  Popular Question (source)
2013-02-19 00:44:30 +0100 received badge  Student (source)
2012-12-14 16:05:45 +0100 received badge  Popular Question (source)