Many thanks Damjan, i will continue working on the functions. Regards.
2015-12-19 10:19 GMT+02:00 Damjan Jovanovic <dam...@apache.org>: > 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. > > >> > >> >> >> > > > > >> > > > > > >> > >> >> >> > > > > >> > > > > >> > >> >> >> > > > > >> > > > >> > >> >> >> > > > > >> > > >> > >> >> >> > > > > > > > >> > >> >> >> > > > > > > > >> > >> >> >> > > > > > > >> > >> >> >> > > > > > >> > >> >> >> > > > > >> > >> >> >> > > > >> > >> >> >> > > >> > >> >> > > >> > >> > > > >> > >> > > > >> > >> > > >> > > > > >> > > > > >> > > > >> > > > > > > > > >
