Re: Fwd: [libreoffice-users] FIPS 140-2 support with password-protected docs

[Stephan Bergmann]

On 04/01/2019 08:39, Heiko Tietze wrote:

Forwarding to the devloper list


[lets continue the discussion on the libreoff...@lists.freedesktop.org 
developer list]

 Weitergeleitete Nachricht 
Betreff: 	[libreoffice-users] FIPS 140-2 support with password-protected 
docs

Datum:  Thu, 3 Jan 2019 12:08:55 -0500
Von:Sean 
An: users@global.libreoffice.org



Hi, I just joined the list.  I'm a Linux system admin with (among
other things) about 20 CentOS 7.6 desktops under my wing.  Yesterday I
posted a question to the ASK site [1], because one of my users had
issues with password-protected docs after getting his new laptop.  I
now have confirmed that this issue is related to our desktops being
FIPS enabled ( kernel/grub2 with fips=1 ).

I joined the list to further this discussion and determine if I should
file a bug report or what.  The gist of the problem is that when FIPS
is enabled, a user can encrypt a document, but not decrypt the
document, and LO reports that the password provided was incorrect.  I
am not very technical with how LO does password protection, but this
seems like an bug.  FIPS causes the system to disable non-compliant
ciphers and algorithms, but I'm guessing that there is some piece of
code that's calling a non-compliant function only on decrypt, and not
on encrypt...or (less likely) the encrypt side isn't throwing an error
when it should.


I assume you are talking about encrypted ODF 1.0/1.1 documents (and not, 
say, PDF or some Microsoft-format documents).  ODF 1.0/1.1 used Blowfish 
for encryption, which is not sanctioned by FIPS mode, so trying to open 
such a document will indeed fail (with a somewhat unhelpful UI, claiming 
that any entered password is wrong).  That LO allows saving such an 
encrypted document would appear to be a bug with that version of LO.


Note that LO recently gained support to forward some of its 
cipher-related operations to OpenSSL, see 
 
"rhbz#1618703: Allow to use OpenSSL as backend for rtl/cipher.h".  In a 
recent LO built with --enable-cipher-openssl-backend, trying to save an 
encrypted ODF 1.0/1.1 document should indeed fail (see 
 
"Related rhbz#1618703: Properly handle failure encoding zip file").


There is also some vague plans to allow decryption of existing documents 
even in FIPS mode, and to improve the UI in cases of failure caused by 
FIPS mode, but nothing implemented as of now.  I don't think there's 
tracker bugs for that already at ; 
you could file such if you like (and please report back the ID(s) here).


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Cell style background colour

[Johnny Rosenberg]

Den tors 3 jan. 2019 kl 21:38 skrev Regina Henschel :

> Hi Johnny,
>
> Johnny Rosenberg schrieb am 01-Jan-19 um 22:58:
> > Sorry for bothering everyone again, but I can't find how to add colours
> to
> > the background colour palette. In older LibreOffice versions, or maybe it
> > was even Apache OpenOffice, I could add colours in Tools → Options… →
> > somewhere, but it seems to be removed. I miss quite a few colours in the
> > colour selection area in (right click a style) → Modify… → Background →
> > Background colour, so I want to add my own and give them names (other
> than
> > ”#15a3b7” or similar). I'm pretty sure I could do that in old versions,
> and
> > I guess it's still possible in today's versions, I just seem to not being
> > able to figure out how… What am I missing here?
>
> The general rule is, that adding colors happens at that place, where the
> color is used. Only very few dialogs are not yet changed.
>
> It depends on the version, which dialog is already adapted. The new
> dialog version for cell styles is not in version 6.0.7 or 6.1.4, but
> version 6.3 has it. I'm not sure about version 6.2.
>
> When ever you have a situation, where the new dialog is not yet
> available, you can take a different object, which already has the new
> dialog, to add your custom color, e.g. a shape. Draw a shape, use its
> area property, add your color, delete the shape, for example.
>

Yes, but I can't just figure out how to use a colour as a style background…
Well, I guess I could make a style adapt to changes in cells, then use that
style on a cell and change the background colour of that cell. Now the cell
style should have the same background colour.
But wait, isn't that feature (having cells adapt to changes in cell
formats) removed…? At least I can't find it. Even Excel has it… (as well as
older LibreOffice versions and, I think, Apache OpenOffice).


Kind regards

Johnny Rosenberg



> Kind regards
> Regina
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Cell style background colour

