Re: [libreoffice-users] How to make chart out of a multi-sheet ods file ?

[shirish शिरीष]

at bottom :-

On 06/02/2017, Cley Faye <cleyf...@gmail.com> wrote:
> 2017-02-05 22:32 GMT+01:00 shirish शिरीष <shirisha...@gmail.com>:
>
>> Now what I want to do is to make chart from say either page 2 or page
>> 3 but unable to figure out how to do it ?
>>
>
> W
> ​hen creating a chart​, you can either prefix your intervals with
> $. or use the button on the right of each range input then
> change tab to get data from another sheet.
>
> Additionaly, to use multiple ranges (either on the same sheet or on various
> sheets) you can separate ranges using a semicolon, and/or add more data
> ranges in the chart assistant.
>
> For example, this is a multi-sheet multiple range
> string: $Sheet2.$A$1:$A$7;$Sheet1.$B$1:$C$7
>

Could you be a bit slow - Think of telling your 5 year old brother.

I am pretty poor at chart-making unfortunately :(

-- 
  Regards,
  Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
EB80 462B 08E1 A0DE A73A  2C2F 9F3D C7A4 E1C4 D2D8

-- 
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 make chart out of a multi-sheet ods file ?

[shirish शिरीष]

Dear Friends,

I want to make a chart from content in a multi-sheet file.

As an example to illustrate, I use
https://ec.europa.eu/home-affairs/sites/homeaffairs/files/what-we-do/policies/borders-and-visas/visa-policy/docs/2015_consulates_schengen_visa_stats_en.xlsx
. I converted the .xlsx to .ods using calligrasheets.

I was able to open the resultant file into libreoffice. See
https://dropfile.to/Sks88Py

Now what I want to do is to make chart from say either page 2 or page
3 but unable to figure out how to do it ?

I am running Libreoffice 5.2.4.2.1 on Debian testing -

[$] libreoffice --version

LibreOffice 5.2.4.2.1 20m0(Build:2)

Looking forward for a solution.

-- 
  Regards,
  Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
EB80 462B 08E1 A0DE A73A  2C2F 9F3D C7A4 E1C4 D2D8

-- 
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] Simple sum in column getting zero in libreoffice calc 5.

[shirish शिरीष]

at bottom :-

On 11/05/2016, Piet van Oostrum  wrote:



> The mailing list doesn't accept attachments. You could use Nabble for that
> (http://www.libreoffice.org/get-help/nabble/)
>
> The simplest explanation would be that your "numbers" are entered as text.
> Check your cell format.
> --
> Piet van Oostrum 
> WWW: http://pietvanoostrum.com/
> PGP key: [8DAE142BE17999C4]
>

Dear Piet,

Yours and a private mail are bang on target.  Libreoffice thinks that
those 'numbers' are text. This I was able to find via View > Value
highlighting .

Now non-plussed how to tell libreoffice to tell it to treat them as
'real numbers' ?

-- 
  Regards,
  Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
EB80 462B 08E1 A0DE A73A  2C2F 9F3D C7A4 E1C4 D2D8

-- 
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] Simple sum in column getting zero in libreoffice calc 5.

[shirish शिरीष]

Hi all,

I was trying a simple addition in column =SUM(B2:B8)

but that didn't work . I am getting the output as zero.

Could somebody look at it and share what is/was wrong ?

Sharing an example worksheet for the same.
-- 
  Regards,
  Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
EB80 462B 08E1 A0DE A73A  2C2F 9F3D C7A4 E1C4 D2D8

-- 
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] Tips and Extended Tips

[shirish शिरीष]

in-line :-

On Thu, Feb 23, 2012 at 10:01, v...@earthlink.net virgil.da...@gmail.com 
wrote:

snipped

 -
 The problem is actually in Kubuntu 11.10:
 Choose: (from application launcher)
 System Settings

Hi all,
@vda could you pray tell from where you are getting the System
settings. I do not see a System Settings in the Libreoffice Launcher.
By Application Launcher if you mean the GNOME Menu then that's a
different thing altogether ? Could you elaborate ? OR is this
something to do with Unity (which I've no clue about)

This is what libreoffice.org launcher looks like at my end. Mind you
this is on GNOME 3 fallback desktop with number of things opened (RAM
is full) and hence you are seeing it the way it is. It could also be a
bug but anyways that's not the point ATM.

I cannot/could not spot any System Settings within the Libreoffice.org
Launcher interface.

Looking forward to knowing more.

 Application Appearance (under common appearance and behavior)
 Colors
 SELECT TAB: Colors
 Color Set: Common Colors
 Tool Tip Text: Adjust to suit yourself
 Tool Tip Background: Choose something rational (not the same as tool tip
 text)
 Hope this helps.
 vda

-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
For unsubscribe instructions e-mail to: users+h...@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] Tips and Extended Tips

