أطرح سؤالك

SM_Riga's profile - activity

2020-05-24 13:05:29 +0200 أجاب سؤالاً 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 +0200 أجاب سؤالاً 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 +0200 أجاب سؤالاً 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 +0200 علق علي سؤال 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 +0200 علق علي سؤال 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 +0200 حرر إجابة 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 +0200 حصل على وسام  سؤال مشهور (source)
2019-11-23 23:18:55 +0200 حرر إجابة 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 +0200 علق علي سؤال 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 +0200 حصل على وسام  إجابة جميلة (source)
2019-11-17 08:54:28 +0200 حرر إجابة 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 +0200 حصل على وسام  قسم الأرشيف (source)
2019-11-17 07:25:26 +0200 حصل على وسام  متعلم ذاتياً (source)
2019-11-16 20:10:47 +0200 علق علي سؤال Will 6.2.8 work on mac with Catalina?

Please check this topic

2019-11-14 08:26:27 +0200 حصل على وسام  إجابة جميلة (source)
2019-11-14 06:57:13 +0200 حرر إجابة 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 +0200 حرر إجابة 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 +0200 حرر إجابة 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 +0200 أجاب سؤالاً 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 +0200 أجاب سؤالاً 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 +0200 حصل على وسام  إجابة جميلة (source)
2019-09-29 19:08:21 +0200 أجاب سؤالاً 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 +0200 أجاب سؤالاً 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 +0200 علق علي إجابة 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 +0200 علق علي سؤال 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 +0200 أجاب سؤالاً 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 +0200 علق علي سؤال 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 +0200 علق علي سؤال 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 +0200 حرر إجابة 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 +0200 أجاب سؤالاً 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 +0200 حصل على وسام  إجابة جميلة (source)
2019-07-07 01:05:53 +0200 أجاب سؤالاً 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 +0200 علق علي سؤال Running parameter query using macro on a form.

Edited for readability.

2019-07-06 18:55:18 +0200 حرر سؤالاً 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 +0200 أجاب سؤالاً 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 +0200 علق علي سؤال 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 +0200 أجاب سؤالاً 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 +0200 علق علي إجابة 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 +0200 أجاب سؤالاً 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 +0200 علق علي سؤال 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 +0200 علق علي إجابة 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 +0200 علق علي إجابة Duplicate Entries

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

2019-06-10 21:16:53 +0200 علق علي إجابة Duplicate Entries

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

2019-06-10 21:04:43 +0200 علق علي إجابة Duplicate Entries

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

2019-06-10 21:02:12 +0200 علق علي إجابة Duplicate Entries

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

2019-06-10 21:02:02 +0200 علق علي إجابة Duplicate Entries

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

2019-06-08 08:33:23 +0200 علق علي سؤال What is the bean's properties(Name , Value) of conditional formatting in the program of the macro?

Edited code for readability

2019-06-08 08:32:26 +0200 حرر سؤالاً What is the bean's properties(Name , Value) of conditional formatting in the program of the macro?

What is the bean's properties(Name , Value) of conditional formatting in the program of the macro? Hello , Everyone.

2019-06-02 16:27:41 +0200 علق علي إجابة Multiple column match, and seek multiple output values from one column.

What is __Anonymous_Sheet_DB_0, __Anonymous_Sheet_DB_1? & Print Area ? These are not created/defined in my sa

2019-05-31 22:06:31 +0200 علق علي إجابة Multiple column match, and seek multiple output values from one column.

(1) Have you observed that are the values in Pivot table not updating, based on AdvancedFilter criteria? Yes, o