質問する

sveno's profile - activity

2016-10-19 07:42:10 +0200 コメント付き質問 Copying data from other spreadsheet makes the pasted data hover above cells.

32bit windows 10.

2016-10-18 13:03:57 +0200 バッジを受け取った  人気の質問 (source)
2016-10-17 12:39:49 +0200 質問をする Copying data from other spreadsheet makes the pasted data hover above cells.

Libreoffice 4.35 and now 5.1. What could cause copied rows to be pasted as a hovering layer element in another Calc spreadsheet - (visibly) exactly as it would happen if I had pasted my rows into Writer. Applies to all documents. I can't even select them - all I can do is select the empty cells underneath.

2015-11-16 18:16:02 +0200 バッジを受け取った  卓越した質問 (source)
2015-11-16 18:16:02 +0200 バッジを受け取った  有名な質問 (source)
2015-10-29 11:16:08 +0200 コメント付き回答 how can I change text direction from horizontal to vertical

Are both of the options MS Office compatible?

2015-08-24 09:43:32 +0200 バッジを受け取った  人気の質問 (source)
2015-07-28 15:30:11 +0200 バッジを受け取った  有名な質問 (source)
2015-07-22 09:54:25 +0200 質問に回答する How do I sort and merge data?

You can do it with INDEX and MATCH formulas.

The third column can be merged into the second example sheet with:

=INDEX(Sheet1.B$1:B$3;MATCH(A1&".*";Sheet1.A$1:A$3;0))

INDEX will pick and show the cell you want (from the ADDRESS row)

MATCH will look for the correct row where A1 (pear* in this case) is in the first sheet.

You need to have regular expressions enabled in Tools->Options for the wildcard ".*" to work!

2015-07-22 08:49:44 +0200 質問をする How do I sort and merge data?

Lets say I have a table:

NAME            ADDRESS
apple           tree
pear            land
orange(fruit)  mountain

And another table/sheet:

NAME    CODE
pear    4556
apple   7776
orange  3321

And I want to bring the 3 different columns together in one sheet:

NAME    CODE    ADDRESS
apple   7776    tree
pear    4556    land
orange  3321    mountain

How would I do it? Can I also highlight mis-matched rows or better yet, use a wildcard so it will find "orange" from "orange(fruit)"? Thank you!

2014-01-29 16:32:31 +0200 バッジを受け取った  有名な質問 (source)
2013-12-24 13:44:42 +0200 バッジを受け取った  熱心な人
2013-12-21 20:05:18 +0200 バッジを受け取った  卓越した質問 (source)
2013-12-21 06:05:23 +0200 バッジを受け取った  人気の質問 (source)
2013-12-21 03:12:06 +0200 バッジを受け取った  人気の質問 (source)
2013-12-20 15:38:29 +0200 質問をする How to remove space before TOC (It's title)?

Here is what it looks like:

image description

Here is how I would like it to look:
image description

I.e. No space between the first line (TOC title) and the pages top margin

Both Headings, SISUKORD and SISSEJUHATUS, are the same!

2013-12-20 14:07:33 +0200 バッジを受け取った  編集者 (source)
2013-12-20 14:07:00 +0200 質問をする How to set top spacing to a heading on the first line of a page?

I need to have a set top margin for pages. I need to always start "heading 1" at a new page with a bigger top margin. However the top spacing for headings only work when there is another paragraph preceding it. It doesn't seem to work when its the first paragraph on a page. Is my only option to create 2 page styles or is there a more pleasant way?

2013-11-27 11:34:18 +0200 バッジを受け取った  学者 (source)
2013-11-27 11:09:24 +0200 バッジを受け取った  卓越した質問 (source)
2013-11-26 21:01:06 +0200 バッジを受け取った  人気の質問 (source)
2013-11-26 18:30:47 +0200 バッジを受け取った  サポーター (source)
2013-11-26 17:42:25 +0200 バッジを受け取った  生徒 (source)
2013-11-26 16:21:42 +0200 バッジを受け取った  オーガナイザー (source)
2013-11-26 16:18:22 +0200 質問をする How do I insert a new page before ToC?

I had ToC as my first page. Now I want to insert a new page before that. Ctrl+Enter just extends the ToC title to a whole page.