[shirish शिरीष]

in-line :-

On Sat, Dec 17, 2011 at 00:21, James E. Lang jim+...@lang.hm wrote:
 I have been having a problem with the Tips and Extended Tips in Calc for
 some time now. I believe the problem started when I upgraded my Kubuntu
 distribution to 11.10 (just in case that helps to identify the problem).

 My problem is that I cannot read them since the forground color (black?) and
 the background color (dark grey?) are so similar. I have not found a way to
 change the background color for these tips to something much lighter.

Curious to know how were you able to get the 'Tips' and 'Extended
Tips' in the first place.

 --
 Jim

-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
For unsubscribe instructions e-mail to: users+h...@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] Themes for libreoffice Impress ? Where to get more ? And how to create ?

[shirish शिरीष]

Hi all,
Quite a few questions I have on this one. I recently started
working on Libreoffice Impress. I am not much of a technical guy but
still will try to describe things.

Once I load Libreoffice Impress, the Window opens in three panes .
Going from left to right  it is :-

Pane A has the Slide Pane
Pane B is the workarea where you work on an individual slide
Pane C is the Task Pane.

I did see that these Panes can be viewed or unviewed by clicking on
View  and checking or/and unchecking Various Panes.

Anyways, going further on the topic, in Pane C i.e. Tasks Pane there
are similar drop-down panes which can be viewed or unviewed by
checking and unchecking the View drop-down menu within the Tasks pane.

One of the Check boxes is for Master Pages which I find interesting.

Master Pages has something similar to  'Themes' . I do not know if
this is the proper word or there should be some other word to describe
it. What it does is give a style and a look to a presentation.

Now my main question/query is where do I find more such themes at ?
Does anybody know any sites where such user-generated custom 'themes'
could be found ? Bonus points if one could browse them with keywords.

Also is there a how-to if one wants to create a custom 'theme' ?

Lastly if one did find such a theme how does one install it or use it.

I am on Debian sid - using Libreoffice 3.4.5

Thank you for your patience.
-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
For unsubscribe instructions e-mail to: users+h...@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] Tips and Extended Tips

[shirish शिरीष]

On Thu, Feb 23, 2012 at 02:03, Tom Davies tomdavie...@yahoo.co.uk wrote:
 Hi :)
 Annoyingly i think this is something to do with the theme of your OS.  Quite 
 why i don't know and why it hasn't been sorted out is also a bit of a 
 mystery.  Hopefully i am wrong but i think i remember this question being 
 asked last year sometime.

 Can you easily temporarily change you OSes theme to test it or would it be a 
 pain?
 Apols and regards from
 Tom :)

Tom,
Please at least address the person whom you are speaking to. I had to
look at it twice to understand that you were speaking to James E. Lang
(the OP) rather than to me.

snipped

-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
For unsubscribe instructions e-mail to: users+h...@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: Themes for libreoffice Impress ? Where to get more ? And how to create ?

[shirish शिरीष]

in-line :-

On Thu, Feb 23, 2012 at 03:06, Carson Chittom car...@wistly.net wrote:
 shirish शिरीष shirisha...@gmail.com writes:

 Now my main question/query is where do I find more such themes at ?
 Does anybody know any sites where such user-generated custom 'themes'
 could be found ? Bonus points if one could browse them with keywords.

 Try http://templates.libreoffice.org/template-center and use the
 Categories dropdown menu to select Presentation templates.  There is a
 search box there as well.

Dear Carson,
 Thank you for that link. I have a follow-up question. Let's say I
download a presentation template. Say the nature one
http://templates.libreoffice.org/template-center/nature . While you
can download the template and make copies of it and use it, there
doesn't seem to be a way to drag the 'template' from the .otp file to
the right-hand side for available to use so its there in case I need
it (sometime in future).

 --
 For unsubscribe instructions e-mail to: users+h...@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

-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
For unsubscribe instructions e-mail to: users+h...@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: Themes for libreoffice Impress ? Where to get more ? And how to create ?

[shirish शिरीष]

at bottom :-

2012/2/23 shirish शिरीष shirisha...@gmail.com:



 Dear Carson,
  Thank you for that link. I have a follow-up question. Let's say I
 download a presentation template. Say the nature one
 http://templates.libreoffice.org/template-center/nature . While you
 can download the template and make copies of it and use it, there
 doesn't seem to be a way to drag the 'template' from the .otp file to
 the right-hand side for available to use so its there in case I need
 it (sometime in future).

actually negate my query. I'm reading the documentation, maybe it will
work out. If not then will ask again :)

-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
For unsubscribe instructions e-mail to: users+h...@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 create libreoffice impress templates from scratch ?