[Johnny Rosenberg]

Den fre 4 jan. 2019 kl 11:56 skrev Johnny Rosenberg :

> Den tors 3 jan. 2019 kl 21:38 skrev Regina Henschel <
> rb.hensc...@t-online.de>:
>
>> Hi Johnny,
>>
>> Johnny Rosenberg schrieb am 01-Jan-19 um 22:58:
>> > Sorry for bothering everyone again, but I can't find how to add colours
>> to
>> > the background colour palette. In older LibreOffice versions, or maybe
>> it
>> > was even Apache OpenOffice, I could add colours in Tools → Options… →
>> > somewhere, but it seems to be removed. I miss quite a few colours in the
>> > colour selection area in (right click a style) → Modify… → Background →
>> > Background colour, so I want to add my own and give them names (other
>> than
>> > ”#15a3b7” or similar). I'm pretty sure I could do that in old versions,
>> and
>> > I guess it's still possible in today's versions, I just seem to not
>> being
>> > able to figure out how… What am I missing here?
>>
>> The general rule is, that adding colors happens at that place, where the
>> color is used. Only very few dialogs are not yet changed.
>>
>> It depends on the version, which dialog is already adapted. The new
>> dialog version for cell styles is not in version 6.0.7 or 6.1.4, but
>> version 6.3 has it. I'm not sure about version 6.2.
>>
>> When ever you have a situation, where the new dialog is not yet
>> available, you can take a different object, which already has the new
>> dialog, to add your custom color, e.g. a shape. Draw a shape, use its
>> area property, add your color, delete the shape, for example.
>>
>
> Yes, but I can't just figure out how to use a colour as a style background…
> Well, I guess I could make a style adapt to changes in cells, then use
> that style on a cell and change the background colour of that cell. Now the
> cell style should have the same background colour.
> But wait, isn't that feature (having cells adapt to changes in cell
> formats) removed…? At least I can't find it. Even Excel has it… (as well as
> older LibreOffice versions and, I think, Apache OpenOffice).
>

Ok, found it, my bad. It was moved from inside the style modifying dialogue
to a button in the format panel. It didn't work in my corrupted file, but
when I created a new one from scratch it worked perfectly.
This will do for now, until I can do this directly inside the style
modifying dialogue in a future version of LibreOffice Calc.


>
>
> Kind regards
>
> Johnny Rosenberg
>
>
>
>> Kind regards
>> Regina
>>
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] what's the best way to make charts of spreadsheet data

[Regina Henschel]

Hi Dave,

Dave Howorth schrieb am 02-Jan-19 um 18:12:

[..]

My spreadsheet data is in columns. Column A is the dates and column B
is the times. Then ten columns of humidity data and eleven columns of
temperature data. There are currently just over 5000 rows of samples.

Making the chart was extremely slow. Every time I changed the Name of a
line of the chart I had to wait whilst it cycled through several steps
to make the change. Initially when I removed some empty columns from
the data range, it took an age to do so. etc.


Each data item produces an object, which is selectable in edit mode of 
the chart. Your data produce 5000*(10+11)=105000 objects. That cannot be 
fast.


What is the purpose of the chart? You do not need 105000 objects to 
illustrate something.


With 5000 items in x-direction a lot of them will be on top of others. 
My screen has only 1920 dots width and yours?




Now I've created the chart and got some reasonable lines across it, but
what I hope are the dates and times along the X axis are just a mess and
I've no idea how to make them display usefully.


I guess you have used a line chart. That x-axis cannot display time 
units, the smallest unit is day.
A line chart shows an axis label for each data item. That is likely not 
suitable for your chart.


You should try using an XY-chart.

In case you need different positions inside one day, you should make a 
separate column with added date and time values. Then use this column 
for your x-axis.




The Y-axis is reasonable from 0 to 120, although it would be nice to
trim the blank space at the top a bit, since the data can't exceed 100.

I haven't found any way to select individual points on the chart to
display the detailed value of that point or all the values at that
time.


Access to single points is only available in edit mode of the chart. The 
information of the point is shown as tooltip.


You can display the value of data points as data label. Enable it in 
edit mode in menu Insert > Data Label, or for a distinct point in its 
context menu "Insert Single Data Label".


In case you use an XY-chart you can generate a text column for labels 
Such are called 'category' in the dialogs. But there is only one text 
per row possible.


 Nor do I see a way to temporarily hide individual data lines to

more clearly see other particular lines, for example.


