Fai la tua domanda

pavion's profile - attività

2020-01-29 14:57:58 +0200 received badge  Domande famose (source)
2020-01-29 14:57:58 +0200 received badge  Domanda notevole (source)
2019-10-04 06:49:09 +0200 ha commentato una domanda How to remove automatic field separators in text import in Calc

I have ordinary file with few hundreds of rows. Each "column" in file is separated by position e.g. first column is from

2019-10-04 06:38:37 +0200 received badge  Domanda gettonata (source)
2019-10-03 15:02:51 +0200 ha commentato una domanda How to remove automatic field separators in text import in Calc

I can't use "Separated by", because there is no character separator in my input text data. I get this data from our busi

2019-10-03 15:02:31 +0200 ha risposto a una domanda How to remove automatic field separators in text import in Calc

I can't use "Separated by", because there is no character separator in my input text data. I get this data from our busi

2019-10-03 12:25:35 +0200 ha commentato una domanda How to remove automatic field separators in text import in Calc

No. I want to import text file with few hundred of rows. But each row is pretty long. Now Libreoffice Calc automatically

2019-10-03 11:20:29 +0200 ha posto una domanda How to remove automatic field separators in text import in Calc

How to remove automatic field separators in text import in Calc In Libreoffice 6.2.7 open Calc and from File | Open menu

2019-08-15 09:11:37 +0200 ha commentato una risposta How to open embed PDF file in LibreOffice Writer?

I can also open PDF by double clicking on it in LibreOffice 6.2.5.2 on Ubuntu 16.04. Have you tried extracting Writer fi

2019-08-14 09:54:37 +0200 received badge  Domande famose (source)
2019-08-14 09:54:37 +0200 received badge  Domanda notevole (source)
2019-03-03 16:13:59 +0200 received badge  Domande famose (source)
2018-12-10 14:10:14 +0200 ha commentato una domanda How to open embed PDF file in LibreOffice Writer?

I can open your document in Writer and double click on it and PDF viewer opens and displays file just fine. Up until no

2018-12-10 13:55:17 +0200 received badge  Domanda gettonata (source)
2018-12-10 08:22:18 +0200 ha commentato una domanda How to open embed PDF file in LibreOffice Writer?

This is business important document that can't be send to public bug reporter. Digging into the problem I have found tw

2018-12-10 08:20:45 +0200 ha commentato una domanda How to open embed PDF file in LibreOffice Writer?

This is business important document that can't be send to public bug reporter. Digging into the problem I have found tw

2018-12-10 08:20:27 +0200 ha commentato una domanda How to open embed PDF file in LibreOffice Writer?

This is business important document that can't be send to public bug reporter. Digging into the problem I have found tw

2018-12-10 08:20:17 +0200 ha commentato una domanda How to open embed PDF file in LibreOffice Writer?

This is business important document that can't be send to public bug reporter. Digging into the problem I have found tw

2018-12-10 08:19:57 +0200 ha commentato una domanda How to open embed PDF file in LibreOffice Writer?

This is business important document that can't be send to public bug reporter. Digging into the problem I have found tw

2018-12-10 07:14:48 +0200 ha posto una domanda How to open embed PDF file in LibreOffice Writer?

How to open embed PDF file in LibreOffice Writer? Hi, I am using LibreOffice 6.1.3.2 on Windows7. Today I have got a Mi

2018-12-07 10:28:29 +0200 ha modificato una domanda How to preserve background cells colors or conditional colors when using filter in Pivot table?

How to preserve background cells colors or conditional colors when using filter in Pivot table? Hi, in LibreOffice 6.1

2018-12-07 10:27:58 +0200 ha modificato una domanda How to preserve background cells colors or conditional colors when using filter in Pivot table?

How to preserve background cells colors or conditional setting when using filter in Pivot table? Hi, in LibreOffice 6.1

2018-12-07 10:26:04 +0200 ha posto una domanda How to preserve background cells colors or conditional colors when using filter in Pivot table?

How to preserve background cells colors or conditional setting when using filter in Pivot table? Hi, in LibreOffice 6.1

2018-12-07 10:06:54 +0200 received badge  Domanda notevole (source)
2018-11-25 00:07:42 +0200 received badge  Domanda notevole (source)
2018-11-08 11:06:24 +0200 ha commentato una risposta How to set format=DATE in XML file to properly import in Calc?

I have got access to Microsoft Excel 2016 and above code works fine. Excel correctly displays the date in dd.mm.yyyy, bu

