질문하기

Adobe's profile - activity

2019-05-26 22:27:53 +0200 받은 배지  유명한 질문 (source)
2019-05-26 22:27:53 +0200 받은 배지  주목할 만한 질문 (source)
2019-05-26 22:27:53 +0200 받은 배지  인기있는 질문 (source)
2019-01-25 12:48:43 +0200 코멘트달린 답변 How to keep I% together

I have "No-width no break" available even with no CTL enabled.

2018-06-03 16:47:28 +0200 코멘트달린 답변 Find-replace at the beginning of each cell?

Thanks, it works. But isn't it weird? One can use an end-of-line anchor directly, $, but for beginning of line one must

2018-06-03 16:47:28 +0200 받은 배지  논객
2018-06-03 16:45:37 +0200 으뜸 답변으로 표시됨 Find-replace at the beginning of each cell?

How do I match a beginning of the cell in find-replace dialog of Calc?

In regexp mode, I'd expect ^ to match that, but it does not work:

image description

The doc does not give any hints: https://help.libreoffice.org/Common/L...

2018-06-03 16:08:18 +0200 질문에 댓글을 달았습니다 Find-replace at the beginning of each cell?

@MikeKaganski: I've just added a screenshot.

2018-06-03 16:07:45 +0200 질문을 편집했습니다 Find-replace at the beginning of each cell?

Find-replace at the beginning of each cell? How do I match a beginning of the cell in find-replace dialog of Calc? In r

2018-06-03 11:11:58 +0200 질문하였습니다 Find-replace at the beginning of each cell?

Find-replace at the beginning of each cell? How do I match a beginning of the cell in find-replace dialog of Calc? In r

2016-11-21 13:44:05 +0200 받은 배지  유명한 질문 (source)
2016-11-21 13:44:05 +0200 받은 배지  주목할 만한 질문 (source)
2016-07-21 15:17:14 +0200 받은 배지  개근상
2016-07-19 23:20:33 +0200 코멘트달린 답변 How to use math functions in the Calc Basic?

Thanks. The example you linked is more of a [currying])(https://en.wikipedia.org/wiki/Currying) though.

2016-07-19 23:16:55 +0200 코멘트달린 답변 How to use math functions in the Calc Basic?

Here's a list of most used math functions: atn/sin/cos/tan/exp/log/sqr/abs plus a constant Pi. Source.

2016-07-19 23:06:48 +0200 코멘트달린 답변 Can we use regular spreadsheet functions in Basic functions?

This is more of a currying than a function.

2016-07-19 22:50:53 +0200 코멘트달린 답변 How to use math functions in the Calc Basic?

PI() is not available but Pi works: ARCTAN = atn(rad) * 180 / Pi. Thanks!

2016-07-19 22:41:42 +0200 받은 배지  인기있는 질문 (source)
2016-07-19 18:17:44 +0200 받은 배지  오거나이저 (source)
2016-07-19 18:15:03 +0200 질문하였습니다 How to use math functions in the Calc Basic?

The documentations shows how to implement a basic VOL function:

Function VOL(a, b, c)
VOL = a*b*c
End Function

So that I can write

=VOL(1,2,3)

in a spreadsheet and get 6.

I want to write arctan which would return result in degrees instead of radians:

Function ARCTAN(rad)
ARCTAN = ATAN(rad)*180/PI()
End Function

and call it as, e.g.:

=ARCTAN(1)

This doesn't work: Calc complains:

Sub-procedure or function procedure not defined

Can you help me to write this function?

2016-02-18 11:28:39 +0200 으뜸 답변으로 표시됨 Conditional text based on form value?

I have a form and I want to have a string which depends on the current state of the form:

image description

Here's a property of conditional text:

image description

And here's a property of the form:

image description

I want the text which would be dependant on the form state (one, two or three).

I also attach sample odt file.

2015-02-27 09:51:19 +0200 코멘트달린 답변 If only LO Writer table could allow copy paste of formula?

Works well under Kubuntu 14.04, LO 4.2.7.2 too. When saving to doc formulas are lost.

2014-03-18 16:55:51 +0200 받은 배지  주목할 만한 질문 (source)
2014-03-18 16:55:51 +0200 받은 배지  인기있는 질문 (source)
2014-03-18 16:55:51 +0200 받은 배지  유명한 질문 (source)
2014-02-22 10:32:03 +0200 받은 배지  인기있는 질문 (source)
2014-02-22 10:32:03 +0200 받은 배지  주목할 만한 질문 (source)
2014-02-22 10:32:03 +0200 받은 배지  유명한 질문 (source)
2014-01-28 14:26:39 +0200 질문에 답변하였습니다 How to insert a Formula/Math?

Input "fn" then press F3. See a centered numbered stab for a math formula appear. See autotext for details.

2014-01-23 10:31:24 +0200 코멘트달린 답변 Conditional text based on form value?

Thanks. I'll try to work through it.

2014-01-06 22:27:21 +0200 받은 배지  유명한 질문 (source)
2013-11-01 10:19:33 +0200 받은 배지  선생님 (source)
2013-11-01 10:19:33 +0200 받은 배지  족집게 도사 (source)
2013-11-01 05:57:19 +0200 질문에 답변하였습니다 Cursor blink

On KDE system, I was able to stop cursor blinking using qtconfig: Interfaces -> Flash time -> scroll down til you hit No blinking. I did it as a user and as a root (not sure which is sufficient).

For a gnome desktop, there's an advice:

$ gconftool-2 --set /desktop/gnome/interface/cursor_blink --type boolean False
$ gconftool-2 --set /apps/gnome-terminal/profiles/Default/cursor_blink --type boolean False
$ gconftool-2 --set /apps/gnome-terminal/profiles/Default/cursor_blink_mode --type string off
2013-10-01 19:54:47 +0200 으뜸 답변으로 표시됨 Calc: make cell red if the value is above given?

I tried:

=STYLE(IF(B3>3,"Red","Green"))

but it gives 0 ???

2013-10-01 19:27:26 +0200 으뜸 답변으로 표시됨 Table: Default spacing to contents?

How do I set the value of default spacing of contents -- in a writer template?

image description

(I don't have enough repo to upload it here).