질문하기

karolus's profile - activity

2019-06-12 09:42:58 +0200 답변을 편집했습니다 SUMPRODUCT "Div/0" ERROR WITH NO DIVISION

Hallo See my Comment, if so - try something like: =SUMPRODUCT(B1:B10=A1, C1:C10="EX",S1:S10,IFERROR(Z1:Z10,0)) …o

2019-06-12 09:38:17 +0200 질문에 답변하였습니다 SUMPRODUCT "Div/0" ERROR WITH NO DIVISION

Hallo See my Comment, if so - try something like: =SUMPRODUCT(B1:B10=A1, C1:C10="EX",S1:S10,IFERROR(Z1:Z10,0))

2019-06-12 09:25:59 +0200 질문에 댓글을 달았습니다 SUMPRODUCT "Div/0" ERROR WITH NO DIVISION

My guess: there is somewhere in [B|C|S|Z]1…10 a #div/0-error which goes straight into return of SUMPRODUCT

2019-06-07 07:44:33 +0200 질문에 댓글을 달았습니다 IsBlank using in Basic always '0'

single Cells have already the Property .String respective the Method .getString()… print thisComponent.CurrentSelection

2019-05-24 16:06:32 +0200 질문에 댓글을 달았습니다 Proposal: Add pdf viewer in LibreOffice

-1 I dont see any advance in that proposal, there are enough pdf-viewers available no reason to reinvent the wheel.

2019-05-21 19:55:22 +0200 받은 배지  훌륭한 답변 (source)
2019-05-18 01:02:44 +0200 질문에 답변하였습니다 Calc Copy column of formulas and paste into word proccessor

Put in B1 the formula =FORMULA(A1) pull down to B10 and c&p this into Notepad++

2019-05-12 15:09:22 +0200 코멘트달린 답변 LibreOffice Calc 6 - "batch" hyperlink to files in folder?

If so please tick the ✓-mark left near my answer.

2019-05-10 19:33:39 +0200 코멘트달린 답변 Student database

This resolved the problem! Thanks!

2019-05-09 18:58:46 +0200 코멘트달린 답변 Wert in Datum wandeln

