First time here? Check out the FAQ!
Hi there! Please sign in
help
Czech
French
English
Dutch
Developers
Croatian
Turkish
German
Korean
Italian
Chinese
Portuguese
Chinese Traditional
Basque
Romanian
Japanese
Spanish
Arabic
▼
البطاقات
المستخدمين
badges
ALL
غير مجابة
أطرح سؤالك
JohnSUN's profile - overview
overview
network
karma
الأسئلة المُتابعة
activity
1
karma
follow
مستخدم مسجل
real name
Vladislav Orlov aka JohnSUN
member since
2012-06-06 10:43:35 +0100
last seen
2021-02-25 04:55:51 +0100
location
Kyiv, أوكرانيا
todays unused votes
60
votes left
2
Questions
382
views
2
answers
3
votes
2013-03-13 09:52:50 +0100
qubit
What is the best way to get the value from a rectangular table? [مغلق]
calc
478
views
0
answer
1
vote
2014-02-19 00:18:16 +0100
oweng
ask.libreoffice.org: Latest changes to the site aren't needed [مغلق]
asklibo
meta
717
Answers
12
Is there a way to add background color to alternate rows of a table/spreadsheet?
6
How to exit from a macro
5
<solve>portrait in sheet1 and landscape in sheet2
5
Calc: How do I reorder rows?
4
Is there still no easy way to make a cell a checkbox?
4
Calc: Regex function
4
I have hit the wrong keys it seems and my text is now coming out orange and underlined. What have I done and how do I undo it?
4
View the number in a cell displaying "###" without making cell wider?
4
calc, graph of y=2*x^2+5
4
[Feature Request] =word(cellref,n) function
« previous
1
...
1
2
3
4
5
...
72
next »
232
Votes
226
6
0
Tags
21
Badges
●
سؤال جيد
×
1
What is the best way to get the value from a rectangular table?
●
مستنير
×
1
Export to CSV instead of SaveAs
●
معلق
×
1
What is the best way to get the value from a rectangular table?
●
طالب
×
1
What is the best way to get the value from a rectangular table?
●
أستاذ
×
1
Create a macro that runs other macros
●
متحمس
×
1
●
إجابة جميلة
×
121
Is there still no easy way to make a cell a checkbox?
open pdf to specific page via macro
is it possible to unhide all groups using a macro?
[solved] error access to object array like of PropertyValue inside function
how to insert a tick mark
list of ONLY values greater than the value in referenced Cell
Summary from sheet with blank rows
How to quickly merge two similar sheets?
Calc+BASIC: Creating formula
IDK why FIND() gives me this value when comparing these two tables on LO Calc
Feature request: Keyboard shortcut to export directly as PDF
Date on which given week starts
Inconsistent conditional formatting using formula
find text in cell from a filter list; COUNTIF
Calc: How to convert time in MM:SS into seconds
change cell background color with mouse click
Add a value dependant on day of week in calc
What does "collect words" mean?
[SOLVED] How to get String length and single char in Calc StarBasic Macro
How to write a Basic Macro to set Libre calc options View Display Zero values On and Off?
CALC: Merge only columns not rows
use macro to insert hyperlink on one sheet to link to another sheet in same document
How do you terminate a save process from a macro?
Calc: Regex function
Access current cell from macro in Calc (solved)
URL or hyperlink to text
Simple multiplication doesn't seem to be working
What are the Enumeration Names for SearchDescriptor.SearchType
How to Convert "John;Smith" to "Smith;John"
Calc: Convert text to link
Calc: Convert Image URLs To Actual Images
Convert link correctly to hyperlink
How do I remove the comment indicator
Get Row and Column number from "ThisComponent.CurrentSelection"
Saving a very large page by dividing it into 100 lines of csv files.
add zero number in beginning of phone numbers
Conditional formatting by %
Calc: Remove decimal places from values = 0, otherwise display decimals
how to find the name of the last column with values
LibreOffice Writer export pdf does not embed fonts
Star basic: passing sub/function as parameter to other sub/function
How do I update the date for each weekday when the weekdays are in fixed columns?
Is there a list of functions for use in Basic?
Simple dupe removal
unique cell or delete the lines with all the duplicate
Search bar with highlight - Basic Code
Link automatically updating styles to a template
How to add a unique footer to first page
Macros and deleting
Export to CSV instead of SaveAs
SUMIF with Functions?
trying to create crossword, can't block a cell black
Filter out items in column B from column A
Need to calculate a future date
How to write a formula for conditional multiple returns to display in an ordered list in a single cell?
Is it possible to view two calc sheets side by side?
Header on 1st page only
how to make a scrolling spreadsheet with a set title row??
Can I add a drop down box field in my document?
Calc: How do I reorder rows?
How to exit from a macro
Calc: Need help with macro, formula or other method to automate changes
<solve>portrait in sheet1 and landscape in sheet2
Is there a way to add background color to alternate rows of a table/spreadsheet?
Styles and Formats
Base Query to Reset/Set a Field
A method of using regex to apply classifications
Calc: Copy and paste named ranges
Hi, help with this problem (sumif)
How can I import German-formatted numbers as numbers
Is it possible to use more than one test in the IF() function in Calc?
calc: date entry shortcut
COUNTING TEXT IN COLUMNS
LibreOffice Calc displays dots across the sheet
[Feature Request] =word(cellref,n) function
calc, graph of y=2*x^2+5
what are the buttons with numbers 1,2 on the far left bar in calc window?
I want to create a macro which will call another macro until it reaches "end of data"
insert fields date time
in "Find & Replace", how to insert a "tab" at the start of every paragraph
How to copy and paste only data from the spread sheet ?
custom function not automatic updating
How do I freeze rows/columns?
How do I remove the gray dots on the page?
how can I get more fonts
How can I apply columns to a table only?
Calc: informative text to be with specific markdowns (ex. bigger font, bold and different color if wrong)
What is the point of Ctrl-A Select All in Calc?
comment from a cell as a value into another cell
Query calculation in Base
Calc: How To Remove Both First Occurence and Duplicate Entry From Column
How to convert merged cells into ordinary cells and copy data from merged cells to ordinary cells?
View the number in a cell displaying "###" without making cell wider?
looking for last row used programmatically
Conditional formatting: change cell background colour when another cell's date = today
insert tab as a special character in find&replace
Solved index/max search
calc find & replace for formulas
clearing formats in LO calc?
How can I move my cursor to the end of a row or column of data?
Calc: How do I use text and TODAY() function in same cell with date properly formated?
Filling combobox problem
How to find the row with maximum value?
How can I create a formula that returns the only valid text from the previous 3 fields in the row?
Calc dynamic drop down list?
Count cells with "minus value"
I have hit the wrong keys it seems and my text is now coming out orange and underlined. What have I done and how do I undo it?
Multiplying time
How to conditionally select rows, then copy-paste in Calc
Calc Conversion TEXT to DATE
Conditional Formatting using values instead of actual cell contents
what is wrong with this sumifs statement
How to start LibreOffice Calc and do some automatic tasks
How do I copy a cell value into a macro variable in Calc?
Conditional formatting- change cell's background colour when ANOTHER cell equal to...
search across sheets and place value in another
Basic: what is returned in a function?
Print all installed fonts
Setting a Calc Document to Open in Full Screen
HOW DO I TOGGLE CAPITAL LETTERS TO lower case?
calc how to add time increments?
●
ناقد
×
1
LIST TABLE
●
مُعلم
×
4
How to exit from a macro
Is there a way to add background color to alternate rows of a table/spreadsheet?
Calc: How do I reorder rows?
<solve>portrait in sheet1 and landscape in sheet2
●
إجابة ممتازة
×
4
How to exit from a macro
Is there a way to add background color to alternate rows of a table/spreadsheet?
Calc: How do I reorder rows?
<solve>portrait in sheet1 and landscape in sheet2
●
قائد لجنة شعبية
×
1
How Can I Get The Powers Korea Im Yong Soo Cosplay Costume?
●
سؤال مشهور
×
2
What is the best way to get the value from a rectangular table?
ask.libreoffice.org: Latest changes to the site aren't needed
●
سؤال ملحوظ
×
2
What is the best way to get the value from a rectangular table?
ask.libreoffice.org: Latest changes to the site aren't needed
●
سؤال جميل
×
1
What is the best way to get the value from a rectangular table?
●
مثقف
×
1
What is the best way to get the value from a rectangular table?
●
سؤال شعبي
×
2
What is the best way to get the value from a rectangular table?
ask.libreoffice.org: Latest changes to the site aren't needed
●
إجابة جيدة
×
42
Is there still no easy way to make a cell a checkbox?
Saving a very large page by dividing it into 100 lines of csv files.
Add a value dependant on day of week in calc
[SOLVED] How to get String length and single char in Calc StarBasic Macro
How to write a Basic Macro to set Libre calc options View Display Zero values On and Off?
Calc: Regex function
I want to create a macro which will call another macro until it reaches "end of data"
Calc: Convert text to link
Calc: Convert Image URLs To Actual Images
Conditional formatting by %
Calc Conversion TEXT to DATE
Export to CSV instead of SaveAs
Need to calculate a future date
How to write a formula for conditional multiple returns to display in an ordered list in a single cell?
Link automatically updating styles to a template
How to add a unique footer to first page
Is it possible to view two calc sheets side by side?
Header on 1st page only
Calc: How do I reorder rows?
Macros and deleting
How to exit from a macro
Calc: Need help with macro, formula or other method to automate changes
Is there a way to add background color to alternate rows of a table/spreadsheet?
Base Query to Reset/Set a Field
Styles and Formats
trying to create crossword, can't block a cell black
How can I import German-formatted numbers as numbers
[Feature Request] =word(cellref,n) function
calc, graph of y=2*x^2+5
How to copy and paste only data from the spread sheet ?
<solve>portrait in sheet1 and landscape in sheet2
in "Find & Replace", how to insert a "tab" at the start of every paragraph
How do I freeze rows/columns?
What is the point of Ctrl-A Select All in Calc?
how to make a scrolling spreadsheet with a set title row??
View the number in a cell displaying "###" without making cell wider?
COUNTING TEXT IN COLUMNS
Calc: informative text to be with specific markdowns (ex. bigger font, bold and different color if wrong)
Calc: How do I use text and TODAY() function in same cell with date properly formated?
How can I create a formula that returns the only valid text from the previous 3 fields in the row?
I have hit the wrong keys it seems and my text is now coming out orange and underlined. What have I done and how do I undo it?
Conditional Formatting using values instead of actual cell contents
●
قسم الأرشيف
×
6
change cell background color with mouse click
Macros and deleting
Calc Removing a number from a range
Cannot remove protection from word document
Calc: Checking whether a range of cells are blank via a formula
Average highest/lowest values
●
داعم
×
1
Count merged cells in calc
●
محرر
×
1
Macros and deleting
●
مؤدي الواجب
×
1
In Calc, how do i retain only the numbers when a cell has numbers and letters
Content on this site is licensed under a
Creative Commons Attribution Share Alike 3.0
license.
Powered by Askbot version 0.9.3
Please note: AskLibO requires javascript to work properly, please enable javascript in your browser,
here is how