Ask Your Question

Thomaxz2's profile - activity

2017-03-14 13:32:53 +0100 received badge  Famous Question (source)
2017-03-14 13:32:53 +0100 received badge  Notable Question (source)
2016-09-09 11:16:30 +0100 received badge  Famous Question (source)
2016-09-09 11:16:30 +0100 received badge  Notable Question (source)
2016-05-28 21:24:53 +0100 received badge  Popular Question (source)
2016-03-19 16:49:05 +0100 received badge  Popular Question (source)
2016-03-13 15:24:56 +0100 commented answer Copy a table cell and the cell background color

That semi work, I can get the background color to the new cell, but still need to copy the content on its own.

2016-03-13 13:50:59 +0100 received badge  Editor (source)
2016-03-13 12:15:29 +0100 asked a question Copy a table cell and the cell background color

In Libreoffice writer, I have a table, I have for some cells selected a backgroundcolor through right click->properties->background color which works fine.

Now I want to copy a cell, I click ctrl-c and then ctrl+v. But only the content of the cell is copied not the background.

I have also tried Table->Chosse->Cell and then ctrl+c+ctrl+v And also tried the menu copy and menu paste.

But al result is that only the content is copied, not the background color.

Update: to try first answering

But paste special format, does neither work, does not giving expected resultat, insted a weird looking cell inside the cell.

image description

2016-03-13 12:09:13 +0100 answered a question Select whole line with macro

By record a macro, with selection throug keyboard and not mouse, I have success

The solutons be this code

   rem ----------------------------------------------------------------------
rem define variables
dim document   as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem ----------------------------------------------------------------------
dispatcher.executeDispatch(document, ".uno:GoToEndOfLine", "", 0, Array())

rem ----------------------------------------------------------------------
dispatcher.executeDispatch(document, ".uno:StartOfLineSel", "", 0, Array())

rem All Caps
2016-02-24 15:33:10 +0100 asked a question Select whole line with macro

How can I select the whole line, where the cursors is via macro, so I can manipulate it via macro?

I'am trying to write a macro in Libre Office Wirter, so far it went no problem, but can't figure out how you would tell writer via macro, to select the whole line.