2018-11-07 20:56:47 +0200 ha commentato una risposta How to set format=DATE in XML file to properly import in Calc?

@Mike, I don't have Excel at the hand right now, to test this (I will test tomorrow). What you have written seems like a

2018-11-07 20:53:09 +0200 received badge  Domanda gettonata (source)
2018-11-07 20:08:48 +0200 ha commentato una risposta How to set format=DATE in XML file to properly import in Calc?

Thanks advices. I know dates are saved as integers. I don't want to use ODF format, because all sort of Excel versions a

2018-11-07 20:07:55 +0200 ha commentato una risposta How to set format=DATE in XML file to properly import in Calc?

Thanks advices. I know dates are saved as integers. I don't want to use ODF format, because all sort of Excel versions a

2018-11-07 15:19:17 +0200 ha posto una domanda How to set format=DATE in XML file to properly import in Calc?

How to set format=DATE in XML file to properly import in Calc? Hi, I have a program that generated XML file and this fil

2018-10-22 12:22:18 +0200 ha commentato una risposta How to bold a row in macro and how to auto-width columns?

Thanks a lot. It works exactly as I need.

2018-10-22 12:21:54 +0200 received badge  Sostenitore (source)
2018-10-22 12:21:49 +0200 ha accettato una risposta How to bold a row in macro and how to auto-width columns?

Hi,

I import data into Calc (LibreOffice 6.1.2) all the time. After I do that I always do two tasks:

  1. Mark whole row and bold it.
  2. Mark whole file and auto-width it.

I have recorded short video what I do: https://i.imgur.com/Q5yG2kh.gif

How to write a macro to do the above tasks?

Note: I have different number of columns in every data import, so solution should take into consideration that all of the cells in the row are bolded and all of the columns are auto-widthed.

Thanks

2018-10-18 17:24:15 +0200 received badge  Domanda gettonata (source)
2018-10-17 13:52:46 +0200 ha posto una domanda How to bold a row in macro and how to auto-width columns?

How to bold a row in macro and how to auto-width columns? Hi, I import data into Calc (LibreOffice 6.1.2) all the time.

2018-10-17 11:21:16 +0200 received badge  Domanda gettonata (source)
2018-10-15 14:01:49 +0200 ha accettato una risposta How to specify "else" condition in conditional formatting?

Hi,

I use LibreOffice 6.1.2 on Windows 7. In Calc I have large table with multiple columns. But on one column I would like to conditionally format the colors.

Simplified sample data:

City
Rome
Paris
London
Berlin
Madrid
(hundreds of other)

Now I would like to mark with green cells which contains cities: Rome, Paris and London and all remaining cities red (there is huge list of "red" cities, so I can't write conditional rule for each one).

I did:

  1. Mark City column.
  2. Format | Conditional | Condition.
  3. I have set:

    Condition 1: "Cell values is" "equal to" "Rome" Apply Style: Good.

    Condition 2: "Cell values is" "equal to" "Paris" Apply Style: Good.

    Condition 3: "Cell values is" "equal to" "London" Apply Style: Good.

    Question: Now how do define? Condition 4: All remaining cells Apply Style: Bad

Thanks

2018-10-15 14:01:43 +0200 ha commentato una risposta How to specify "else" condition in conditional formatting?

Thanks a lot. I see I can define "red" color background for whole column and then specify "conditional formatting" only

2018-10-15 13:31:07 +0200 ha modificato una domanda How to specify "else" condition in conditional formatting?

How to specify "else" condition in conditional formatting? Hi, I use LibreOffice 6.1.2 on Windows 7. In Calc I have la

2018-10-15 13:29:51 +0200 ha posto una domanda How to specify "else" condition in conditional formatting?

How to specify "else" condition in conditional formatting? Hi, I use LibreOffice 6.1.2 on Windows 7. In Calc I have la

2018-10-09 07:56:28 +0200 ha commentato una risposta How to start LibreOffice Calc and do some automatic tasks

I send and e-mail now. I hope I recognized the correct form. I have send you a file sample I use from the first post. An

2018-10-05 20:32:08 +0200 ha commentato una risposta How to start LibreOffice Calc and do some automatic tasks

I am using the file from my first post and that can also be seen from one of my videos above. Sorry I just can't figure

2018-10-05 20:31:42 +0200 ha commentato una risposta How to start LibreOffice Calc and do some automatic tasks

I am using the file from my first post and that can also be seen from one of my videos above. Sorry I just can't figure