First time here? Check out the FAQ!

## Registered User | |
---|---|

real name | Vladislav Orlov aka JohnSUN |

member since | 2012-06-06 10:43:35 +0200 |

last seen | 2018-07-21 10:00:22 +0200 |

location | Kyiv, Ukraine |

todays unused votes | 60 votes left |

174

4

- calc× 728
- writer× 126
- macro× 105
- common× 47
- formula× 41
- basic× 34
- cell× 33
- base× 31
- function× 23
- filter× 20
- date× 19
- sum× 17
- spreadsheet× 15
- vlookup× 14
- column× 14
- table× 13
- sort× 13
- copy× 13
- windows-7× 13
- formatting× 13
- text× 12
- basicmacro× 12
- range× 12
- conditional× 12
- rows× 11
- paste× 11
- time× 11
- duplicate× 11
- list× 10
- cell-format× 10
- columns× 10
- find-and-replace× 10
- background× 9
- hyperlink× 9
- excel× 9
- libreoffice× 9
- macros× 9
- numbers× 8
- regex× 8
- combobox× 8
- insert× 7
- installation× 7
- form× 7
- doc× 7
- convert× 7
- installer× 7

● Necromancer
×
5

● Good Question × 1 ● Enlightened × 1 ● Teacher × 1

● Good Answer × 30

● Popular Question × 2

● Commentator × 1 ● Student × 1 ● Editor × 1

● Enthusiast × 1

● Scholar × 1 ● Nice Question × 1 ● Citizen Patrol × 1

- 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

- Calc Conversion TEXT to DATE
- How to conditionally select rows, then copy-paste in Calc
- Multiplying time
- 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?
- Count cells with "minus value"
- Calc dynamic drop down list?
- How can I create a formula that returns the only valid text from the previous 3 fields in the row?
- How to find the row with maximum value?
- Filling combobox problem
- Calc: How do I use text and TODAY() function in same cell with date properly formated?
- How can I move my cursor to the end of a row or column of data?
- 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?

- <solve>portrait in sheet1 and landscape in sheet2
- 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?

● Good Question × 1 ● Enlightened × 1 ● Teacher × 1

● Good Answer × 30

- 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?
- How can I create a formula that returns the only valid text from the previous 3 fields in the row?
- Calc: How do I use text and TODAY() function in same cell with date properly formated?
- 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)

- What is the best way to get the value from a rectangular table?
- ask.libreoffice.org: Latest changes to the site aren't needed

- What is the best way to get the value from a rectangular table?
- ask.libreoffice.org: Latest changes to the site aren't needed

● Popular Question × 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

- <solve>portrait in sheet1 and landscape in sheet2
- 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?

● Commentator × 1 ● Student × 1 ● Editor × 1

● Enthusiast × 1

● Scholar × 1 ● Nice Question × 1 ● Citizen Patrol × 1

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.