JohnSUN's Profil - Übersicht

● Gute Antwort   × 32

• 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

● Lehrer   × 1

• Create a macro that runs other macros

● Schüler   × 1

• What is the best way to get the value from a rectangular table?

● Staatsbürger   × 1

• In Calc, how do i retain only the numbers when a cell has numbers and letters

● Unterstützer   × 1

• Count merged cells in calc

● Fragen   × 1

• What is the best way to get the value from a rectangular table?

● Gute Frage   × 1

• What is the best way to get the value from a rectangular table?

● Bemerkenswerte Frage   × 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

● populäre Frage   × 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

● Elementare Frage   × 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

● Kritiker   × 1

• LIST TABLE

● Redakteur   × 1

• Macros and deleting

● Totenbeschwörer   × 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

● Tolle Antwort   × 75

• 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?

● Enthusiast   × 1

● Bürgerwehr   × 1

• How Can I Get The Powers Korea Im Yong Soo Cosplay Costume?

● Lernender   × 1

• What is the best way to get the value from a rectangular table?

● 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

● Sehr gute Antwort   × 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

● Kommentator   × 1

• What is the best way to get the value from a rectangular table?

● Hat Ahnung   × 1

• Export to CSV instead of SaveAs