You can hide the associated column, then the line is removed from the 
chart. When you show the column, the line is drawn again.




If there's any way to do these things with an LO chart, and to speed it
up, I'd be grateful for any pointers. Or if there are better options
out there that can read .ods or .csv and display charts, that would also
be interesting.


It seems you want to explore your data. Some people have pointed to the 
R-project. But I have never used it. Or you might find suitable tools 
with search term 'data mining'.


Kind regards
Regina


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] what's the best way to make charts of spreadsheet data

[Dave Howorth]

On Fri, 4 Jan 2019 18:54:47 +0100
Regina Henschel  wrote:

> Hi Dave,
> 
> Dave Howorth schrieb am 02-Jan-19 um 18:12:
> >[..]
> > 
> > My spreadsheet data is in columns. Column A is the dates and column
> > B is the times. Then ten columns of humidity data and eleven
> > columns of temperature data. There are currently just over 5000
> > rows of samples.
> >
> > Making the chart was extremely slow. Every time I changed the Name
> > of a line of the chart I had to wait whilst it cycled through
> > several steps to make the change. Initially when I removed some
> > empty columns from the data range, it took an age to do so. etc.  
> 
> Each data item produces an object, which is selectable in edit mode
> of the chart. Your data produce 5000*(10+11)=105000 objects. That
> cannot be fast.
>
> What is the purpose of the chart? You do not need 105000 objects to 
> illustrate something.
> 
> With 5000 items in x-direction a lot of them will be on top of
> others. My screen has only 1920 dots width and yours?

Thanks, but this answers itself. If my screen or window has less
pixels, then why create more objects and try to represent them? The
chart software should be sampling the data appropriately to the
resolution.

And sure if I want to explore the detail, then I should be able to
expand a section of the X-axis. I'm thinking of something like the
graph module in emoncms, which handles this task with reasonable speed.

> > Now I've created the chart and got some reasonable lines across it,
> > but what I hope are the dates and times along the X axis are just a
> > mess and I've no idea how to make them display usefully.  
> 
> I guess you have used a line chart. That x-axis cannot display time 
> units, the smallest unit is day.
> A line chart shows an axis label for each data item. That is likely
> not suitable for your chart.

Correct, I'm using a line chart (i.e. the data I have are a number of
time series). Thanks for the info about how it behaves.

> You should try using an XY-chart.

Thanks. Yes, that seems to work better. It's a lot faster as well :)

> In case you need different positions inside one day, you should make
> a separate column with added date and time values. Then use this
> column for your x-axis.

Yes, I'd created the column and will use it.

> > The Y-axis is reasonable from 0 to 120, although it would be nice to
> > trim the blank space at the top a bit, since the data can't exceed
> > 100.
> > 
> > I haven't found any way to select individual points on the chart to
> > display the detailed value of that point or all the values at that
> > time.  
> 
> Access to single points is only available in edit mode of the chart.
> The information of the point is shown as tooltip.

I don't see any tooltips?

> You can display the value of data points as data label. Enable it in 
> edit mode in menu Insert > Data Label, or for a distinct point in its 
> context menu "Insert Single Data Label".
> 
> In case you use an XY-chart you can generate a text column for labels 
> Such are called 'category' in the dialogs. But there is only one text 
> per row possible.
> 
>   Nor do I see a way to temporarily hide individual data lines to
> > more clearly see other particular lines, for example.  
> 
> You can hide the associated column, then the line is removed from the 
> chart. When you show the column, the line is drawn again.

OK, thanks. That works but is a bit laborious.

> > If there's any way to do these things with an LO chart, and to
> > speed it up, I'd be grateful for any pointers. Or if there are
> > better options out there that can read .ods or .csv and display
> > charts, that would also be interesting.  
> 
> It seems you want to explore your data. Some people have pointed to
> the R-project. But I have never used it. Or you might find suitable
> tools with search term 'data mining'.

Thanks, I'll have a look. I might import the data into my emoncms
system.

> Kind regards
> Regina

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] what's the best way to make charts of spreadsheet data

[Remy Gauthier]

Hi,

You could also have a look here:

https://www.linuxlinks.com/plottingtools/

Rémy.

