Ask Your Question

Nemo_bis's profile - activity

2018-12-08 15:16:17 +0100 commented answer Import a PDF and preserve ligatures

I don't have the latex source, otherwise I would not be using the PDF as source. Sorry if it wasn't clear.

2018-12-08 15:15:24 +0100 received badge  Famous Question (source)
2018-12-08 15:15:03 +0100 received badge  Supporter (source)
2018-09-25 10:36:56 +0100 received badge  Famous Question (source)
2018-09-25 10:36:56 +0100 received badge  Notable Question (source)
2018-06-10 08:23:28 +0100 received badge  Notable Question (source)
2018-06-09 16:31:55 +0100 received badge  Popular Question (source)
2018-06-09 15:59:10 +0100 received badge  Student (source)
2018-06-09 08:49:55 +0100 commented question Spell check statistics (number of spelling errors)

How is this outdated?

2018-06-09 08:49:28 +0100 commented question Import a PDF and preserve ligatures

Allegedly, Word is able to and Writer fails: https://workplace.stackexchange.com/a/113665/34408 On the bug tracker I onl

2018-06-09 08:48:53 +0100 asked a question Import a PDF and preserve ligatures

Import a PDF and preserve ligatures I have a PDF file generated from Latex (with the ModernCV template). The text contai

2017-10-01 14:56:06 +0100 commented answer How to hide all comments in Calc (Libre Office 4.2)?

New URL: https://extensions.libreoffice.org/extensions/shownotes

2017-02-15 22:53:53 +0100 commented answer Pivot table only offers "Refresh" and "Delete", grayed out

Indeed... it was this simple. :)

2017-02-15 12:13:08 +0100 commented question How to cut and insert rows efficiently without dragging-and-dropping

The relevant docs are https://help.libreoffice.org/Common/D... and https://help.libreoffice.org/Calc/Mov... but at least for me they're incomplete. 1) Select cells with ctrl + click or shift + arrow keys, 2) Start dragging the cells (not their headers) while holding ctrl-alt, 3) release the ctrl key, 4) move the area where you want and release. Indeed I have no idea how to select the target correctly.

2017-01-10 15:15:02 +0100 received badge  Popular Question (source)
2016-08-14 13:07:09 +0100 commented answer "Trend Lines" greyed Out

Thanks! Someone should correct https://help.libreoffice.org/Chart/Tr... but I don't know how to make/propose edits https://wiki.documentfoundation.org/T...

2015-12-13 02:18:27 +0100 answered a question Estrarre primo nome e primo cognome per indirizzo posta elettronica

Utilizzo un metodo simile a https://ask.libreoffice.org/en/questi...

Ricordati di attivare le espressioni regolari nelle formule da Opzioni > Calc > Calcola > Permetti espressioni regolari.

Poi dobbiamo controllare vari casi: persone con piú di un nome o cognome; cognome che cominci per "di", "de" o simili (preposizioni e preposizioni articolate, per semplicità suppongo siano di 2 o 3 caratteri); rimozione di apostrofi (ed eventualmente trattini). Presumo anche che sia usato solo il primo nome e il primo cognome.

Se il nome è in colonna A, cognome in colonna B, il punto in C1 e il @dominio in D1 la formula sarà qualcosa come:

=SOSTITUISCI(MINUSC(CONCATENA(SE(CONTA.SE(A1;".+ .+");SINISTRA(A1;TROVA(" ";A1)-1);A1);$C$1;SE(CONTA.SE(B1;"^.. .+ .+");SINISTRA(B1;TROVA(" ";SOSTITUISCI(B1;"^(..) ";B1)-1+2));SE(CONTA.SE(B1;".+ .+");SOSTITUISCI(B1;" ";"");B1));$D$1));"'";"")

L'ho poi cambiato in questo per tenere conto dei cognomi che cominciano per Di/De/Al e poi hanno uno o due nomi:

=SOSTITUISCI(MINUSC(CONCATENA(SE(CONTA.SE(E2;".+ .+");SINISTRA(E2;TROVA(" ";E2)-1);E2);$G$1;SE(CONTA.SE(D2;"^.. .+ .+");SINISTRA(SOSTITUISCI(D2;" ";"";1);TROVA(" ";SOSTITUISCI(D2;" ";""; 1))-1);SE(CONTA.SE(D2;"^.. .+");SOSTITUISCI(D2;" ";"";1);SE(CONTA.SE(D2;".+ .+");SINISTRA(D2;TROVA(" ";D2)-1);D2)));$H$1));"'";"")
2015-12-13 02:12:58 +0100 asked a question Estrarre primo nome e primo cognome per indirizzo posta elettronica

Ho un foglio che ha una persona per riga: in una colonna i nomi, in un'altra colonna i cognomi. Devo formare i rispettivi indirizzi di posta elettronica, che sono nella forma nome.cognome@dominio

2015-12-13 01:23:41 +0100 commented answer How to reorder first name, last name in a text string?

Good suggestions, I think however you first need to go to Options > Calc > Calculations > Activate regex.

2015-10-13 17:41:36 +0100 received badge  Taxonomist
2015-07-02 19:00:23 +0100 received badge  Popular Question (source)
2015-07-02 19:00:23 +0100 received badge  Famous Question (source)
2015-07-02 19:00:23 +0100 received badge  Notable Question (source)
2014-11-12 20:36:28 +0100 received badge  Editor (source)
2014-11-12 20:35:56 +0100 asked a question Spell check statistics (number of spelling errors)

I've downloaded the dictionaries and everything, but I have a document about which I only want to know the number of orthography errors/non-existing words. It's a text from OCR and I want to quickly assess its quality.

File > Property > Statistics doesn't have anything; Tools > Word count neither; Tools > Spell checker don't offer any suitable option even in "Other"; Tools > Spell checker options neither.

I'm using LibreOffice 4.2.7.2-4.fc20.