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 | 2019-04-14 19:11:12 +0200 |

location | Kyiv, Ukraine |

todays unused votes | 60 votes left |

179

5

- calc× 864
- writer× 144
- macro× 131
- common× 64
- basic× 51
- formula× 43
- cell× 35
- base× 33
- basicmacro× 26
- function× 24
- filter× 20
- date× 19
- column× 19
- vlookup× 18
- spreadsheet× 17
- sum× 17
- range× 17
- table× 17
- find-and-replace× 14
- formatting× 13
- windows-7× 13
- find× 13
- sort× 13
- copy× 13
- text× 12
- macros× 12
- excel× 12
- columns× 12
- conditional× 12
- duplicate× 11
- paste× 11
- time× 11
- rows× 11
- cell-format× 10
- background-color× 10
- list× 10
- background× 9
- hyperlink× 9
- libreoffice× 9
- form× 9
- math× 8
- combobox× 8
- numbers× 8
- formulas× 8
- regex× 8
- delete× 8
- sumif× 7
- search× 7

● Teacher
×
1 ● Commentator
×
1 ● Student
×
1

● Critic × 1 ● Enthusiast × 1

● Editor × 1 ● Good Answer × 31

● Necromancer × 5

● Guru × 4

● Scholar × 1 ● Famous Question × 2

● Popular Question × 2

● Critic × 1 ● Enthusiast × 1

● Editor × 1 ● Good Answer × 31

- 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

● Necromancer × 5

- 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

- HOW DO I TOGGLE CAPITAL LETTERS TO lower case?
- Setting a Calc Document to Open in Full Screen
- Print all installed fonts
- Basic: what is returned in a function?
- search across sheets and place value in another
- Conditional formatting- change cell's background colour when ANOTHER cell equal to...
- 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?

● Guru × 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

- 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

● Scholar × 1 ● Famous 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

- 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

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