workin out a calendar for 2014: how to add 365 texts to a calc-template
 

hello dear Linux-experts,

well i am pretty new to all the opensource-things.

well this means that i am also new to calc- so sorry for being the "beginner"!



i have a calendar-template that contains entries - little text-chunks - and i also have a excel-sheet that contains 365 texts - those have to get imported into the Calendar-template. - see the attached files for more infos. Play around with the calendar-template.

note: the aimed data contain the following

a. the calendar-template (attachment a)
b. the excel-sheet - with the 365 text-chunks that have to get imported into the template (attachment b)


as the forum does not allow to add calc-attachments i cannout upoload them.



What is aimed - i want to have a weekly calendar for my own usage
To see what we allready have - take the calendar-template.

You see the calendar-template contains the fully-fledged view of the second week in 2014.

If you jump to the filed A 2 (- note it is green) in the calendar-template (attachment a) - here you see the date - actually the 2014-01-06. You can play around and see that the greek verses are allready included for the whole year. If you choose any date of the year - the greek verses in the template allready are added.

What is missing - are the additional text-chunks that are represented in the excel sheet.(b)

note. i have colored the fields in the calendar-template and the excel sheet with corresponding colors so we can see - which fileds have to get filled with which text-chunks of the excel-sheet. Addtionally the calendar-template contains the fully-fledged view of the second week in 2014.

Question. can we do a automated verison?

If you have any question - just dont hesitate to ask - i will try to explain it better.:)

greetings
say

attached files:
a. _calendar_2014_week_2_demo_excel_version - this is the caldendar template
b. _words_2014_365_days_excel_version - this is the addtional text sheet that contains the 365 text chunks - slogans

No attachment is attached.

(1) calc templates are just calc files saved as templates. When you "open a template", calc open a new "untitled" file with information from the template filled in.
(2) Next open the excel file in question using calc. (Dont close "Untitled").
(3) Find the corresponding pattern in the excel file and "Untitled" (the way to identify each of the 365 days).
(4) Using the appropriate formula, "import"/copy from the excel file to the "Untitled".
(5) Use "Save as" to save the "Untitled" file as the template.

Whats the exact problem, except that you need to figure out how to copy corresponding cell data from the excel file to the open calc file which we can't do and may not want to "play around" with?

OK

some in depth goning explanations and a question
 

i have a excel / or calc sheet that is somewhat broken and buggy.

every time i open it an close it - with

- a saving it gets brocken
- if i close the file - without any savings then it does not get broken


see the attached files


a - the original file - without any issues - not broken.
b - the broken one


just play with the file - it is a calendar

select the date - (in the green field) - see the drop-down menu
and choose any date.

then you see that all the fileds with the text-entries change - new texts were added

and - if you close the file - with or without savin then you see that

sometimes it gets broken some times not...

see the attached

a - the original file - without any issues - not broken.
b - the broken one

the two files

see them here: www.literaturen.org/uploads


since we cannot add xlsx or calc files here - i addet the files to the server:

http://www.literaturen.org/uploads/n...nder_2014_.ods
http://www.literaturen.org/uploads/b...der_2014_.xlsx



well what do you say ?


greetings
say

Actually Err:508 is "pair missing" ie. "Missing bracket or parenthesis; for example, closing brackets but no opening brackets".

Does your text have brackets? If so, please try prefixing it with \ and see the effect.

Regular practitioners in calc should keep the error list handy. I found mine some time back in a "document foundation" write up on calc called "0300CG3-CalcGuideLibO3.pdf" released for libre office. It has helped me on occasion to support users in open office also. Note that since all are forks of the same source, I expect basic error codes are the same.

OK

I found only 1 right bracket but 2 left brackets in the above supposedly working ods file in cell E5. Probably this repeats in all other cells.

OK