Le vendredi 04 janvier 2019 à 22:05 +, Dave Howorth a écrit :
> On Fri, 4 Jan 2019 18:54:47 +0100
> Regina Henschel  wrote:
> 
> 
> Hi Dave,
> 
> Dave Howorth schrieb am 02-Jan-19 um 18:12:
> 
> [..]
> 
> My spreadsheet data is in columns. Column A is the dates and column
> B is the times. Then ten columns of humidity data and eleven
> columns of temperature data. There are currently just over 5000
> rows of samples.
> 
> Making the chart was extremely slow. Every time I changed the Name
> of a line of the chart I had to wait whilst it cycled through
> several steps to make the change. Initially when I removed some
> empty columns from the data range, it took an age to do so. etc.  
> 
> Each data item produces an object, which is selectable in edit mode
> of the chart. Your data produce 5000*(10+11)=105000 objects. That
> cannot be fast.
> 
> What is the purpose of the chart? You do not need 105000 objects to 
> illustrate something.
> 
> With 5000 items in x-direction a lot of them will be on top of
> others. My screen has only 1920 dots width and yours?
> 
> Thanks, but this answers itself. If my screen or window has less
> pixels, then why create more objects and try to represent them? The
> chart software should be sampling the data appropriately to the
> resolution.
> 
> And sure if I want to explore the detail, then I should be able to
> expand a section of the X-axis. I'm thinking of something like the
> graph module in emoncms, which handles this task with reasonable speed.
> 
> 
> 
> Now I've created the chart and got some reasonable lines across it,
> but what I hope are the dates and times along the X axis are just a
> mess and I've no idea how to make them display usefully.  
> 
> I guess you have used a line chart. That x-axis cannot display time 
> units, the smallest unit is day.
> A line chart shows an axis label for each data item. That is likely
> not suitable for your chart.
> 
> Correct, I'm using a line chart (i.e. the data I have are a number of
> time series). Thanks for the info about how it behaves.
> 
> 
> You should try using an XY-chart.
> 
> Thanks. Yes, that seems to work better. It's a lot faster as well :)
> 
> 
> In case you need different positions inside one day, you should make
> a separate column with added date and time values. Then use this
> column for your x-axis.
> 
> Yes, I'd created the column and will use it.
> 
> 
> 
> The Y-axis is reasonable from 0 to 120, although it would be nice to
> trim the blank space at the top a bit, since the data can't exceed
> 100.
> 
> I haven't found any way to select individual points on the chart to
> display the detailed value of that point or all the values at that
> time.  
> 
> Access to single points is only available in edit mode of the chart.
> The information of the point is shown as tooltip.
> 
> I don't see any tooltips?
> 
> 
> You can display the value of data points as data label. Enable it in 
> edit mode in menu Insert > Data Label, or for a distinct point in its 
> context menu "Insert Single Data Label".
> 
> In case you use an XY-chart you can generate a text column for labels 
> Such are called 'category' in the dialogs. But there is only one text 
> per row possible.
> 
>   Nor do I see a way to temporarily hide individual data lines to
> 
> more clearly see other particular lines, for example.  
> 
> You can hide the associated column, then the line is removed from the 
> chart. When you show the column, the line is drawn again.
> 
> OK, thanks. That works but is a bit laborious.
> 
> 
> 
> If there's any way to do these things with an LO chart, and to
> speed it up, I'd be grateful for any pointers. Or if there are
> better options out there that can read .ods or .csv and display
> charts, that would also be interesting.  
> 
> It seems you want to explore your data. Some people have pointed to
> the R-project. But I have never used it. Or you might find suitable
> tools with search term 'data mining'.
> 
> Thanks, I'll have a look. I might import the data into my emoncms
> system.
> 
> 
> Kind regards
> Regina
> 
> 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] More problems with styles

[Johnny Rosenberg]

Sorry for bothering again, but how do I set certain things in a style to
”don't change”?
For instance, I have cell styles with different background colours that I
apply to cells in a sheet looking like a table with different borders and
things like that, for instance the first cell in a column has an upper
border line, the last one has a lower border line. When I apply a cell
style to these, the lines disappear and I have to add them again, manually.
Or if I add the lines to the style, they are also added where I don't want
them. Creating a style for each thinkable scenario is of course
overwhelming, and not a convenient way to go.
I just want to set all border lines to ”whatever was already there”, and I
thought I could, but it didn't work.
When I click a line in the border line section in the styles dialogue, a
line appears, if I click again the line turns thicker and grayer and a
third click removes the line again, but neither of those three states seems
to do what I want. Either lines are drawn or removed, never left untouched
when applying the style.
What am I missing?

Yes, even the bug-monster Excel can do this. :o


Kind regards

Johnny Rosenberg

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy