Hi Iraklis Sorry, the link is http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html note the "l" at the end (.html instead of .htm)
Regards Damjan On Thu, Dec 17, 2015 at 5:45 PM, Ηρακλής Μουτίδης <imout...@gmail.com> wrote: > Dear Damjam, > > I started to work on the Calc functions you sugested. But the link for the > ODF formula specification at > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.htm > does > not work. > Is there any other website where i can get information about the formulas? > > Best regards, > Iraklis > > 2015-12-13 16:41 GMT+02:00 Ηρακλής Μουτίδης <imout...@gmail.com>: > > > Dear Damjan, Jatin and Wlada, > > > > I am going to start working on the issues Wlada suggested and the missing > > functions of Calc suggested by Damjan. > > Thanks a lot for your time. > > > > Jatin thank you for letting me know good luck on your project. > > > > Best regards, > > Iraklis > > > > 2015-12-13 2:15 GMT+02:00 Vladislav Stevanovic < > > stevanovicvladis...@gmail.com>: > > > >> Or this: > >> https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=78684 > >> > >> Regards, > >> Wlada > >> > >> 2015-12-13 1:04 GMT+01:00 Vladislav Stevanovic < > >> stevanovicvladis...@gmail.com>: > >> > >> > Hello Iraklis, > >> > > >> > If you're looking for something small, you could try to fix this (open > >> > attached Calc file). > >> > > >> > Regards, > >> > Wlada > >> > > >> > 2015-12-12 5:48 GMT+01:00 #PATHANGI JANARDHANAN JATINSHRAVAN# < > >> > jatinshr...@e.ntu.edu.sg>: > >> > > >> >> Hi Iraklis, > >> >> I have picked up the task to provide whole row/column > >> references > >> >> in Calc so if you don’t mind, could you please pick up an alternative > >> task? > >> >> > >> >> Thanks > >> >> Jatin > >> >> > >> >> > >> >> > >> >> On 12/11/15, 1:06 AM, "Damjan Jovanovic" <dam...@apache.org> wrote: > >> >> > >> >> >Hi Iraklis > >> >> > > >> >> >If you're looking for something small, you could try implementing a > >> few > >> >> >missing Calc functions from > >> >> > > >> >> > >> > https://wiki.openoffice.org/wiki/Calc/ODFF_Implementation/Examine_functions > >> >> >based on the guide at > >> >> > > >> >> > >> > https://wiki.openoffice.org/wiki/Calc/Implementation/Spreadsheet_Functions > >> >> >and the ODF formula specification at > >> >> > > >> > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.htm > >> >> . > >> >> >The IFERROR and ISNA functions would be good to have. > >> >> > > >> >> >There is no shortage of big things either :-). Here's a few off the > >> top > >> >> of > >> >> >my head: > >> >> >* An OOXML export filter would be a big help to our users, but I > think > >> >> >that's probably too difficult - the specification a 6000 page > >> document. > >> >> It > >> >> >might be possible to use the Apache POI project which already > provides > >> >> >OOXML reading and writing in Java. > >> >> >* Calc doesn't provide whole row/column references like C:C or 5:5 > >> while > >> >> >Excel does, which are helpful to use in implicit intersection, among > >> >> others > >> >> >(eg. in cell E34, you don't need to use D34 to refer to the cell > just > >> to > >> >> >the left, you can just type D:D and it will automatically use the > >> current > >> >> >row). > >> >> >* CSV file support in Base could be reimplemented to use the HSQLDB > >> >> >database which already supports CSV, which would allow the full > range > >> of > >> >> >SQL queries with joins, grouping, correlated subqueries, scalar > >> >> operators, > >> >> >and other advanced features that the current CSV file support > doesn't > >> >> >provide. This would also involve some work on HSQLDB to get CSV > >> parsing > >> >> >working exactly how it does now. Also spreadsheets are equally badly > >> >> >supported as a data source in Base, and by extending HSQLDB a bit, > the > >> >> >spreadsheet support could be reimplemented using HSQLDB to provide > the > >> >> same > >> >> >powerful query capabilities CSV would have. > >> >> > > >> >> >If you need other ideas, look through Bugzilla. Please let me know > if > >> you > >> >> >decide. > >> >> > > >> >> >Regards > >> >> >Damjan > >> >> > > >> >> >On Tue, Nov 24, 2015 at 11:49 PM, Ηρακλής Μουτίδης < > >> imout...@gmail.com> > >> >> >wrote: > >> >> > > >> >> >> Hi Damjan, > >> >> >> > >> >> >> I will have a look to the wikis. > >> >> >> I am also interested in your suggestions, so if you think that i > can > >> >> help > >> >> >> in something please let me know. > >> >> >> > >> >> >> Thank you for your time. > >> >> >> > >> >> >> Regards, > >> >> >> Iraklis > >> >> >> > >> >> >> 2015-11-22 19:48 GMT+02:00 Damjan Jovanovic <dam...@apache.org>: > >> >> >> > >> >> >> > Hi Iraklis > >> >> >> > > >> >> >> > Sorry for the late reply. > >> >> >> > > >> >> >> > Writer and Impress have their wiki pages on: > >> >> >> > https://wiki.openoffice.org/wiki/Writer > >> >> >> > https://wiki.openoffice.org/wiki/Impress > >> >> >> > > >> >> >> > Writer is our biggest user-facing application, double the size > of > >> the > >> >> >> next > >> >> >> > biggest (Calc). If you want to get started with them, finding > >> issues > >> >> with > >> >> >> > Bugzilla is probably best. I've never developed either, so if > you > >> are > >> >> >> still > >> >> >> > looking for development suggestions from me, they will have to > be > >> on > >> >> >> other > >> >> >> > things for now. > >> >> >> > > >> >> >> > Regards > >> >> >> > Damjan > >> >> >> > > >> >> >> > On Tue, Nov 10, 2015 at 10:25 PM, Ηρακλής Μουτίδης < > >> >> imout...@gmail.com> > >> >> >> > wrote: > >> >> >> > > >> >> >> > > Hi Damjan, > >> >> >> > > > >> >> >> > > I often use Writer and Impress and i can say that i am > >> interested > >> >> on > >> >> >> > these, > >> >> >> > > but i really dont know how it actually is to develope on them. > >> >> >> > > I think after completing some easy tasks i will able to say > >> what i > >> >> >> prefer > >> >> >> > > to do. I am open to suggestions and i hope with a little of > your > >> >> help i > >> >> >> > > will be ok. > >> >> >> > > > >> >> >> > > Thanks a ton for your time. > >> >> >> > > > >> >> >> > > Regards. > >> >> >> > > > >> >> >> > > 2015-11-10 20:56 GMT+02:00 Damjan Jovanovic < > dam...@apache.org > >> >: > >> >> >> > > > >> >> >> > > > Hi Iraklis > >> >> >> > > > > >> >> >> > > > That's great :-). > >> >> >> > > > > >> >> >> > > > Is there any areas of OpenOffice that interest you, or that > >> you > >> >> use > >> >> >> > > often? > >> >> >> > > > It's a large project, and it's hard to know what to suggest > >> you > >> >> get > >> >> >> > > started > >> >> >> > > > with. > >> >> >> > > > > >> >> >> > > > Regards > >> >> >> > > > Damjan > >> >> >> > > > > >> >> >> > > > On Mon, Nov 9, 2015 at 7:40 AM, Ηρακλής Μουτίδης < > >> >> imout...@gmail.com > >> >> >> > > >> >> >> > > > wrote: > >> >> >> > > > > >> >> >> > > > > Dear Damjan, > >> >> >> > > > > > >> >> >> > > > > I just finished compiling OpenOffice on Ububtu 14.04. > >> >> >> > > > > After a few failed attempts i finally did it :). > >> >> >> > > > > > >> >> >> > > > > Although i got an error message on the last installation > >> >> command > >> >> >> the > >> >> >> > > > > program works just fine. > >> >> >> > > > > the error was:( Processing triggers for shared-mime-info > >> >> >> > (1.2-0ubuntu3) > >> >> >> > > > ... > >> >> >> > > > > Errors were encountered while processing: > >> >> >> > > > > > >> >> >> > > > > > >> >> >> > > > > > >> >> >> > > > > >> >> >> > > > >> >> >> > > >> >> >> > >> >> > >> > unxlngx6.pro/Apache_OpenOffice/deb/install/en-US/DEBS/desktop-integration/openoffice4.2-debian-menus_4.2-9800_all.deb > >> >> >> > > > > ) > >> >> >> > > > > I will continue reading the links you provided. > >> >> >> > > > > > >> >> >> > > > > Regards, > >> >> >> > > > > Iraklis > >> >> >> > > > > > >> >> >> > > > > > >> >> >> > > > > 2015-11-06 14:38 GMT+02:00 Ηρακλής Μουτίδης < > >> >> imout...@gmail.com>: > >> >> >> > > > > > >> >> >> > > > > > Dear Damjan, > >> >> >> > > > > > > >> >> >> > > > > > Thanks for the info. > >> >> >> > > > > > I will start checking the code and read the wiki. > >> >> >> > > > > > > >> >> >> > > > > > I currently use Ubuntu 14.04 and Windows 7. > >> >> >> > > > > > > >> >> >> > > > > > Regards, > >> >> >> > > > > > Iraklis > >> >> >> > > > > > > >> >> >> > > > > > 2015-11-06 3:45 GMT+02:00 Damjan Jovanovic < > >> >> dam...@apache.org>: > >> >> >> > > > > > > >> >> >> > > > > >> Hi Iraklis > >> >> >> > > > > >> > >> >> >> > > > > >> Alright I'll prepare some easy things to get you > started. > >> >> >> > > > > >> > >> >> >> > > > > >> In the meanwhile you should probably start by checking > >> out > >> >> the > >> >> >> > > source > >> >> >> > > > > code > >> >> >> > > > > >> from SVN and getting it to compile: > >> >> >> > > > > >> http://openoffice.apache.org/source.html > >> >> >> > > > > >> > >> >> >> https://wiki.openoffice.org/wiki/Documentation/Building_Guide_AOO > >> >> >> > > > > >> > >> >> >> > > > > >> and do some reading on our website/wiki while it's > >> >> compiling: > >> >> >> > > > > >> > >> >> http://openoffice.apache.org/orientation/intro-development.html > >> >> >> . > >> >> >> > > > > >> > https://wiki.openoffice.org/wiki/Documentation/DevGuide > >> >> >> > > > > >> https://wiki.openoffice.org/wiki/Hacking > >> >> >> > > > > >> > https://wiki.openoffice.org/wiki/Source_code_directories > >> >> >> > > > > >> > >> https://wiki.openoffice.org/wiki/Architecture/Process_Flow > >> >> >> > > > > >> > >> >> >> > > > > >> What platform are you on? > >> >> >> > > > > >> > >> >> >> > > > > >> Regards > >> >> >> > > > > >> Damjan > >> >> >> > > > > >> > >> >> >> > > > > >> On Thu, Nov 5, 2015 at 10:10 PM, Ηρακλής Μουτίδης < > >> >> >> > > imout...@gmail.com > >> >> >> > > > > > >> >> >> > > > > >> wrote: > >> >> >> > > > > >> > >> >> >> > > > > >> > Hi Damjan, > >> >> >> > > > > >> > > >> >> >> > > > > >> > Really nice to be here. > >> >> >> > > > > >> > To be honest i dont have any ideas of what i want to > >> >> >> contribute > >> >> >> > > and > >> >> >> > > > > >> > somesuggestions to get me started would be great. > >> >> >> > > > > >> > Also any help or mentoring would be great too. > >> >> >> > > > > >> > > >> >> >> > > > > >> > Thanks for your quick reply. > >> >> >> > > > > >> > Hope i can help the project. > >> >> >> > > > > >> > > >> >> >> > > > > >> > Regards. > >> >> >> > > > > >> > > >> >> >> > > > > >> > > >> >> >> > > > > >> > 2015-11-05 19:43 GMT+02:00 Damjan Jovanovic < > >> >> >> dam...@apache.org > >> >> >> > >: > >> >> >> > > > > >> > > >> >> >> > > > > >> > > Hi Iraklis > >> >> >> > > > > >> > > > >> >> >> > > > > >> > > That's great, welcome to Apache OpenOffice :-). > >> >> >> > > > > >> > > > >> >> >> > > > > >> > > Do you have any idea of what you want to > contribute, > >> or > >> >> >> would > >> >> >> > > you > >> >> >> > > > > like > >> >> >> > > > > >> > some > >> >> >> > > > > >> > > easy development suggestions to get started? > >> >> >> > > > > >> > > > >> >> >> > > > > >> > > Feel free to email this mailing list with any > >> >> development > >> >> >> > issues > >> >> >> > > > or > >> >> >> > > > > >> > > questions, and if you'd like someone to mentor you, > >> I am > >> >> >> > > > available. > >> >> >> > > > > >> > > > >> >> >> > > > > >> > > Thank you > >> >> >> > > > > >> > > Damjan Jovanovic > >> >> >> > > > > >> > > > >> >> >> > > > > >> > > On Thu, Nov 5, 2015 at 12:08 PM, Ηρακλής Μουτίδης < > >> >> >> > > > > imout...@gmail.com > >> >> >> > > > > >> > > >> >> >> > > > > >> > > wrote: > >> >> >> > > > > >> > > > >> >> >> > > > > >> > > > Hello everyone my name is Iraklis Moutidis and I > >> am a > >> >> MSc > >> >> >> > > > student > >> >> >> > > > > at > >> >> >> > > > > >> > > > Computer Science Department of Aristotle > >> University of > >> >> >> > > > > Thessaloniki > >> >> >> > > > > >> > > > (Greece). I have 3 years experience with C++, > and 2 > >> >> years > >> >> >> > > > > experience > >> >> >> > > > > >> > with > >> >> >> > > > > >> > > > Java. I need to contribute to an open source > >> project > >> >> for > >> >> >> the > >> >> >> > > > > >> duration > >> >> >> > > > > >> > of > >> >> >> > > > > >> > > > this semester (ending in January). The main goal > of > >> >> the > >> >> >> > class > >> >> >> > > is > >> >> >> > > > > to > >> >> >> > > > > >> > write > >> >> >> > > > > >> > > > and contribute code to an open source project. I > >> was > >> >> >> hoping > >> >> >> > I > >> >> >> > > > > could > >> >> >> > > > > >> > help > >> >> >> > > > > >> > > > with Development 3- 4 hours a week for this time. > >> I am > >> >> >> also > >> >> >> > > > > >> interested > >> >> >> > > > > >> > to > >> >> >> > > > > >> > > > continue participating to the project after the > end > >> >> of my > >> >> >> > > class. > >> >> >> > > > > >> > > > > >> >> >> > > > > >> > > > > >> >> >> > > > > >> > > > Thanks in advance. > >> >> >> > > > > >> > > > > >> >> >> > > > > >> > > > >> >> >> > > > > >> > > >> >> >> > > > > >> > >> >> >> > > > > > > >> >> >> > > > > > > >> >> >> > > > > > >> >> >> > > > > >> >> >> > > > >> >> >> > > >> >> >> > >> >> > >> > > >> > > >> > > > > >
