Sorunuzu Sorun

SM_Riga isimli kullanıcının profili - etkinlik

2021-02-12 10:34:45 +0100 soruya yorum yazıldı Showing how many times a word appears in a column only when a different word is in a different column

So one more question then. If you have multiple entries in one cell, does appearance order matter? I mean, shall the ent

2021-02-10 21:03:42 +0100 soruya yorum yazıldı Showing how many times a word appears in a column only when a different word is in a different column

Do I understand correct, that some cells can contain more than one name, like Starlight Kid,AZM ASUKA;Kagetsu in one cel

2020-10-12 17:13:17 +0100 soruya yorum yazıldı How to... EXTRACT num. values from specific cells of a range (on a condition)

SUMIF Function

2020-08-31 02:45:52 +0100 rozet alındı  Güzel Cevap (kaynak)
2020-05-24 13:05:29 +0100 bir soru cevapladı I want to change my column sizes, how do I get a report of their current settings?

Hello @nic I am not aware of native Calc functionality to get column widths in a single report. Perhaps you could use a

2020-05-24 11:52:54 +0100 bir soru cevapladı macro math operation via push button: add value +1

Hello @cybersurfer5000 Probably you should not bother with writing macro and use Spin Button for such a task: Insert

2020-04-24 08:22:11 +0100 bir soru cevapladı Finding average through =AVERAGE(D2:D41).. Showing me #DIV/0!

Hello,@JACUZI90 Looks like range D2:D41does not contain values, but text strings, that is why zero arguments are passed

2020-04-22 11:48:03 +0100 soruya yorum yazıldı Why are zero values being displayed?

To hide zero values, you can use menu item Tools -> Options and deselect "Zero values" under LibreOffice Calc -> V

2020-04-22 11:42:05 +0100 soruya yorum yazıldı Why are zero values being displayed?

To hide zero values, you can use menu item Tools -> Options and deselect "Zero values" under LibreOffice Calc -> V

2020-03-25 22:34:36 +0100 cevap düzeltilmiş Dynamically sum the value of sets of cells separated by an empty row?

Hello @zf Assuming A column is for Person and B column for status: =SUMPRODUCT(A:A="Person A";B:B="approved") - counts

2020-03-01 13:14:27 +0100 rozet alındı  Ünlü Soru (kaynak)
2019-11-23 23:18:55 +0100 cevap düzeltilmiş I'm told LibreOffice (32bit) will not work when I upgrade to Catalina on my MacBook.

Please visit this official download page to get 64 bit version for Mac OS.

2019-11-17 14:44:24 +0100 soruya yorum yazıldı BASIC+Calc+HSQLDB: How to move registered database

The error states Basic can not find such LibreOfficeCalcSampleCodes_HSQLDB name in registered DB names list. Maybe some

2019-11-17 12:11:18 +0100 rozet alındı  Güzel Cevap (kaynak)
2019-11-17 08:54:28 +0100 cevap düzeltilmiş Calc: XSLT 2.0 filter for import

For those, who are interested in solution. Seems like, at least to me, that Calc do not provide "out of the box" soluti

2019-11-17 07:25:26 +0100 rozet alındı  Kendi öğrenen (kaynak)
2019-11-17 07:25:26 +0100 rozet alındı  Ölü diriltici (kaynak)
2019-11-16 20:10:47 +0100 soruya yorum yazıldı Will 6.2.8 work on mac with Catalina?

Please check this topic

2019-11-14 08:26:27 +0100 rozet alındı  Güzel Cevap (kaynak)
2019-11-14 06:57:13 +0100 cevap düzeltilmiş BASIC+Calc : The result of date calculation is in long format

Hello @lonk You can try add ThisComponent.CalculateAll at the end. And, of course, doublecheck if cells format is set t

2019-11-13 20:26:13 +0100 cevap düzeltilmiş Maximum value for each distinct name

Just a note to this comment: However, one extra challenge - for any bird, the pivot table gives me the max Photo

2019-11-13 13:29:25 +0100 cevap düzeltilmiş BASIC+Calc : The result of date calculation is in long format

Hello @lonk You can try add ThisComponent.CalculateAll at the end. But I would advice not to iterate over all cells in

2019-10-04 23:31:24 +0100 bir soru cevapladı Macro to use relative references

Hello @Marko V While macro recorder is of limited functionality, it still can be used for capturing some basic actions

2019-10-04 21:15:01 +0100 bir soru cevapladı Calc|BASIC : How to convert column index number to column name

Hello @lonk If you want to get cell name of the CellCursor object, you do not need to dig into Range Address properties

2019-09-30 13:22:42 +0100 rozet alındı  Güzel Cevap (kaynak)
2019-09-29 19:08:21 +0100 bir soru cevapladı Can create calc file on Windows that could be used on MAC?

Hello @Pannie96 I assume by Excel spreadsheet you mean Calc spreadsheet? Just create your spreadsheet, save it to the C

