Lupp's profile - overview

● Notable Question   × 51

• Writer-API: com.sun.star.text.TextRanges service, (cf CurrentSelection). How to add or remove a TextRange?
• Who deleted the thread "https://ask.libreoffice.org/en/question/223218/calc-find-first-instance-of-non-blank-cell/"?
• conversion decimal <===> dyadic ("binary") How done?
• API: How to decide if the content of a TextFrame is selected as a bycatch?
• A 'Writer' document contains lots of differently formatted 'Math' formulas. How can I harmonize the formats? Can I use one of the formulas as a kind of template?
• Editing formulas in Calc: How to switch off tooltips concerning names and syntax of functions?
• Why is this site so crazy?
• How to access the settings under the 'Events' tab of a form control to get / set the routines?
• Polling any type, 'Blank' cell to empty text (string)
• LibO version 4.3.0 released. Is it bitwise identical with RC4?
• Where did Mozilla Persona go?
• Sorry! Can someone help to undelete a question?
• Bug Submission Assistant rotten?
• How to propose a user for elimination?
• Wieso wurde der Beitrag https://ask.libreoffice.org/de/question/60610/entfernt?
• How to get better scalable bracket?
• Is there a way to lock a spammer's account?
• [META] strange experience with ask.libreoffice; How to understand?
• Was bedeuten die Hochkommas (Apostrophen) vor Zahlen, Gelbeträgen oder Kalenderdaten, und wie werde ich sie los?
• Can someone, please, block and eliminate the user "baby4u"?
• Why is this site not structured better?
• How to get rid of the response alert ("red rectangle")?
• Where are the fake units 'character' (ch) for indentation and 'line' for spacing specified?
• Can someone with access to Excel 2016 test as described in the attachment, please?
• BASIC function Now() refuses to return the date-time-stamp as Double (fractions of seconds, too).
• Spam: Why doesn't someone from TDF post their view?
• Wie kann man bessere skalierbare Klammern bekommen?
• Editing properties of 'Text Boxes' added to shapes
• optional character properties
• Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet?
• Tab-Bar for LibreOffice Document Windows
• API: Object to access the Page Pane of a Draw or Impress document?
• BASIC: ByVal and arrays
• How to use FILTERXML with local file?
• [crosspost] What interface or service for utf encode decode
• Where are general defaults stored?
• Recovery info: Where stored?
• Calc: How to disable suggestions and autocompletion for the 'Input line'
• API reference com.sun.star.comp.Calc. ?
• How to cope with highhanded "moderation"?
• Functions to save and to handle intermediary results (background)
• What about "Personal Edition" in V 7.0?
• Workbook, Worksheet :↔: Calcbook, Calcsheet ?
• uno service: return folder content as a sequence (array) of file url?
• Is there something like an internal url by which an OLE embedded object is accessible.
• How to access the Recent Files History by user code?
• UI, locale: translation table for keywords and function names
• Calc, macro: optional parameters of REGEX(), INDEX() functions when calling them via FunctionAccess
• Basic function Rnd() and Calc fuction RAND(): Are they using the same algorithm?
• How is anchoring 'To Cell (resize with cell)' implemented?
• verify bugfix

● Taxonomist   × 1

● Critic   × 1

• how to concatenate 12 hr time and the text "AM" or "PM"

● Great Question   × 2

• Why is this site not structured better?
• How to propose a user for elimination?

● Favorite Question   × 1

• Why is this site not structured better?

● Organizer   × 1

• What about "Personal Edition" in V 7.0?

● Necromancer   × 16

• calc - loop through all cells in the current selection
• How to return empty cell from function in calc
• How do you disable date formatting in LibreOffice Calc?
• What is the maximum number of characters in a Calc cell?
• Test number for 2^x in Calc
• How can I write 'ñ' on Linux Mint?
• Calc sort messing up formulas?
• Regression bug
• AltSearch (Alternative dialog Find & Replace) no longer working with LibO Writer 5+?
• Makro: Kopiermodus ausschalten
• Can I access a list of recent documents longer than 10 entries?
• Pdf to Draw to Writer
• A 'Logical Operator' -based Search Option in LibreOffice?
• Changing Text to numbers
• Isnumber always returns false
• [Calc] How to start a macro with user-specified parameters?

● Popular Question   × 58

