Re: [libreoffice-users] data point not distributed equally on charts with date on the X-axis

[Jean-Baptiste Faure]

Hi,

Le 10/06/2016 22:20, Harald Linden a écrit :
> Hello list,
> 
> I'm trying to visualize a few CSVs from my router. The original CSV
> contains the date in epoch plus a few zeroes. I have converted that to
> date using =(A2/1000)/86400+25569.
> 
> From that, I tried to generate a chart and the values pooled at certain
> points on the X-Axis, instead of distributing evenly. See an example here:
> 
> https://owncloud.7183.org/index.php/s/qf42u9QpP9YooHY
> 
> There are two charts in the document, the first labeled using the first
> column, the second labeled using the second column. Both should look
> equal, but obviously don't. Any idea why this happens and how to fix this?

Obviously, Calc uses the date instead of date+hour to define the
category. Why, I do not know. But it's clear that in this case you do
not have true categories because you have only one value for each
category. In such cases you should use XY chart type instead of line,
because what you want to show is a function F(t).

If you really want use line chart + categories, it works if you replace
the formula in column B by:
=TEXT((A2/1000)/86400+25569;"JJ/MM/ HH:MM:SS")

Another point: you should use a secondary Y-axis to make state changes
visible.

Best regards.
JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.
Disclaimer: my Internet Provider being located in France, each of our
exchanges over Internet will be scanned by French spying services.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: How to change dialog box font size?

[Edwar Cifuentes]

I found something interesting but it doesn't solve the problem:

I can use Options > Libreoffice > Fonts > and use Replacement table to 
replace my OS font by another font.
This works after I check "Use system font for user interface" in View 
options but I don't know how to use this Replacement table to also 
specify the size of the font that replaces the default font.


Example: since my default OS font is Droid Sans, I put "Droid Sans" in 
the Font field and "Liberation Sans" in the Replace With field and this 
replaces my OS font with the Liberation Sans font, but it's still very 
small. If I type "Liberation Sans 20" in the Replace With field instead 
(20 is my desired font size) it doesn't work, e.g. the default OS font 
doesn't change.


Maybe I'm not using the right syntax here.
Does anyone know how to specify the font size in the replacement table?

On 06/10/2016 07:20 AM, Edwar Cifuentes wrote:

Hi again.

First, I'm on Mint OS with xfce desktop, and I have LO 4 though this 
problem also happens with LO 5. The theme in the settings is "Default 
(Human)" and is the only one available.


I'm trying to make the LO application interface font bigger.

I changed my OS settings but this only affects the LO menus. The 
dialog boxes and other things like the status bar still have very 
small font.


I cannot use the User Interface scaling option because, since my menus 
are already bigger, after I have increased the scaling, the menus 
become Huge.


If I go the other way around, decreasing my OS font size, then I 
cannot read the text on other applications different from LO.


So what I need is either find a way to increase the dialogs' font 
sizes without increasing my Menus' font sizes, or find a way to 
decrease my Menus' font sizes without decreasing my OS font sizes.


Thank you.





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] data point not distributed equally on charts with date on the X-axis

[Harald Linden]

Hello list,

I'm trying to visualize a few CSVs from my router. The original CSV
contains the date in epoch plus a few zeroes. I have converted that to
date using =(A2/1000)/86400+25569.

From that, I tried to generate a chart and the values pooled at certain
points on the X-Axis, instead of distributing evenly. See an example here:

https://owncloud.7183.org/index.php/s/qf42u9QpP9YooHY

There are two charts in the document, the first labeled using the first
column, the second labeled using the second column. Both should look
equal, but obviously don't. Any idea why this happens and how to fix this?

Thanks!

Harald


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Question About Trojan Detection

[nasrin khaksar]

hi.
i read in one website if i am not make a mistake in libreofficeportable.org
that avast anti virus for its poor detection of trogens recognizes
libreoffice as trogen!

On 6/3/16, Tanstaafl  wrote:
> On 6/3/2016 11:13 AM, Joel Madero  wrote:
>> It'd be great if you inform McAfee about this - they consistently seem
>> to have issues with over aggressive detections that mislead users.
>
> Not to mention the fact that it misses lots of real threats.
>
> Anyone who uses Mcafee or Norton should rethink their decision.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>


-- 
Those who follow the Messenger-Prophet, the Ummi, whom they find
written down with them in the Taurat and the Injeel [who] enjoins them
good and forbids them evil, and makes lawful to them the good things
and makes unlawful to them impure things, and removes from them their
burden and the shackles which were upon them; so [as for] those who
believe in him and honor him and help him, and follow the light which
has been sent down with him, these it is that are the successful.
holy quran, chapter 7, verse 157.
best website for studying islamic book in different languages
al-islam.org

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Calc: background color in cells invisible

[Mike Scott]

On 10/06/16 11:14, JaquesJaquesLiverot wrote:
...

