질문하기

flywire's profile - activity

2021-01-28 10:45:11 +0100 받은 배지  유명한 질문 (source)
2021-01-27 23:06:14 +0100 질문을 편집했습니다 Display Flowchart Toolbar

Access Flowchart Flowchart To access this command...Flowcharts Click an icon from the Flowchart toolbar, then d

2021-01-27 23:03:42 +0100 코멘트달린 답변 Display Flowchart Toolbar

Big thank you, docked rather than floating but you covered that too. I still don't understand why it's not available as

2021-01-27 22:52:15 +0100 으뜸 답변으로 표시됨 Display Flowchart Toolbar

Flowchart

To access this command...Flowcharts

Click an icon from the Flowchart toolbar, then drag in the document to draw the shape.

How? You'd expect View, Toolbars would have Flowcharts listed.

V7.0.4.2 Win10, Any module, I'm using Draw

2021-01-27 22:51:48 +0100 질문에 댓글을 달았습니다 Display Flowchart Toolbar

When I clicked help it took me straight to the help in writer. I'm fairly sure it is a common module.

2021-01-27 10:18:01 +0100 받은 배지  주목할 만한 질문 (source)
2021-01-27 09:37:50 +0100 코멘트달린 답변 Display Flowchart Toolbar

"Creating a Flowchart:" links to https://help.libreoffice.org/7.0/en-US/text/simpress/guide/orgchart.html?&DbPAR=WRI

2021-01-26 11:25:30 +0100 받은 배지  인기있는 질문 (source)
2021-01-26 08:15:12 +0100 코멘트달린 답변 Display Flowchart Toolbar

@Ratslinger my point is I'd expect to be able to enable (View, Toolbars) any of those dropdown toolbars on the draw bar

2021-01-26 04:01:05 +0100 질문에 답변하였습니다 Display Flowchart Toolbar

Hopefully no the real answer, but it is possible to add to another toolbar: Adding Buttons to Toolbars

2021-01-26 03:42:13 +0100 질문하였습니다 Display Flowchart Toolbar

Access Flowchart Flowchart To access this command...Flowcharts Click an icon from the Flowchart toolbar, then d

2020-12-24 08:23:37 +0100 코멘트달린 답변 how do i rotate page for printing

It's a pretty useless answer. How do you rotate a page in a Writer document?

2020-10-28 10:11:45 +0100 받은 배지  유명한 질문 (source)
2020-08-30 02:11:31 +0100 받은 배지  유명한 질문 (source)
2020-07-29 12:05:41 +0100 받은 배지  주목할 만한 질문 (source)
2020-05-22 03:27:14 +0100 질문에 댓글을 달았습니다 Renumber to exclude paras in hidden section?

See https://bugs.documentfoundation.org/show_bug.cgi?id=88649

2020-05-22 03:17:18 +0100 질문에 댓글을 달았습니다 Date Error in Calc

Can you add a calc file with this issue? Maybe cut down the existing file and post that.

2020-05-21 03:17:46 +0100 코멘트달린 답변 How to hide & unhide text & how to make 'Hide' button on toolbar.

https://bugs.documentfoundation.org/show_bug.cgi?id=133209

2020-05-21 02:14:16 +0100 질문에 답변하였습니다 How to hide & unhide text & how to make 'Hide' button on toolbar.

Format, Character, Font Effects: Hidden LibreOffice Writer Version: 6.4.3.2 (x64)

2020-05-08 22:57:17 +0100 받은 배지  주목할 만한 질문 (source)
2020-05-02 05:55:43 +0100 으뜸 답변으로 표시됨 Find Array Function Issue [Bug]

The wizard result is not given in the cell:

=FIND({"A";"B";"C"},"SAMPLE TEXT")

Getting #NAME? expecting {2;#VALUE!;#VALUE!}

image description

Then click OK

image description

2020-05-02 05:55:42 +0100 코멘트달린 답변 Find Array Function Issue [Bug]

Could someone confirm that bug?

2020-04-28 20:35:02 +0100 받은 배지  주목할 만한 질문 (source)
2020-04-28 05:04:02 +0100 질문을 편집했습니다 Lookup Part of Text: Randomly Placed Text in Cell

Lookup Part of Text: Randomly Placed Text in Cell Following Spreadsheet Tips and Tools for Finance Professionals Lookup

2020-04-28 05:03:11 +0100 으뜸 답변으로 표시됨 Lookup Part of Text: Randomly Placed Text in Cell

