Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: creating a calendar in writer - template help needet

  1. #1

    Default creating a calendar in writer - template help needet

    Dear Gentlemen,

    hope you are all right. Merry Christmas!!

    currently workin on a calendar for the new year - a dayly planner - diary!
    a GTD (Get things done thing) based on a diary with planner-options
    it is created in open office or /libre office

    see a overwiew of what is aimed:

    the question is: how do i get the months that are shown in the bottom - in the footer of the
    layout. How can i manage to get the months for the whole year.


    note: the months are shown below - for each week in each month we have some little overviews
    that show

    a. the current month
    b. the previous month
    c. the month that comes later

    see the document as it is: http://www.schulcenter.org/image_uploads/Buchkalender 02.odt

    see the examples for for more infos;



    note: that is an example for the month of march. Well - how can i do this for the whole year.
    It is pretty difficult to create the calendar in the bottom. Can you help me here..!?

    plz ask if i have to explain more deeply


    greetings


    see more infos here:


    btw: there are more infos that go into the calendar. i do a import of the data
    i import 365 texts called losungen that are biblical notes and verbs. see.

    note: no problem with the import of all those data: all that goes well and is no problem at all.
    see an example

    http://www.schulcenter.org/image_upl...alender_02.odt
    http://www.schulcenter.org/image_upl...alender_01.odt
    http://www.schulcenter.org/image_upl...h_calendar.jpg
    http://www.schulcenter.org/image_upl...lendar_one.jpg
    dilbert ;-)
    Wordpress-development - a Toolset: wpgear.org

  2. #2
    Join Date
    May 2010
    Location
    Space Colony Lagrange Point 22° à, 77° Ƅ, 56° ɤ, 99° ɜ
    Posts
    3,166

    Default Re: creating a calendar in writer - template help needet

    From day one openOffice supports html
    So i can just copy and paste calendar available online like this into the footer

    Calendar is from :-http://www.timeanddate.com/calendar/custom.html?year=2013&country=9&ctf=5&ctc=2&cdt=4&df=1

    sample :-
    http://paste.opensuse.org/images/83016772.png

    One more possibility is download calendar template from here http://www.vertex42.com/ExcelTemplat...-template.html
    copy paste into footer
    sample:-
    http://paste.opensuse.org/images/43361882.png
    GNOME Version 3.20.2
    openSUSE Leap 42.3 64-bit

    www.vazhavandan.blogspot.com

  3. #3

    Red face Re: creating a calendar in writer - template help needet

    Good Morning dear vazhavandan,


    Many thanks - this is a great posting and a very good sloution. i like your ideas very much:

    One more possibility is download calendar template from here http://www.vertex42.com/ExcelTemplat...-template.html
    copy paste into footer - sample:- http://paste.opensuse.org/images/43361882.png

    i love this solution derived from a vertex42 image very much.

    Question: Where to find this little tiny images: http://paste.opensuse.org/images/43361882.png

    i found this files below: do you mean those download links that can be found here:
    "For OpenOffice.org: Download our 12-month 2013 Calendar as an OpenOffice Calc spreadsheet template (.ots file):"






    dear vazhavandan can you give me the concrete donwload-link. I am a bit lost...;-)

    is it one of those both links;
    Thank You for Downloading the 2013 Calendar
    Thank You for Downloading the 2013 Calendar - Portrait


    look forward to hear from you - any and all help is greatly appreciated

    greetings - and have a great day!
    dilbert ;-)
    Wordpress-development - a Toolset: wpgear.org

  4. #4

    Default Re: creating a calendar in writer - template help needet

    hi there

    found it out - this one is it:
    Perpetual Calendar Template...

    Perpetual Calendar Template - Free Perpetual Calendar


    many many thanks

    greetings
    dilbert ;-)
    Wordpress-development - a Toolset: wpgear.org

  5. #5
    Join Date
    May 2010
    Location
    Space Colony Lagrange Point 22° à, 77° Ƅ, 56° ɤ, 99° ɜ
    Posts
    3,166

    Default Re: creating a calendar in writer - template help needet

    Quote Originally Posted by dilbertone View Post
    Good Morning dear vazhavandan,


    Many thanks - this is a great posting and a very good sloution. i like your ideas very much:




    i love this solution derived from a vertex42 image very much.

    Question: Where to find this little tiny images: http://paste.opensuse.org/images/43361882.png

    i found this files below: do you mean those download links that can be found here:
    "For OpenOffice.org: Download our 12-month 2013 Calendar as an OpenOffice Calc spreadsheet template (.ots file):"






    dear vazhavandan can you give me the concrete donwload-link. I am a bit lost...;-)

    is it one of those both links;
    Thank You for Downloading the 2013 Calendar
    Thank You for Downloading the 2013 Calendar - Portrait


    look forward to hear from you - any and all help is greatly appreciated

    greetings - and have a great day!
    I noticed that you are using 11.4 which has reached End Of Life(EOL). Consider upgrading to 12.1 and then 12.2
    I know that 11.4 has been adopted by Evergreen project but you may not be to install newer versions of software Eg:-Libreoffice

    Question: Where to find this little tiny images: http://paste.opensuse.org/images/43361882.png
    Answer:-
    This is what i did:-
    ==>download this zip:- http://www.vertex42.com/Files/ExcelCalendar.zip
    ==>Right click on zip and "Extract Here"
    ==>Navigate into the new folder. Open 2013-calendar.xls by double clicking
    ==>Open "2013"(first one) tab inside the spreadsheet
    ==>Copy from B5 : X12
    ==>Open new writer
    ==>click on plus in footer like this http://paste.opensuse.org/images/91911611.png
    ==>paste into footer and we are done :-)
    GNOME Version 3.20.2
    openSUSE Leap 42.3 64-bit

    www.vazhavandan.blogspot.com

  6. #6

    Default Re: creating a calendar in writer - template help needet

    hello dear vazhavandan,

    again many thanks that is very very good.

    well this helps me a lot.


    on my current step to finish the calendar i have some troubles with the formate.

    note: i do a import of 365 texts that are derived from Die Losungen - Gottes Wort f - see there the downloads.


    This should get into a diary-planner - layouted in a weekly fashion

    starting with monday on the left side and ending with sunday on the right site:

    see: http://www.schulcenter.org/image_upl...lendar_two.jpg


    with this calendar everything is all right - see all is nice.
    but if i want to import all the data i get into trouble.... then i get lost the sheme


    left side:
    monday
    tuesday
    wednesday


    right side:

    thursday
    friday
    saturday and sunday


    well - while finishing the calendar i have seen that i get into some issues that seems to damage this concrete layout-thing.

    see: http://www.schulcenter.org/image_upl...s-Kalender.zip
    where i have packed all togehter....;-)


    Can you give me some hints....

    look forward to hear from you

    greetings
    dilbert ;-)
    Wordpress-development - a Toolset: wpgear.org

  7. #7
    Join Date
    May 2010
    Location
    Space Colony Lagrange Point 22° à, 77° Ƅ, 56° ɤ, 99° ɜ
    Posts
    3,166

    Default Re: creating a calendar in writer - template help needet

    sorry,I don't know how to import the data from the spreadsheet to writer document
    Did you follow a process to import the data. If you do you have a link ?
    GNOME Version 3.20.2
    openSUSE Leap 42.3 64-bit

    www.vazhavandan.blogspot.com

  8. #8

    Default Re: creating a calendar in writer - template help needet

    hello my dear - many thanks for the reply

    you follow the steps of creating a serial letter.

    therefore we need the database

    take the document the odt - and save it locally
    the file contains filds for a serial letter that fit to the xls-file (database) that is contained in the zipped-file
    open the odt-file buchkalender 01.odt

    have a closer look and switch the view to "fieldnames" with f9
    afterwards you can go to -edit- and "exchange the database"
    choose the database and set it as the current database - click it.

    extras - "serial letter creation"

    document-type: letter

    follow the instructions


    if you have any question just lemme know . i come back later with more explanations

    until later
    dilbert ;-)
    Wordpress-development - a Toolset: wpgear.org

  9. #9

    Default Re: creating a calendar in writer - template help needet

    hello dear


    here another template - which also works with the database that is delivered in the zip-file.


    see
    http://www.schulcenter.org/image_upl...lage_7Tage_A5_[final]_experimental_30.odt

    http://www.schulcenter.org/image_upl...lage_7Tage_A5_[final]_experimental_30.odt



    you can see the field names and all that things.

    and with that template you can see how it woks
    the steps:

    edit / exchange the datbase - set it to the according db that is delivered with the zip
    extra: serial letter creation: follow the steps that you need to follow if you want to create a serial letter

    and finally you get the document with the inserted texts.

    note: with this one - it is no problem you should get a diary that looks exacly how it is neeedet:

    left side:


    monday
    tuesday
    wednesday

    right side:


    thursday
    friday
    saturday / sunday

    what is aimed: i want to have the more elaborated template - the buchkalender - template. it looks pretty impressive and has got all the nice features that are wanted and needet.
    so if we manage to get it with the above mentioned layout left side and right side accordingly then it would be great

    do not hesitate to ask if you have any question

    love to hear from you
    dilbert ;-)
    Wordpress-development - a Toolset: wpgear.org

  10. #10
    Join Date
    May 2010
    Location
    Space Colony Lagrange Point 22° à, 77° Ƅ, 56° ɤ, 99° ɜ
    Posts
    3,166

    Default Re: creating a calendar in writer - template help needet

    Quote Originally Posted by dilbertone View Post
    hello my dear - many thanks for the reply

    you follow the steps of creating a serial letter.

    therefore we need the database

    take the document the odt - and save it locally
    the file contains filds for a serial letter that fit to the xls-file (database) that is contained in the zipped-file
    open the odt-file buchkalender 01.odt

    have a closer look and switch the view to "fieldnames" with f9
    afterwards you can go to -edit- and "exchange the database"
    choose the database and set it as the current database - click it.

    extras - "serial letter creation"

    document-type: letter

    follow the instructions


    if you have any question just lemme know . i come back later with more explanations

    until later
    Got the body part . I think you did mail merge
    What about the footer? how was it created ?
    GNOME Version 3.20.2
    openSUSE Leap 42.3 64-bit

    www.vazhavandan.blogspot.com

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •