JohnSUN's profiel - overzicht

● Criticus   × 1

• LIST TABLE

● Mooi Antwoord   × 92

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

● Weten   × 1

• Export to CSV instead of SaveAs

● Student   × 1

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

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

● burgerwacht   × 1

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

● Mooie Vraag   × 1

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

● Leerling   × 1

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

● Redacteur   × 1

• Macros and deleting

● Commentator   × 1

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

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

● Geweldig Antwoord   × 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

● enthousiast   × 1

● Leraar   × 1

• Create a macro that runs other macros

● Supporter   × 1

• Count merged cells in calc

● Beroemde vraag   × 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

● Populaire Vraag   × 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

● Opvallende Vraag   × 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

● Goede Vraag   × 1

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

● burgerplicht   × 1

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

● Goed Antwoord   × 34

• 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