Tweaking AutoCorrect Options

I’m not a fan of AutoCorrect in my Excel or Calc program. As such, there are some tweaks that should be done. Disable Recognition of URLS: Libre Calc source (https://help.libreoffice.org/Common/Turning_off_Automatic_URL_Recognition) Turn off URL Recognition Load a document of the type for which you want to modify the URL recognition. If you want to modify the URL recognition for text documents, open a text document. Choose Tools – AutoCorrect – AutoCorrect Options. In the AutoCorrect dialog, select the Options tab. If you unmark URL Recognition, words will no longer be automatically replaced Continue reading →

Saving your CSV files with Formulas

Whenever you are working with Formulas within Libre Calc or Excel, you will often want to save the formulas for reuse on other data sets. You can do this by going to File, Save As…, then saving the file as a ODS (OpenDocumentSpreadSheet) which is a universal file. You can also save as an XLSX file, but that with have some glitches between Excel and Cacl. LibreOffice Calc Microsoft Excel

Finding non-ASCII characters

Sourced from Stackoverflow.com (https://stackoverflow.com/questions/2124010/grep-regex-to-match-non-ascii-characters) thanks to Alix Axel This will match a single non-ASCII character: [^\x00-\x7F] This is a valid PCRE (Perl-Compatible Regular Expression). You can also use the POSIX shorthands: [[:ascii:]] - matches a single ASCII char [^[:ascii:]] - matches a single non-ASCII char For Libre Calc or Libre Write do a Find & Replace (Ctrl + H) to get this menu: