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