Re: [libreoffice-users] Bar chart

2016-08-24 Thread Piet van Oostrum
love sidhu wrote:

 > Hi All,
 > 
 > I am working with libreoffice writer and I want to make an interactive pdf
 > form template having different fields, mostly created using developer mode.
 > 
 > Problem facing:
 > Most fields I am able to create but I wish to know whether is it possible
 > to create a bar chart
 > which changes it's values as per the user inputs after* we export it in pdf
 > format* ? Other fields(like text box etc) can be filled in pdf format but i
 > didn't find any information regarding barchart.
 > 
 > P.S. - Any help will be highly appreciated.
 > P.P.S.- I have attached the pdf and odt format for better understanding.
 > Thanks
 > Lovepreet
 > 
Attachments are not allowed on this mailing list. They are removed. You can 
either post your attachment somewhere in the cloud and include links, or use 
the Nabble interface (see http://www.libreoffice.org/get-help/nabble/).
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
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] Can dates change wrt a fixed date?

2016-08-24 Thread Brian Barker

At 16:11 23/08/2016 -0700, Oly Conly wrote:

I have multiple sets of dates (particular format), like this:
June 24, 2016
June 24, 2016
June 24, 2016
June 24, 2016
June 24, 2016
June 24, 2016

June 25, 2016
June 25, 2016
June 25, 2016
June 25, 2016

June 26, 2016
June 26, 2016
June 26, 2016
June 26, 2016

June 28, 2016
June 28, 2016
June 28, 2016
June 28, 2016

etc.

These is no specific pattern. Sometimes the dates are consecutive, 
sometimes the next date is after leaving out a few dates. Now if I 
change the first date "June 24, 2016" to "June 26, 2016" I want the 
other dates to chronologically change too, automatically ("June 27, 
2016", "June 28, 2016" and "June 30, 2016" respectively). Basically, 
can I fix the first date in a sheet and then make the rest of the 
date sets in relation to the fixed date, so that when the fixed date 
changes the rest change too accordingly.


Somewhere in the spreadsheet (this could be on another sheet if 
preferred), in an additional cell - say Xn - enter the starting date. 
Instead of "June24, 2016" in your actual column of dates, enter =X$n 
and fill down the six cells. Instead of "June 25,2016", enter =X$n+1. 
And so on. When you want to change the dates, just change the 
starting date in Xn.


I trust this helps.

Brian Barker


--
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] Can dates change wrt a fixed date?

2016-08-24 Thread oc
Hello,

I have multiple sets of dates (particular format), like this:
June 24, 2016
June 24, 2016
June 24, 2016
June 24, 2016
June 24, 2016
June 24, 2016

June 25, 2016
June 25, 2016
June 25, 2016
June 25, 2016

June 26, 2016
June 26, 2016
June 26, 2016
June 26, 2016

June 28, 2016
June 28, 2016
June 28, 2016
June 28, 2016

etc.

These is no specific pattern. Sometimes the dates are consecutive, sometimes
the next date is after leaving out a few dates. Now if I change the first
date "June 24, 2016" to "June 26, 2016" I want the other dates to
chronologically change too, automatically ("June 27, 2016", "June 28, 2016"
and "June 30, 2016" respectively). Basically, can I fix the first date in a
sheet and then make the rest of the date sets in relation to the fixed date,
so that when the fixed date changes the rest change too accordingly.

Can this be done?
Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/Can-dates-change-wrt-a-fixed-date-tp4191587.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



[libreoffice-users] Bar chart

2016-08-24 Thread love sidhu
Hi All,

I am working with libreoffice writer and I want to make an interactive pdf
form template having different fields, mostly created using developer mode.

Problem facing:
Most fields I am able to create but I wish to know whether is it possible
to create a bar chart
which changes it's values as per the user inputs after* we export it in pdf
format* ? Other fields(like text box etc) can be filled in pdf format but i
didn't find any information regarding barchart.

P.S. - Any help will be highly appreciated.
P.P.S.- I have attached the pdf and odt format for better understanding.
Thanks
Lovepreet

-- 
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