First time here? Check out the FAQ!

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

real name | Eike Rathke |

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

last seen | 2020-10-27 19:57:44 +0100 |

website | https://erack.de/ |

location | Hamburg, Germany |

todays unused votes | 60 votes left |

565

99

- calc× 1,773
- common× 296
- writer× 136
- formula× 124
- date× 78
- format× 66
- cell× 60
- csv× 46
- function× 43
- macro× 42
- error× 40
- windows-10× 39
- cell-format× 36
- copy× 34
- column× 32
- data× 29
- math× 27
- chart× 24
- sheet× 24
- sum× 24
- windows-7× 23
- copy+paste× 23
- paste× 22
- text× 22
- excel× 22
- basic× 22
- vlookup× 22
- ct2n× 22
- decimal× 21
- countif× 20
- import× 19
- time× 19
- convert× 19
- update× 18
- array× 18
- xlsx× 17
- ubuntu-16.04× 17
- number× 16
- match× 16
- base× 15
- display× 15
- row× 15
- file× 15
- hyperlink× 15
- currency× 15
- lookup× 15
- autocalculate× 15
- meta× 14
- install× 14
- language× 14

● Enlightened
×
1 ● Organizer
×
1 ● Nice Answer
×
61

● Good Answer × 12

● Editor × 1 ● Autobiographer × 1

● Critic × 1 ● Enthusiast × 1

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

● Teacher × 1

- 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 × 12

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

- 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

● Editor × 1 ● Autobiographer × 1

● Critic × 1 ● Enthusiast × 1

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

● Teacher × 1

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