Hallo Wäre das nicht auch mit einem simplen Schaltjahrtest möglich, aka: SELECT 365 + (("Jahr" % 100 != 0 AND

2019-05-09 18:42:53 +0200 코멘트달린 답변 Wert in Datum wandeln

Hallo Wäre das nicht auch mit einem simplen Schaltjahrtest möglich, aka: SELECT 365 - (("Jahr" % 100 != 0 AND

2019-05-09 18:30:42 +0200 코멘트달린 답변 Wert in Datum wandeln

Hallo Wäre das nicht auch mit einem simplen Schaltjahrtest möglich, aka: SELECT (("Jahr" % 100 != 0 AND "Jahr"

2019-05-08 15:44:13 +0200 코멘트달린 답변 [SOLVED] How Can I Delete Data with Macro

Ok sorry… youre need also to insert a additional line : source.Sheet = 1

2019-05-08 15:19:09 +0200 코멘트달린 답변 [SOLVED] How Can I Delete Data with Macro

please dont ask that stupid! its obviously either in menu > Sheet > Insert Sheets or in the Contextmenu of the She

2019-05-08 11:06:56 +0200 코멘트달린 답변 [SOLVED] How Can I Delete Data with Macro

Yes, of course, change for Example: identifiers = sheet1.getCellRangeByName("A1:A1000").getDataArray() used_entrys

2019-05-07 19:05:32 +0200 코멘트달린 답변 Do these featured exist? list all rows with the "N" column being less than 100

@Opaque: …as well the Standardfilter does!

2019-05-07 17:07:32 +0200 질문에 답변하였습니다 Do these featured exist? list all rows with the "N" column being less than 100

have a look on >Data > Filter > Standardfilter …

2019-05-07 16:21:13 +0200 답변을 편집했습니다 [SOLVED] How Can I Delete Data with Macro

Maybe youre about something like: Sub CopyPasteworking range_address = CreateUnoStruct("com.sun.star.table.

2019-05-07 16:01:29 +0200 질문에 답변하였습니다 [SOLVED] How Can I Delete Data with Macro

Maybe youre about something like: Sub CopyPasteworking range_address = CreateUnoStruct("com.sun.star.table.

2019-05-07 12:53:46 +0200 질문을 편집했습니다 [SOLVED] How Can I Delete Data with Macro

How Can I Delete Data with Macro Hello! I try to write macro in Libre Office Macro. I want to delete data by using Libr

2019-05-07 12:52:25 +0200 질문을 편집했습니다 [SOLVED] How Can I Delete Data with Macro

How Can I Delete Data with Macro Hello! I try to write macro in Libre Office Macro. I want to delete data by using Libr

2019-05-07 12:50:16 +0200 질문을 편집했습니다 [SOLVED] How Can I Delete Data with Macro

How Can I Delete Data with Macro Hello! I try to write macro in Libre Office Macro. I want to delete data by using Libr

2019-05-07 12:33:23 +0200 질문에 댓글을 달았습니다 how do I run an archival program quick

repeating same stupid question with another acount is more stupid. how do I run…

2019-05-07 12:30:01 +0200 질문에 댓글을 달았습니다 how do I run an archival program quick

repeating same stupid question with another acount is more stupid.

2019-05-06 10:59:02 +0200 코멘트달린 답변 AVERAGEIF column A equals 1

@your PS: [OT] I'm partially agree … but I'm always distracted by this ""quotes around numeric values[1] and prefer a s

2019-05-06 10:57:20 +0200 코멘트달린 답변 AVERAGEIF column A equals 1

@your PS: [OT] I'm partially agree … but I'm always distracted by this ""quotes around numeric values[1] and prefer a s

2019-05-06 10:56:39 +0200 코멘트달린 답변 AVERAGEIF column A equals 1

@your PS: [OT] I'm partially agree … but I'm always distracted by this ""quotes around numeric values## and prefer a sy

2019-05-06 09:28:39 +0200 코멘트달린 답변 LibreOffice Calc 6 - "batch" hyperlink to files in folder?

Ps.: look also in this thread about APSO a very usefull Extionsion for managing python-Scripts in Libreoffice

2019-05-06 09:10:54 +0200 코멘트달린 답변 LibreOffice Calc 6 - "batch" hyperlink to files in folder?

open your favourite Texteditor (no it isnt writer in this case) c&p the souce exactly into a new file and store it i

2019-05-05 23:51:17 +0200 질문에 답변하였습니다 LibreOffice Calc 6 - "batch" hyperlink to files in folder?

Called from a Calcfile stored in target_folder the following code puts HYPERLINK(…)-formulas into Column A of active She

2019-05-05 23:33:07 +0200 코멘트달린 답변 How to Calculate for only the 6th Day?

looks better ;-)

2019-05-05 23:23:07 +0200 코멘트달린 답변 How to Calculate for only the 6th Day?

@Gilberto Schiavinatto: wrong Formula, the 6th day only should be multplied by 1.5

2019-05-05 20:19:25 +0200 답변을 편집했습니다 Copy/paste all rows found in "Find All" Keyword Search - Libreoffice Calc

In the case the hits are all in the same column you can do the task by: > Data > Filter > Standardfilter (…)

2019-05-05 20:16:13 +0200 답변을 편집했습니다 Copy/paste all rows found in "Find All" Keyword Search - Libreoffice Calc

In the case the hits are all in the same column you can do the task by: > Data > Filter > Standardfilter (…)

2019-05-05 09:42:32 +0200 질문에 답변하였습니다 Copy/paste all rows found in "Find All" Keyword Search - Libreoffice Calc

In the case the hits are all in the same column you can do the task by: > Data > Filter > Standardfilter (…)

2019-05-04 09:28:20 +0200 질문에 댓글을 달았습니다 Makro Formular öffnen

Original editiert zwecks besserer Lesbarkeit.

2019-05-04 09:24:57 +0200 질문을 편집했습니다 Makro Formular öffnen

Makro Formular öffnen Moin, ich möchte über ein Formular "Mainpage" ein Formular mittels Button öffnen. Wie kann ich da

2019-05-02 18:42:00 +0200 질문에 댓글을 달았습니다 Is it possible to insert sheet title as sheet name

Wath did you mean by Sheet Title ?

2019-05-02 09:35:47 +0200 질문에 댓글을 달았습니다 Japanische Zeichen für Windows und (!) Linux

Ich persönlich hätte kaum moralische Bedenken die entsprechenden Schriftfonts nach Linux zu kopieren und dort zu install

2019-04-17 22:31:59 +0200 코멘트달린 답변 Set todays date in a cell but then fix it.

@pherriot: replace TODAY with NOW

2019-04-17 05:57:28 +0200 코멘트달린 답변 Datum das in Zukunft liegt berechnen

Okay, mir ist nur entgangen daß du nicht korrekt erst später hinzugefügt hast.

2019-04-16 19:46:37 +0200 코멘트달린 답변 Datum das in Zukunft liegt berechnen

Nicht korrekt: (Bei dir ist auch die Schreibweise von der Zelle E8 falsch. Entweder "E8" oder "$E$8".). Das ist Unsinn,

2019-04-15 19:14:48 +0200 코멘트달린 답변 Can this be done with a macro? If so, what would that macro look like?

Please see my edited answer, sorry for the misleading advice.

2019-04-15 19:12:34 +0200 답변을 편집했습니다 Can this be done with a macro? If so, what would that macro look like?

Hi. Search and replace Search (.*). Replace with textbefore $1 textafter. with Options: [✓]regular Expressionan

2019-04-15 16:14:33 +0200 답변을 편집했습니다 Can this be done with a macro? If so, what would that macro look like?

Hi. Search and replace Search (.*). Replace with textbefore $1 textafter. with Options: [✓]regular Expressionan

2019-04-15 16:09:36 +0200 코멘트달린 답변 Can this be done with a macro? If so, what would that macro look like?

Thats exactly whats my suggested search & replace procedure does. any Questions?

2019-04-15 09:11:19 +0200 질문에 댓글을 달았습니다 Can this be done with a macro? If so, what would that macro look like?

No need for Makro, do Step1 and look at my Answer.

2019-04-15 09:01:00 +0200 질문에 답변하였습니다 Can this be done with a macro? If so, what would that macro look like?

Hi. Search and replace Search (.*). Replace with textbefore $1 textafter. with Options: [✓]regular Expressionan

2019-04-14 09:39:42 +0200 질문에 답변하였습니다 How do I find the last entry in a column that may contain many blanks (Solved)

The Formula extendet to return the relativ Date from Column A:. =INDEX(A9:A79,MATCH(1E+018,B9:B79,1))

2019-04-13 12:14:22 +0200 코멘트달린 답변 Is there a way of comparing new sheet with old sheet and returning the differences?

@Opaque yes youre right it's not the same. But it seems easy to hide manually the "old" Data which are still exactly in