Following Spreadsheet Tips and Tools for Finance Professionals Lookup Part of Text: Randomly Placed Text in Cell which is returning N/A when it doesn't find a match.

It's an array formula:

  • {=INDEX($I$31:$I$34, MATCH(FALSE, ISERROR(SEARCH($H$31:$H$34, $D31)), 0))}

For Not Found the function - result is: INDEX - #N/A, MATCH - #N/A, ISERROR - True, SEARCH - #VALUE!

How is a default set to return for no match?

image description

C:\fakepath\lookup-part-of-text-excel.xlsx - array formula will not drag down

2020-04-28 05:02:59 +0100 질문에 답변하였습니다 Lookup Part of Text: Randomly Placed Text in Cell

Trap the error and display alternate text as shown: {=IFERROR(INDEX($I$31:$I$34, MATCH(FALSE, ISERROR(SEARCH($H$31:$H$3

2020-04-28 04:49:15 +0100 질문에 댓글을 달았습니다 2 Digit Year Export csv

Was done..

2020-04-28 04:04:36 +0100 질문에 댓글을 달았습니다 Lookup Part of Text: Randomly Placed Text in Cell

Agree, thank you. Opened up the original template, readme says drag (tested - it's wrong). Process you describe works. C

2020-04-28 03:48:00 +0100 질문에 답변하였습니다 2 Digit Year Export csv

It is working fine now. Delete the question?

2020-04-28 03:30:28 +0100 질문에 댓글을 달았습니다 Lookup Part of Text: Randomly Placed Text in Cell

Firstly, agree entering formula into each cell gives correct result as you say. I expect dragging formula down should be

2020-04-28 03:06:16 +0100 질문에 댓글을 달았습니다 Lookup Part of Text: Randomly Placed Text in Cell

It should work as expected. It is an array function but the match returns a single value. Dragging it down will update s

2020-04-28 02:49:09 +0100 질문에 댓글을 달았습니다 Lookup Part of Text: Randomly Placed Text in Cell

Yes I use LO Calc with excel filetypes. Last comment was a quick post before I went to bed. There is a problem with that

2020-04-28 02:20:57 +0100 질문을 편집했습니다 Lookup Part of Text: Randomly Placed Text in Cell

Lookup Part of Text: Randomly Placed Text in Cell Following Spreadsheet Tips and Tools for Finance Professionals Lookup

2020-04-28 02:20:21 +0100 질문을 편집했습니다 Lookup Part of Text: Randomly Placed Text in Cell

Lookup Part of Text: Randomly Placed Text in Cell Following Spreadsheet Tips and Tools for Finance Professionals Lookup

2020-04-28 02:01:35 +0100 질문에 댓글을 달았습니다 Lookup Part of Text: Randomly Placed Text in Cell

Yes I use LO Calc with excel filetypes. Last comment was a quick post before I went to bed. Iirc need to replace , with

2020-04-27 23:33:26 +0100 질문에 댓글을 달았습니다 Lookup Part of Text: Randomly Placed Text in Cell

Yes I use LO Calc with excel filetypes. Last comment was a quick post before I went to bed. Iirc need to replace , with

2020-04-27 18:48:05 +0100 받은 배지  인기있는 질문 (source)
2020-04-27 15:57:37 +0100 질문에 댓글을 달았습니다 Lookup Part of Text: Randomly Placed Text in Cell

Sorry, I read the last paragraph of your original reply as humour. My actual use case is a best-guess (textual) classif

2020-04-27 15:56:21 +0100 질문을 편집했습니다 Lookup Part of Text: Randomly Placed Text in Cell

Lookup Part of Text: Randomly Placed Text in Cell Following Spreadsheet Tips and Tools for Finance Professionals Lookup

2020-04-27 15:54:00 +0100 질문에 댓글을 달았습니다 Lookup Part of Text: Randomly Placed Text in Cell

Sorry, I read the last paragraph of your original reply as humour. My actual use case is a best-guess (textual) classif

2020-04-27 15:32:48 +0100 질문에 댓글을 달았습니다 Lookup Part of Text: Randomly Placed Text in Cell

Sorry, I read the last paragraph of your original reply as humour. My actual use case is a best-guess (textual) classif

2020-04-27 15:31:49 +0100 질문에 댓글을 달았습니다 Lookup Part of Text: Randomly Placed Text in Cell

Sorry, I read the last paragraph of your original reply as humour. My actual use case is a best-guess (textual) classif