JohnSUN's Profil - Übersicht

● 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

● 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

● 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

● Tolle Antwort   × 119

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

● Kritiker   × 1

• LIST TABLE

● Schüler   × 1

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

● Hat Ahnung   × 1

• Export to CSV instead of SaveAs

● Kommentator   × 1

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

● Lernender   × 1

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

● Bürgerwehr   × 1

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

● Fragen   × 1

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

● Enthusiast   × 1

● Staatsbürger   × 1

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

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

● 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

● Unterstützer   × 1

• Count merged cells in calc

● Lehrer   × 1

• Create a macro that runs other macros

● Redakteur   × 1

• Macros and deleting

● Gute Frage   × 1

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

● Gute Antwort   × 41

• 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