• Table cells: column Name, column Number, and column Index - how to convert?
• conversion decimal <===> dyadic ("binary") How done?
• Writer-API: com.sun.star.text.TextRanges service, (cf CurrentSelection). How to add or remove a TextRange?
• Calc, macro: optional parameters of REGEX(), INDEX() functions when calling them via FunctionAccess
• Why is this site so crazy?
• uno service: return folder content as a sequence (array) of file url?
• Who deleted the thread "https://ask.libreoffice.org/en/question/223218/calc-find-first-instance-of-non-blank-cell/"?
• How to access the settings under the 'Events' tab of a form control to get / set the routines?
• A 'Writer' document contains lots of differently formatted 'Math' formulas. How can I harmonize the formats? Can I use one of the formulas as a kind of template?
• A question I had commented on vanished; no history
• Polling any type, 'Blank' cell to empty text (string)
• LibO version 4.3.0 released. Is it bitwise identical with RC4?
• Where did Mozilla Persona go?
• Sorry! Can someone help to undelete a question?
• Bug Submission Assistant rotten?
• How to propose a user for elimination?
• Is there a way to lock a spammer's account?
• How to get better scalable bracket?
• Wieso wurde der Beitrag https://ask.libreoffice.org/de/question/60610/entfernt?
• [META] strange experience with ask.libreoffice; How to understand?
• Was bedeuten die Hochkommas (Apostrophen) vor Zahlen, Gelbeträgen oder Kalenderdaten, und wie werde ich sie los?
• How to get rid of the response alert ("red rectangle")?
• Can someone, please, block and eliminate the user "baby4u"?
• Where are the fake units 'character' (ch) for indentation and 'line' for spacing specified?
• Why is this site not structured better?
• Functions to save and to handle intermediary results (background)
• Editing properties of 'Text Boxes' added to shapes
• Can someone with access to Excel 2016 test as described in the attachment, please?
• BASIC function Now() refuses to return the date-time-stamp as Double (fractions of seconds, too).
• Spam: Why doesn't someone from TDF post their view?
• Tab-Bar for LibreOffice Document Windows
• Wie kann man bessere skalierbare Klammern bekommen?
• Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet?
• optional character properties
• Recovery info: Where stored?
• API: Object to access the Page Pane of a Draw or Impress document?
• Should I delete these answers?
• BASIC: ByVal and arrays
• How to use FILTERXML with local file?
• [crosspost] What interface or service for utf encode decode
• API: How to decide if the content of a TextFrame is selected as a bycatch?
• Where are general defaults stored?
• How is anchoring 'To Cell (resize with cell)' implemented?
• Insert>Image from URL with fake extension uses correct filter.
• Calc: How to disable suggestions and autocompletion for the 'Input line'
• How to cope with highhanded "moderation"?
• API reference com.sun.star.comp.Calc. ?
• How to get the raw bytes by which a value is represented
• What about "Personal Edition" in V 7.0?
• Workbook, Worksheet :↔: Calcbook, Calcsheet ?
• How to 'undelete' an inadvertently deleted post?
• Is there something like an internal url by which an OLE embedded object is accessible.
• How to access the Recent Files History by user code?
• empty basic library: how to remove
• UI, locale: translation table for keywords and function names
• Basic function Rnd() and Calc fuction RAND(): Are they using the same algorithm?
• verify bugfix
• Editing formulas in Calc: How to switch off tooltips concerning names and syntax of functions?

● Great Answer   × 5

• How to view 'full path' of open document?
• Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet?
• Percentage Bug Found
• I forgot my password to a very important document Please Please help. I'll get fired
• Pdf to Draw to Writer

● Nice Answer   × 164

• 'BASE' function for fractional values?
• How to remove single quote in front of numbers in a cell
• Calc setting borders via a macro
• Read two integers in text box and add them (macro)
• [Calc] How to start a macro with user-specified parameters?
• Record a macro
• calc - loop through all cells in the current selection
• Insert Line with AutoCorrect doesn't work anymore
• How to move the position of a comment in LO Writer?
• Bad kerning for apostrophe in Italian language (writer)
• Create an updatable link from within Writer to a Calc Chart?
• Using my own style in many Writer files- how to?
• How many functions are implemented in libreoffice?
• How to use Dirac bra-ket notation
• off-line help still not working
• Value amalgamation for all values in a column in Calc.
• I am new to this so be nice. Can I show time as, 3hours, 09minutes and 30seconds
• How do you calculate the number of digits after a decimal point
• How to install only Libre Office Calc and Writer in Windows 10?
• How do you reformat text as DDD:Hr:Min
• How to get better scalable bracket?
• Using an OR function/operator in a COUNTIFS?
• Counting number of times two adjacent cells match a certain criteria
• Set labels for geometric figures in Writer
• Configure colors in geometric figures in Writer
• how do i add a sine trend line on calc?
• How to call LO Calc functions from a LO Basic function (macro)?
• Can't get the value of the cell substring
• Do styles behave as expected?
• Canada English Date Format
• [feature request] paragraph property "Do not include in word count"
• Conditional formatting for cells used in function
• Shortcomings
• select of result of search fail to evidence last instance founded
• How do i write a macro that will increase / decrease font size within a cell in Calc?
• How do I recover macros after replacing my profile
• CalcBASIC: How to move cursor to 4 directions ?
• How to write macro to get hyperlink work
• Calc: What are the numbered columns to the left of row numbers? How do I hide them?
• Is there a toolbar button to add thousands separator?
• In Writer, how to add text under/after a table?
• In Calc, is there a way to reverse the order of text in a cell?
• How can I use nested VLOOKUPs?
• Why does EXACT function does not show expected result?
• when I type before a character, it deletes the following letter! how do I fix this?
• How can I find/replace double spaces NOT after punctuation?
• how to calculate percentage with 2 decimal value and percentage sign?
• How do I remove dashes from phone numbers with Calc?
• Should we upgrade from LibreOffice 3.4.4?
• How to view 'full path' of open document?
• is there a list of known issues?
• two Autocorrect suggestions
• Calc dynamic drop down list?
• Get sheet names as a list
• inverse log
• "Return" character cuts off formula?
• Excessive number of rows and columns in a new Calc worksheet
• should we expect filtering based on cell background in ner future updates?
• [writer 5.2.1] Creating a whole right hand page as a footer-like object.
• Macro code to switch between open Writer documents
• fehlerhafte CALC-Funktionen?
• LibreWriter (5.1.6. and 5.2.3) does not print to a file, if the system has no printer.
• calc - using tuples/vectors
• How do I lock (FREEZE) a row of cells in Calc?
• Transfer calculations
• Calc: how to chart series "slices"?
• Date 'over value' conditional formatting
• Referencing a Cell in other Document using Relative Path
• Pdf to Draw to Writer
• Protect sheet with password
• Upgrading to 5.2.5
• Select all instances of a word simultaneously? (writer).
• Exclude certain cells from SUM total
• Specify first day of Week for all Documents
• Standard Filter Can't Select Column
• Run external file from LO Draw
• Is the ribbon going to make an appearance?
• How to sort results by duplicates
• Suggeston for Location of Backup Files
• complex automatic fill
• From cell range to array
• Removing all draw objects from a writer doc?
• Calc grid lines
• Where is the facility that was used to fill down for functions (formulas)?
• Border width adjustment not responding
• Macro for gradually revealing contents cell by cell
• Search for last weeks document titles
• Make a hyperlink clickable without pressing ctrl in calc?
• Running total/cumulative sum of time?
• possible bug in addition of formula result if result is "" (blank)
• =CONCATENATE(text1;text2;....) riddle
• When I create a comment, the words "unknown author" appears in the comment box. How do I change that to my name, initials, or nickname?
• Calc Question - Referencing Cells
• What is your motivation to answer questions on this site?
• Why is Writing to cells using for loop very slow
• Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet?
• Ensure line is horizontal?
• First line of document as file name instead of Untitled 1
• Display 0 in calc cell if cell is empty
• I forgot my password to a very important document Please Please help. I'll get fired
• select "last" cell in column with a macro
• Macro command to have visibility of screen off while macro runs, so screen stops following macros actions.
• How to insert special characters using unicode for each system
• problem with macros
• Is there a way to enter numbers with suffixes?
• How to do a column sum when the cells are not numeric formatted
• Can Libre Office run from a removable hard drive? Thanks
• Date and time timediff in minutes.
• How to use R1C1 formulae in Calc macros?
• Convert VBA to Basic LO
• "Years" section of date advancing instead of "days" section when dragged?
• How can non-contiguous entries be selected for use with the AVERAGE function?
• How do I switch view to industry standard?
• Pushbutton +1 to cell value
• How do I test cell for a whole integer (non fractional) and return the value if it is and a blank if not?
• Link formula from different sheets, 50 times.
• Sum of a row of a named range
• Funtion "case" in Calc?
• clearing some formatting without clearing other formatting
• Recover color formatting in Calc?
• How to ‘File an enhancement request’?
• Percentage Bug Found
• Variable name Vs Value variable
• How to conditionally select rows, then copy-paste in Calc
• When will Libreoffice Calc do XYZ aka "Surface" chart?
• where is the goto function within calc
• I have 60 shortcuts defined in LibreOffice. Can I copy this personal version of Libre to another computer. Or will i have to define all my shortcuts again?
• how to do a horizontal screen split
• how do i split the window in writer?
• [Calc] Rounding auto-inserted time values
• CALC. How to apply a function in cells where another cell in the row has a specific value
• Changing Text to numbers
• Timetable with Calc
• How to calculate an additive tax in Calc?
• how to sort alphanumeric numbers?
• Bold only for First word in the Paragraph
• Is it possible to suppress printing zeros?
• Considering blank cells and text as zeros in MMULT
• calc logical interpretation of empty cells / arguments 'not intuitive'
• how do you take the nth root in the finnsih version of your software
• In calc how do i select background object
• if cell contains this text then [closed]
• how can Calc be set to highlight the row of the active cell
• Calculate numbers depending on words in the same cell
• how to apply style to same words using find and replace
• COUNTIFS to get weekdays split in am/pm count
• Access current cell from macro in Calc (solved)
• Unable to hide a cell from printing using macro
• How do I round down to the nearest whole dollar
• Replace Full Space with Zero Width Space using Regular Expressions
• how to programmatically determine the length (distance) of a formatted line of text (string) in pixels (cm, ...)?
• Writer: how to determine number of rows in a table?
• R2 different using trend line in chart and by regression
• how to set automatic upgrades
• How do I create new cell styles that can be used in other spreadsheets?
• Is there a way to mirror multiple text boxes and edit them simultaneously?
• LO BASIC : Passing array From Procedure to Function and Function returning array to Procedure
• spreadsheet, how to show gridlines
• Wie kann ich in LibreOffice Writer Tabellenzeilen nummerieren
• Filtering a spreadsheet based on a "blacklist"?
• In LO Writer how can I hide content for printing only?
• Calc Makro für Zufallszahlen
• Cannot install version 6.2.8.2 on a Win 10 laptop. Keep getting error code 1935 during installation.

● Nice Question   × 9

• How to propose a user for elimination?
• Why is this site not structured better?
• Can someone, please, block and eliminate the user "baby4u"?
• Spam: Why doesn't someone from TDF post their view?
• optional character properties
• API: Object to access the Page Pane of a Draw or Impress document?
• How to get rid of the response alert ("red rectangle")?
• Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet?
• Workbook, Worksheet :↔: Calcbook, Calcsheet ?

● Civic Duty   × 1

• Why does the LibreOffice portable version act as a proprietary software?

● Student   × 1

• Where did Mozilla Persona go?

● Supporter   × 1

• Polling any type, 'Blank' cell to empty text (string)

● Enlightened   × 1

• Calc: What are the numbered columns to the left of row numbers? How do I hide them?

● Scholar   × 1

• Polling any type, 'Blank' cell to empty text (string)

● Enthusiast   × 1

● Commentator   × 1

• In calc, how to rename a column? Usual ways don't work.

● Teacher   × 1

• How do I 'escape' a cell value to stop it being treated as a regular expression?

● Editor   × 1

• Test number for 2^x in Calc

● Famous Question   × 35

• API reference com.sun.star.comp.Calc. ?
• conversion decimal <===> dyadic ("binary") How done?
• Why is this site so crazy?
• How to access the settings under the 'Events' tab of a form control to get / set the routines?
• LibO version 4.3.0 released. Is it bitwise identical with RC4?
• Polling any type, 'Blank' cell to empty text (string)
• Sorry! Can someone help to undelete a question?
• Where did Mozilla Persona go?
• How to propose a user for elimination?
• Bug Submission Assistant rotten?
• How to get better scalable bracket?
• [META] strange experience with ask.libreoffice; How to understand?
• Was bedeuten die Hochkommas (Apostrophen) vor Zahlen, Gelbeträgen oder Kalenderdaten, und wie werde ich sie los?
• Why is this site not structured better?
• Can someone, please, block and eliminate the user "baby4u"?
• Can someone with access to Excel 2016 test as described in the attachment, please?
• Spam: Why doesn't someone from TDF post their view?
• Where are the fake units 'character' (ch) for indentation and 'line' for spacing specified?
• Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet?
• Tab-Bar for LibreOffice Document Windows
• Editing properties of 'Text Boxes' added to shapes
• BASIC function Now() refuses to return the date-time-stamp as Double (fractions of seconds, too).
• How to get rid of the response alert ("red rectangle")?
• optional character properties
• BASIC: ByVal and arrays
• API: Object to access the Page Pane of a Draw or Impress document?
• Recovery info: Where stored?
• Is there a way to lock a spammer's account?
• Calc, macro: optional parameters of REGEX(), INDEX() functions when calling them via FunctionAccess
• What about "Personal Edition" in V 7.0?
• [crosspost] What interface or service for utf encode decode
• Editing formulas in Calc: How to switch off tooltips concerning names and syntax of functions?
• Where are general defaults stored?
• How to use FILTERXML with local file?
• Wieso wurde der Beitrag https://ask.libreoffice.org/de/question/60610/entfernt?

● Good Answer   × 50

• How to do a column sum when the cells are not numeric formatted
• Make a hyperlink clickable without pressing ctrl in calc?
• How many functions are implemented in libreoffice?
• What is your motivation to answer questions on this site?
• How to install only Libre Office Calc and Writer in Windows 10?
• Date and time timediff in minutes.
• How can non-contiguous entries be selected for use with the AVERAGE function?
• Shortcomings
• How do i write a macro that will increase / decrease font size within a cell in Calc?
• Calc grid lines
• Calc: What are the numbered columns to the left of row numbers? How do I hide them?
• Excessive number of rows and columns in a new Calc worksheet
• LibreWriter (5.1.6. and 5.2.3) does not print to a file, if the system has no printer.
• fehlerhafte CALC-Funktionen?
• Referencing a Cell in other Document using Relative Path
• Pdf to Draw to Writer
• Calc: how to chart series "slices"?
• Date 'over value' conditional formatting
• Transfer calculations
• calc - using tuples/vectors
• Should we upgrade from LibreOffice 3.4.4?
• How to view 'full path' of open document?
• "Return" character cuts off formula?
• is there a list of known issues?
• two Autocorrect suggestions
• Calc dynamic drop down list?
• Get sheet names as a list
• How do I remove dashes from phone numbers with Calc?
• when I type before a character, it deletes the following letter! how do I fix this?
• Why does EXACT function does not show expected result?
• how to calculate percentage with 2 decimal value and percentage sign?
• How do I lock (FREEZE) a row of cells in Calc?
• In Calc, is there a way to reverse the order of text in a cell?
• How can I use nested VLOOKUPs?
• In Writer, how to add text under/after a table?
• How can I find/replace double spaces NOT after punctuation?
• Is there a toolbar button to add thousands separator?
• inverse log
• Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet?
• I forgot my password to a very important document Please Please help. I'll get fired
• Recover color formatting in Calc?
• Macro for gradually revealing contents cell by cell
• Percentage Bug Found
• How to conditionally select rows, then copy-paste in Calc
• CALC. How to apply a function in cells where another cell in the row has a specific value
• how do you take the nth root in the finnsih version of your software
• Is it possible to suppress printing zeros?
• how to apply style to same words using find and replace
• Calculate numbers depending on words in the same cell
• Wie kann ich in LibreOffice Writer Tabellenzeilen nummerieren

● Citizen Patrol   × 1

• Stichwortverzeichnis übernimmt Schriftart nicht

● Good Question   × 3

• How to propose a user for elimination?
• Why is this site not structured better?
• Spam: Why doesn't someone from TDF post their view?

● Self-Learner   × 5

• Was bedeuten die Hochkommas (Apostrophen) vor Zahlen, Gelbeträgen oder Kalenderdaten, und wie werde ich sie los?
• How to get better scalable bracket?
• Spam: Why doesn't someone from TDF post their view?
• Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet?
• BASIC: ByVal and arrays

● Guru   × 4

• I forgot my password to a very important document Please Please help. I'll get fired
• How to view 'full path' of open document?
• Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet?
• Pdf to Draw to Writer