[shirish शिरीष]

Hi all,
How does one create an .otp template. I looked and couldn't find
anything which gives precise instructions on making an .OTP template
from scratch.

I have couple of pictures which I want to be part of an .otp template.
Any idea how do I do that ?

I do know that you could make any presentation and then save that as
an template but that hasn't worked for me :(
-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
For unsubscribe instructions e-mail to: users+h...@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] [OT] does anybody how to get the no+mail subscription of libreoffice.org

[shirish शिरीष]

Hi all,
I have been trying (unsuccessfully I might add) for the past couple of
days to subscribe to the nomail version of the list . I did the
following :-

a. Send a mail with nothing on it to users+h...@libreoffice.org
b. From the mail received, sent another mail to
users+subscribe-nom...@libreoffice.org
c. Got a mail asking me to confirm that I'm subscribing to that version.
d. Confirmed it by hitting reply and adding nothing else. There was
some code (probably some sort of unique alphanumeric code identifying
me to the server)

I also got a mail saying that now I'm subscribed the no+mail version
of the list.

'BUT' I'm still getting mail from libreoffice.org  which does not have
me in the header or addressed to me in anyway. This obviously should
not happen.

Ideas, suggestions are all welcome. Should I simply 'unsubscribe' and
try subscribing to the nomail version straightaway or what ?

-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] The RTF export and import stuff

[shirish शिरीष]

In-line :-

On Wed, Dec 22, 2010 at 15:31, Tom Davies tomdavie...@yahoo.co.uk wrote:
 HI :)

Hi :)

 Snips are good.  Staying relevant is important :)

 I think rtf is inferior to odt.  The newer versions of MicroSquish Office 
 (2007
  2010) can both read odt now and odt is the one worth promoting most 
 strongly
 surely?

Yes and no. Look at it from two ways, yes in MS you may be able to
read in .odt but it would same as 'using an elephant to kill an ant'
or something like that. Ironically something similar was the basis of
Openoffice.org when they started long time back.

I am looking at the biggest base and the simplest format which can be
read by as many text-editors as can be read. The .rtf format achieves
that.

If I was a small device manufacturer then also .rtf would fit the
bill. There was talk of an odf-viewer but it was highly broken the
last time I saw it ~ over 2 years ago. So just because Microsoft is
playing ball doesn't mean its good or bad. I hope you are getting my
point.

Also I don't want to be in a place to push or give a single
alternative format, that's the reason we landed on the whole
openoffice.org in the first place.

 I can hopefully send some documents tomorrow (Thursday) when i work on the
 http://www.cecf.co.uk
 website.  Something with pictures but no macros and in various formats?  
 Short 1
 or 2 page documents or long, research articles?

I don't know if .rtf can read macros or not. If yes, that's also
great, honestly haven't seen that. The 1 or 2 pages long is good, but
better would be probably a spreadsheet, pictures or whatever good
combos think of. I don't know if Libreoffice has a sort of community
place where user-generated content could be put up. If there is such a
place, it would be good if you put it up there and just give me the
links, this way everybody gets a chance to also use that.

 Would documents need to have been done through LibreOffice?  I am still using 
 an
 older version of OpenOffice (still has the Sun logo) at the moment.  I am just
 waiting for the .deb to reach the Ubuntu repos or at least be easy to install.

I don't know which version of Ubuntu you are using, I had installed it
on Ubuntu 10.10 the last time I had access to a Ubuntu 10.10 release.
Couple of places which give you how you can do it.

http://www.mydailytechtips.com/2010/10/how-to-install-libreoffice-in-ubuntu.html

http://www.ubuntugeek.com/how-to-install-libreoffice-in-ubuntu-using-deb-packages.html

The latter is the way I did it in Debian and apart from having
openoffice.org shortcut in the menus everything else works fine.

Although doing it with libreoffice would be better, then we could also
check the implementation of that, see how the .rtf gets structured and
stuff like that.

It should be fun. I would have done the same but frankly I'm not a
document guy and don't have the skills to make good-looking documents.

 Many regards from
 Tom :)

snipped

-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://www.libreoffice.org/lists/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] The RTF export and import stuff

[shirish शिरीष]

Hi all,
 Few days/weeks ago I was browsing the net and came across the RTF
Export function about Libreoffice as somebody had done the same in GSOC.

http://vmiklos.hu/blog/libreoffice

as well as 
http://drewjensen.typepad.com/blog/2010/12/libreoffice-33-new-features.html

I wanted to know if there are some samples RTF's which I as a user
could download and see using the various text-editors see it.

Looking forward for some samples of the same or links where such
samples can be found.

-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://www.libreoffice.org/lists/users/
*** All posts to this list are publicly archived for eternity ***