On Sat, Dec 19, 2015 at 2:59 AM, Ηρακλής Μουτίδης <imout...@gmail.com> wrote:
> 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? > A number of files under main/formula and main/sc change, but yes the actual implementation is in 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? > There is various possibilities, see https://wiki.openoffice.org/wiki/Documentation/Building_Guide_AOO#Partial_Builds The first time you should probably rebuild everything, passing --with-package-format="installed" to ./configure so you have a premade installation under main/instsetoo_native/<platform>/Apache_OpenOffice/installed/install/en-US/openoffice4/program that AOO can immediately be run from (--with-package-format="archive installed" does that and also builds the traditional tarball, but that takes much longer). After that you should only be tweaking files in main/sc, not main/formula, so you can use the "compatible build" in the above link. When you're down to making changes in only main/sc, you can even just run "build" in the main/sc directory, then run "deliver" to see which files it copies, and then overwrite those same files in your OpenOffice installation under main/instsetoo_native/<platform>/Apache_OpenOffice/installed/install/en-US/openoffice4/program with those, which is much faster than even the compatible build, as it doesn't rebuild the entire output tree. > and lastly will the functions in my case have any non scalar variables? > > That depends on how the function is defined in ODFF. For example the "Syntax" for the ROMAN function ( http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018832_715980110) takes Integer, and you can see how it's implemented in ScInterpreter::ScRoman() in main/sc/source/core/tool/interpr2.cxx. On the other hand, our unimplemented IFERROR ( http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018448_715980110) takes Any, so it probably does have to handle non-scalar variables. > I got a little overwhelmed by the project i hope i didn't ask anything > silly. > > Don't worry. Hope this helps. > Best regards, > Iraklis > Regards Damjan > 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. > >> > >> >> >> > > > > >> > > > > >> > >> >> >> > > > > >> > > > >> > >> >> >> > > > > >> > > >> > >> >> >> > > > > >> > >> > >> >> >> > > > > > > >> > >> >> >> > > > > > > >> > >> >> >> > > > > > >> > >> >> >> > > > > >> > >> >> >> > > > >> > >> >> >> > > >> > >> >> >> > >> > >> >> > >> > >> > > >> > >> > > >> > >> > >> > > > >> > > > >> > > >> > > > > >
