Ask Your Question

pschonmann's profile - activity

2018-09-19 07:42:26 +0100 asked a question How to remove all Text Boxes and shapetype trought navigator

How to remove all Text Boxes and shapetype trought navigator Hi ! I want delete all textboxes and shapetype ... but when

2018-04-10 10:53:14 +0100 received badge  Famous Question (source)
2017-12-06 09:40:46 +0100 received badge  Notable Question (source)
2017-07-04 11:20:03 +0100 received badge  Popular Question (source)
2017-07-04 10:12:02 +0100 commented answer Convert 2D table to single colum

Works fine, but its too long. Expected internal function in CALC, anyway, thanks.

2017-07-04 10:11:16 +0100 marked best answer Convert 2D table to single colum

Hi i have 2D Table

X1 X2 X3 X4

Y1 Y2 Y3 Y4

Z1 Z2 Z3 Z4

I want output

X1

Y1

Z1

X2

Y2

Z2

X3

Y3

Z3

How to do that without copy & paste colums. Is there any handy tool ?

2017-07-04 10:11:16 +0100 received badge  Scholar (source)
2017-07-04 08:48:46 +0100 asked a question Convert 2D table to single colum

Convert 2D table to single colum Hi i have 2D Table X1 X2 X3 X4 Y1 Y2 Y3 Y4 Z1 Z2 Z3 Z4 I want output X1 Y1 Z1

2016-03-12 21:12:05 +0100 received badge  Notable Question (source)
2015-12-09 10:10:12 +0100 received badge  Popular Question (source)
2015-12-07 14:12:26 +0100 asked a question Digital Root/Sum

Hello ! Im missing digital root and sum in libre office as function for example =DROOT(A1) =DSUM(A1) https://en.wikipedia.org/wiki/Digital...

Thank you for adding.

2015-12-05 12:49:33 +0100 received badge  Supporter (source)
2015-09-04 02:54:51 +0100 received badge  Famous Question (source)
2014-06-20 01:34:07 +0100 answered a question How can I make Calc recognise URLs in CSV files?

Autohotkey saves

Loop, 1720
{
Send {F2}
Send {Space}
Send {Enter}
Sleep 10
}
2014-06-19 10:15:13 +0100 received badge  Notable Question (source)
2014-06-18 21:59:07 +0100 received badge  Student (source)
2014-06-18 18:27:39 +0100 received badge  Popular Question (source)
2014-06-18 12:21:35 +0100 commented answer How can I make Calc recognise URLs in CSV files?

1, CSV file IS source file for import https://i.nyx.cz/files/00/00/12/07/12...

2, when opened csv dialog appears. i select "|" as delimiter and import into table. Save as ODS.

3, first column not recognized as hyperlinks, just as text. Expect conversion to clickable blue hyperlinks

2014-06-18 11:34:07 +0100 received badge  Editor (source)
2014-06-18 11:32:26 +0100 asked a question How can I make Calc recognise URLs in CSV files?

I have CSV that contains http://pastebin.com/EH8vuBe1 that text. First column is hyperlink. Not recognized as hyperlinks. When i click on A2 cell and edit ( add space at end ) clickable blue hyperlink appears. I have lots of rows in CSV, i dont do that manually. Any help, advice or is it bug ?

image description