질문하기

# 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