Dear Damjan, I am working on implementing the Calc functions. I am reading the guide (Calc/Implementations/Spreadsheet Functions) and got some questions. First of all the actual implementation of the function will be on one of the sc/source/core/tool/interpr?.cxx files? Second how can i run a simple test implementation? Do i have to rebuilt the whole project again? and lastly will the functions in my case have any non scalar variables?
I got a little overwhelmed by the project i hope i didn't ask anything silly. Best regards, Iraklis 2015-12-17 21:01 GMT+02:00 Ηρακλής Μουτίδης <imout...@gmail.com>: > Hi Damjan > > Thanks a lot. > > 2015-12-17 18:22 GMT+02:00 Damjan Jovanovic <dam...@apache.org>: > >> 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. >> > >> >> >> > > > > >> > > > >> > >> >> >> > > > > >> > > >> > >> >> >> > > > > >> > >> > >> >> >> > > > > >> >> > >> >> >> > > > > > >> > >> >> >> > > > > > >> > >> >> >> > > > > >> > >> >> >> > > > >> > >> >> >> > > >> > >> >> >> > >> > >> >> >> >> > >> >> >> > >> > >> > >> > >> > >> >> > > >> > > >> > >> > >