2019-09-29 07:50:14 +0100 bir soru cevapladı Testing Libre softwae

Hello @rajalakshmi! Please see these links if you want to get involved: https://www.libreoffice.org/community/get-invo

2019-09-25 20:30:58 +0100 cevaba yorum yazıldı Comparing two columns of phone numbers, counting qty of duplicates

If using LO version before Regex() was introduced: =SUMPRODUCT(COUNTIF(SUBSTITUTE(MID(B2:B20;2;20);") ";"-");$A$2:$A$40

2019-09-15 00:42:01 +0100 soruya yorum yazıldı How can I define a new or modify an existing named DB range using macros in Calc ?

Macro recorder has limited functionality and can produce unexpectable results. I suppose your DB range is not connected

2019-09-15 00:12:01 +0100 bir soru cevapladı I would like to sort my books Alphabetically by Authors last name.

Hello @Mamma Option 1. Go to Data -> Sort menu option. Under sort tab apply the criteria needed and under Options ta

2019-08-03 18:45:55 +0100 soruya yorum yazıldı Problem with MoveCursorToEnd - xlToRight

MoveCursorToEnd is a user defined function, which is mentioned at the start of the page: '''This code fragment makes us

2019-08-03 18:45:41 +0100 soruya yorum yazıldı Problem with MoveCursorToEnd - xlToRight

MoveCursorToEnd is a user defined function, which is mentioned at the start of the page: '''This code fragment makes us

2019-07-09 21:49:20 +0100 cevap düzeltilmiş sort by date problem in spreadsheet

Hello @andrew07 Seems you have imported your CSV file without defining that column with dates should be treated as Date

2019-07-09 21:43:00 +0100 bir soru cevapladı sort by date problem in spreadsheet

Hello @andrew07 Seems you have imported your CSV file without defining that column with dates should be treated as Date

2019-07-08 19:19:12 +0100 rozet alındı  Güzel Cevap (kaynak)
2019-07-07 01:05:53 +0100 bir soru cevapladı I've created a monthly calendar, now how do I save the formatting? (cell height/width, font/size, etc?) thank you

Saving Calc file as a native ODF Spreadsheet file with .ods extension keeps all the information about it. All formats, s

2019-07-06 18:57:11 +0100 soruya yorum yazıldı Running parameter query using macro on a form.

Edited for readability.

2019-07-06 18:55:18 +0100 soru düzeltilmiş Running parameter query using macro on a form.

Running parameter query using macro on a form. Hi, I have to insert record in a Subform by pushing a button on Mainform

2019-07-06 16:41:57 +0100 bir soru cevapladı How to use Multiple Texts or Numbers under IF

Hello @CSTIG There are various options, just few of them: Use OR() function to return True when at least one of the t

2019-07-05 21:13:23 +0100 soruya yorum yazıldı Calc Autofilter and sort hangs up

Try to pinpoint the problem - make a file copy and delete columns one by one to see which ones are causing problem. 1k l

2019-06-29 21:26:13 +0100 bir soru cevapladı Is there a calc formula (or some other way) that searches a table for multiple conditions?

Hello @Bill Ennals I have created sample spreadsheet for you, demonstrating how such timetable can be filled with array

2019-06-29 09:20:19 +0100 cevaba yorum yazıldı How to import a big amount of data into LibreOffice Base

Many thanks for the tests made @Ratslinger. Had similar task as OP some time ago, to get ~45Mb CSV data into Base table,

2019-06-29 08:40:12 +0100 bir soru cevapladı Create a macro to Find & Replace, in order to sort a sheet

Hello @JacksonGumnut Your "Find&Replace" approach will not work correctly in case you have more then 9 list elemen

2019-06-29 05:54:00 +0100 soruya yorum yazıldı Create a macro to Find & Replace, in order to sort a sheet

Maybe Custom Sort List feature can help?

2019-06-10 21:55:05 +0100 cevaba yorum yazıldı Calc how to transfer column from vertical to H

Nice! I see the idea, but unfortunately for me this returns #VALUE when entered as an array function. The OFFSET part re

2019-06-10 21:17:05 +0100 cevaba yorum yazıldı Duplicate Entries

There is duplicate condition state under Format -> Conditional Formatting -> Condition, just select Cell value is

2019-06-10 21:16:53 +0100 cevaba yorum yazıldı Duplicate Entries

There is duplicate condition state under Format -> Conditional Formatting -> Condition, just select Cell value is

2019-06-10 21:04:43 +0100 cevaba yorum yazıldı Duplicate Entries

There is duplicate condition state under Format -> Conditional Formatting -> Condition, just select Cell value is

2019-06-10 21:02:12 +0100 cevaba yorum yazıldı Duplicate Entries

There is duplicate condition state under Format -> Conditional Formatting -> Condition, just select Cell value is