Our users have a mixture of versions of Excel and LibreOffice, and I wanted
to use the Excel file format because I want to password-protect the sheet
(and Calc told me that I can't do that with an ODS file).


Are you sure about that? 5.1.3.2 (linux) has two protection options 
under the Tools menu. IIRC it used to be in a different place though.



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Calc: background color in cells invisible

[JaquesJaquesLiverot]

I wonder if you're referring to an issue that I've discovered, which affects
4.5 and 5.1 under Windows 7 and Windows 7 - I haven't tried my Unbuntu
version yet.

I created a file in Excel, filling the background of the whole sheet with a
colour.  I opened it in LibreOffice, and it looked like this: 
http://virnuls.co.uk/documents/factorisation.xlsx
   - i.e. some of the
cells were not coloured.  I then coloured the background of all cells in
LibreOffice and saved the file again.  Excel shows the background as being
all green (other than the boxes for the answers), whereas LibreOffice has
additional white areas.

Our users have a mixture of versions of Excel and LibreOffice, and I wanted
to use the Excel file format because I want to password-protect the sheet
(and Calc told me that I can't do that with an ODS file).



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-background-color-in-cells-invisible-tp4176124p4185798.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Draw

[Bruce Hohl]

Robert,
Thanks for that comment on Evince for Windows.  It's "lighter" as in less
cluttered than Sumatra and includes a useful Annotations feature.

On Mon, Jun 6, 2016 at 7:45 PM, Robert Funnell 
wrote:

> David -
>
> Evince, mentioned by Bruce, also works under Windows.
>
> - Robert
>
>
> On Mon, 6 Jun 2016, DavidBTeagueAt Comporium.net wrote:
>
> Thank you Harvey, Stuart, and Bruce for useful information and suggestions.
>> I am a long time user of OO.org & LO, from the time of Star Office before
>> Sun. I am not a "power user" though I am a long time user.
>> I will investigate the pdf packages suggested.
>> With warmest regard
>> David
>>
>> On 6/6/2016 3:07 PM, Harvey Nimmo wrote:
>>
>>>  I find Master pdf Editor to be a useful tool. It is free form non
>>>  -commercial use. It can be a wee bit slow on my Linux openSUSE Leap
>>>  42.1 but has many features that you may have seen in Adobe Pro, and is
>>>  also available for Windows. See
>>>  https://code-industry.net/masterpdfeditor.
>>>  Cheers
>>>  Harvey
>>>  On Mon, 2016-06-06 at 11:49 -0700, V Stuart Foote wrote:
>>> >  DavidBTeagueAt Comporium.net wrote
>>> > >  In my search  for a cross platform (Linux/Windows) and preferably
>>> > >  GPL/free pdf reader.  I found that Draw does very well.
>>> > > > >  1) I would like an easy/easier way to move page to page in Draw.
>>> > > > >  2) Is there a way to do this?
>>> >  Draw is a component of the full LibreOffice suite, and  is not
>>> >  intended to
>>> >  be installed individually--although some Linux distros attempt to do
>>> >  that.
>>> > >  Draw is not a PDF editor or reader. It will perform a filter driven
>>> >  import
>>> >  of PDF as pages in a ODF Draw document converting content of the PDF
>>> >  to Draw
>>> >  objects.  Some PDF features implemented by Adobe are simply not
>>> >  implemented.
>>> > >  On export from Draw, or Writer or Impress or Math--filters are again
>>> >  used to
>>> >  render the content back into PDF--mostly compliant with PDF 1.5 spec
>>> >  with
>>> >  some additional options.
>>> > >  Once imported into LibreOffice (default is Draw, but filter import
>>> to
>>> >  Writer
>>> >  and Impress is also supported),  focus in the "Pages" frame allows
>>> >  movment
>>> >  between pages with PgDn and PgUp keys.
>>> > >  YMMV -- and please  accept this is the way LibreOffice (ApacheOpen
>>> >  Office
>>> >  and OpenOffice before) interact with PDF.
>>> > >  So if you can live with that, enjoy!
>>> > >  Stuart
>>> >
>>>
>>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] How to change dialog box font size?

[Edwar Cifuentes]

Hi again.

First, I'm on Mint OS with xfce desktop, and I have LO 4 though this 
problem also happens with LO 5. The theme in the settings is "Default 
(Human)" and is the only one available.


I'm trying to make the LO application interface font bigger.

I changed my OS settings but this only affects the LO menus. The dialog 
boxes and other things like the status bar still have very small font.


I cannot use the User Interface scaling option because, since my menus 
are already bigger, after I have increased the scaling, the menus become 
Huge.


If I go the other way around, decreasing my OS font size, then I cannot 
read the text on other applications different from LO.


So what I need is either find a way to increase the dialogs' font sizes 
without increasing my Menus' font sizes, or find a way to decrease my 
Menus' font sizes without decreasing my OS font sizes.


Thank you.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted