First time here? Check out the FAQ!

## Registered User | |
---|---|

real name | Eike Rathke |

member since | 2012-02-20 21:05:47 +0200 |

last seen | 2021-05-14 19:59:52 +0200 |

website | https://erack.de/ |

location | Hamburg, Germany |

todays unused votes | 60 votes left |

617

103

- calc× 2,005
- common× 328
- writer× 142
- formula× 133
- date× 86
- format× 74
- cell× 65
- macro× 53
- csv× 50
- function× 48
- error× 43
- windows-10× 39
- cell-format× 36
- copy× 35
- column× 34
- data× 34
- basic× 31
- math× 28
- sum× 27
- lookup× 25
- paste× 24
- chart× 24
- text× 24
- import× 24
- sheet× 24
- vlookup× 24
- excel× 23
- windows-7× 23
- copy+paste× 23
- ct2n× 23
- time× 22
- decimal× 22
- convert× 21
- sort× 20
- countif× 20
- ubuntu-16.04× 20
- password× 19
- array× 19
- update× 18
- hyperlink× 18
- match× 17
- xlsx× 17
- number× 16
- display× 16
- file× 16
- currency× 16
- meta× 15
- base× 15
- row× 15
- xls× 15

● Teacher
×
1 ● Critic
×
1 ● Autobiographer
×
1

● Commentator × 1 ● Enthusiast × 1

● Good Answer × 17

● Necromancer × 22

● Civic Duty × 1 ● Citizen Patrol × 1 ● Associate Editor × 1

● Taxonomist × 1

● Commentator × 1 ● Enthusiast × 1

- auto update webservice api links
- how to get last non-empty cell in row(line)
- Return the last value in a column
- How to access addNewByScopeName()
- Efficacy of storing text or referring to text
- Change the autofilter arrow background when active
- I have a custom style (in calc) I want to be included in every new document
- IFS function not working in OpenOffice 4.1.9
- Importing IFS() and CONCAT() from Google Sheets into Calc
- I entered 1/4 for date 1/4/21, but got fraction 1/4
- move rows that match condition to different sheet with macro
- PLEASE, rtl language problem
- [Calc] List of changed functions with the language
- How do I return the LAST number in a column of numbers?
- disable spell check on email address
- Data Validity Custom Formula issue; stop with error message when another cell is empty
- How can i search/replace the content in one column with content from another column? (libreoffice calc)
- Calc function "=HERE()"
- Misformatted Calc sheet from tab delimited text import?
- How can I copy a huge number of .txt files into LibreOffice Calc columns of the same sheet?
- ERROR in VALUE function with text_date as argument
- debugging LOOKUP()
- compare to open office
- Using conditional formatting to change the number format
- No simple SUBSTITUTE in macros?
- Where can i download a duch language pack as the language is not in the installer?
- Max number of nested "IF" statements in Calc?
- Copy/Paste clipboard issues LibreOffice Calc
- i want to keep the day constant but increase the month by 1 in every cell how
- Why does SEARCH with regular expression (regex) fail with #VALUE!
- add hebrew support for libreoffice
- REGEX problem splitting dates
- Reset a Spreadsheet - Delete your data but not your formulas
- What is the best way to get the value from a rectangular table?
- request a feature
- How can I post comments to questions and answers ?
- Calc Function CONVERT_ADD unit string not explained
- Libre office online without downloading-please urgent!!!
- Calc - Is there a way to Right Click -Edit Picture same as in Writer
- Please, suggestions for using a not included language
- How to deactivate automatic date formatting in calc?
- MS Office / LIbreOffice: Which one is more vulnerable?
- how to calculate percentage with 2 decimal value and percentage sign?
- How to insert the document title in a cell in a Calc Spreadsheet?
- function wizard causes lockup
- number forced to scientific notation
- Empty row in Calc causes filter to stop operation?
- Can't get Libreoffice Calc to recognise relative hyperlinks
- import dbase via Basic - how to select character set
- Can't sort by name with LibreOffice Calc
- column has been defined as a "Decimal" type, the max. length is 19 characters (with 15 decimal places).
- Calc: how do I go through all #VALUE! cells?
- Does LibreOffice Calc have a data validation feature like Excel?
- Calc-how do I maintain formatting?
- Is the 'rand' function in Calc truly random?
- Default save for calc files
- Excel has many Bible reading plans, can I convert to LibreOffice Calc file? Safely?
- Can anyone see why two results in the attached sheet are wrong?
- Need help with a Calc formula
- Formula compatibility
- Edit a named range
- How to format cells for Hex numbers?
- how to install dictionary or not displayed ?
- Calculating median using dates
- Calc: Number of cells which don't have any of a set of values
- When I press PgDn, Writer starts a numbered list that I DON'T want. How do I stop this?
- Why is this SUMIF not working?
- You deleted a spreadsheet I was using, why ?
- How do you make blank cells calculated as zero
- CALC: How do I set the language for a selection of cells?
- Incorrect average of time in Calc
- Wie kann ich neue Schrift Fonts installieren
- Regex, access to backreference using a macro
- xls file format, data changes without adjust of modification time

● Good Answer × 17

- How do you make blank cells calculated as zero
- Efficacy of storing text or referring to text
- I have a custom style (in calc) I want to be included in every new document
- How do I return the LAST number in a column of numbers?
- PLEASE, rtl language problem
- How can i search/replace the content in one column with content from another column? (libreoffice calc)
- Calc function "=HERE()"
- What is the best way to get the value from a rectangular table?
- request a feature
- MS Office / LIbreOffice: Which one is more vulnerable?
- How to insert the document title in a cell in a Calc Spreadsheet?
- how to calculate percentage with 2 decimal value and percentage sign?
- Calc: how do I go through all #VALUE! cells?
- Can't sort by name with LibreOffice Calc
- Default save for calc files
- Can anyone see why two results in the attached sheet are wrong?
- You deleted a spreadsheet I was using, why ?

● Necromancer × 22

- How do I translate Calc functions between different languages?
- Misformatted Calc sheet from tab delimited text import?
- Not allowed to define "C" as name
- Mysterious number "10" appears in centre of calc chart
- I dont know the password, how do I unlock Protected Cells?
- What is the difference between CONVERT and CONVERT_OOO functions?
- =Teil(->Text;Anfang;Zahl)
- Copy/Paste clipboard issues LibreOffice Calc
- request a feature
- MS Office / LIbreOffice: Which one is more vulnerable?
- Calc - Sum error for currency
- Status bar SUM not working across sheets properly.
- werden in libre office ab vers. 5 keine postscript-fonts mehr unterstützt?
- Calc security prevent document from being copied/moved
- Minif and Maxif function in calc
- Why does format column to date insert apostrophe? '08/03/2015
- Help needed with SUM function in Calc
- How to remove single quote in front of numbers in a cell
- Detailed tutorial regarding LibreOffice to Python macro writing, especially for Calc
- In Calc, what does block selection mode do?
- Remote save: File non-existent
- LibreOffice 6.2 can't save to samba share

● Civic Duty × 1 ● Citizen Patrol × 1 ● Associate Editor × 1

● Taxonomist × 1

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