Apache OpenOffice Wiki - User contributions [en]

Template:Calc Project

2010-12-06T12:59:35Z

Nn: category Add-In has a hyphen

{| align=right style="margin-left: 15px; border:1px solid #aaaaaa; background-color:#f9f9f9; padding:5px; font-size: 95%;" class=box
|---
!align=center style="background:#ccccff;" |

[[File:Calc Icon.png]]

'''''[[Calc|Calc Project]]'''''

Please view the [[Wiki Contribution Guidelines|guidelines]]
 before contributing.''
|-
|
'''''Popular Subcategories:'''''
<DPL>
category=+**Calc
namespace=Category
ordermethod=counter
order=descending
count=5
</DPL>
* [[:Category:Calc|... more Subcategories]]

'''''Internal Documentation:'''''
<DPL>
category=+Chart2
ordermethod=counter
order=descending
count=5
namespace=
</DPL>
* [[:Category:Chart2|... more Internal Documentation]]
'''''API Documentation:'''''

* [[:Category:Calc/API|Calc API articles]]
* [[Documentation/DevGuide/Spreadsheets/Spreadsheet_Documents |Guide about Spreadsheet]]
* [http://api.openoffice.org/ API Project Website]

'''''Calc Add-In:'''''
<DPL>
category=+Add-In
ordermethod=counter
order=descending
count=5
namespace=
</DPL>
* [[:Category:Add-In|... more Add-In]]

{{ListofProjects}}


[[Category:{{{Category|Calc}}}]]


|-
|'''[http://calc.openoffice.org Calc.OpenOffice.org]'''

<div class="plainlinks"> ''[[Template:Calc_Project|View]] or [{{SERVER}}{{localurl:Template:Calc_Project|action=edit}} edit] this template.''</div>
|}
<noinclude>
[[Category:Wiki Templates for Navigation]]
</noinclude>

Hackfest2010/Topics

2010-10-13T18:37:13Z

Nn: /* Mentors around */

{{DISPLAYTITLE:OpenOffice.org HackFest 2010 Topics}}

==Concrete Hacks==

Please add your ideas and topics you'd like to work on or mentor during the hackfest. Issues and/or features to be worked on should either be doable within two days, or at least could be given enough spin to be completed within a reasonable time and amount of effort after the hackfest. If available add links to the corresponding issue and possibly UX or other feature specifications.

Note that this is not an agenda and does not involve any schedule, we're "planning" more in an [http://www.unconference.net/ unConference] style, so about anything may go once the hackfest started. However, getting prepared for some tasks isn't bad either..

{| class="prettytable sortable"
|-
! Module || Topic || Remarks || Issue # || Mentor || Participants Interested
|-
| Calc || Fill operations should not touch filtered rows || A long outstanding issue that if solved would ease many people's itches.. A sketch of possible behavior is available at [[Calc/Drafts/Issue_33851#Fill_cells]] and [[Calc/Drafts/Issue_33851#Fill_series]] || {{Bug|89232}} || Eike Rathke [er] || Nehemiya MAMAN KAKALE Wolfgang Pechlaner {and you} ;-)
|-
| Writer || Unittests || How one creates unittests in the rather tightly coupled writer. || - || Bjoern Michaelsen [b_michaelsen] || Nehemiya MAMAN KAKALE {and you} {and you} ;-)
|-
| solenv || gbuild || The new GNU make based build system by the [[Build Environment Effort]]. || - || Bjoern Michaelsen [b_michaelsen] || {you} {and you} {and you} ;-)
|-| || || || || ||
|}

==Mentors around==

This is a list of hackers around, that are able to cover/mentor certain subject areas in the code base - if you have specific ideas/plans, poke them if they can help you with that.

{| class="prettytable sortable"
|-
! Modules || Mentor(OOo user name) || Participants Interested
|-
| Calc/I18N || Eike Rathke [er] || Nehemiya MAMAN KAKALE Wolfgang Pechlaner {and you} ;-)
|-
| Draw/Impress/VCL || Thorsten Behrens [thb] || Nehemiya MAMAN KAKALE {and you} {and you} ;-)
|-
| Draw/Impress/Drawinglayer || Armin Le Grand [aw] || Nehemiya MAMAN KAKALE {and you} {and you} ;-)
|-
| Writer || Cédric Bosdonnat [cedricbosdo] Bjoern Michaelsen [b_michaelsen] || Nehemiya MAMAN KAKALE {and you} {and you} ;-)
|-
| Calc || Niklas Nebel [nn] || {you} {and you} {and you} ;-)
|-
| || ||
|}

[[Category:Conferences]]

DomainDeveloper

2010-05-19T17:40:05Z

Nn: /* Developers */ my IRC handle

A mapping of names to OOo accounts.

Abbrev.:

* PL : Project Lead
* CL : Project Co-Lead
* CC : Community Council Member
* ESC : Engineering Steering Committee Member
* CVS : has write access to the OOo CVS repository

----

=== Developers ===

{| class="prettytable sortable"
|-
! Name || CVS || @openoffice.org || [[IRC Communication]] || Notes || Affiliation
|-
| [[User:Agerskov|Claus Agerskov]]|| || cs||Agerskov, cagerskov||PL Project Management Tool ([http://oopm.openoffice.org oopm])||AgerCon
|-
| Volker Ahrendt|| X || va||||||Sun Microsystems
|-
| Kai Ahrens|| X || ka || Kai_Ahrens ||PL Graphic Applications||Sun Microsystems
|-
| Rail Aliev || X || rail || rail || Ru and Tr NL Co-lead || Infra-Resource
|-
| Gene Anaya|| || ganaya||||||
|-
| [[User:JoostAndrae|Joost Andrae]]|| X || ja||ja_||CL qa, release testing en-US builds and releasing/uploading builds and releases||Sun Microsystems
|-
| [[User:ericb|Eric Bachard]] || X || ericb||ericb2|| PL Education, Mac OSX/Linux PPC port and vcl/impress hacker || [http://education.openoffice.org Education project], unaffiliated
|-
| Kai Backman|| || kaib ||KaiB||||
|-
| Sascha Ballach|| X || sab||||||
|-
| Jayant Balraj Madavi|| || jayant_madavi||aZEN_JM||Connectivity / Database||Novell, Inc.
|-
| Jörg Barfurth|| X || jb||JoergB||Configuration Util||Sun Microsystems
|-
| Omer Bar-or|| X || cremlae||cremlae||Mac porting||Google Summer of Code
|-
| Mathias Bauer|| X || mba||||PL Writer, CL Framework, XML||Sun Microsystems
|-
| Thorsten Behrens|| X || thb||thorsten||vcl/impress/toolkit visionary||Novell, Inc.
|-
| Thomas Benisch|| X || tbe||||Scripting framework||Sun Microsystems
|-
| Stephan Bergmann|| X || sb||||CL UDK||Sun Microsystems
|-
| Andreas Bille|| X || abi||||||
|-
| Éric Bischoff|| X || ebischoff||ebischoff||KDE A/B driver||Bureau Cornavin
|-
| Nick Blievers|| X || nick||||IRIX||
|-
| Daniel Boelzle|| X || dbo||||UNO core/bridges/packages||Sun Microsystems
|-
| Oliver Bolte|| X || obo||||RE||Sun Microsystems
|-
| [[User:Cedricbosdo|Cédric Bosdonnat]]|| X || cedricbosdo || cbosdonnat || Writer Filters, ooeclipse integration || Novell, Inc.
|-
| Rafaella Braconi|| || coni||Rafaella ||PL l10n, Globalization Program Manager||Sun Microsystems
|-
| Michael Brauer|| X || mib||||PL XML||Sun Microsystems
|-
| Oliver Braun|| X || obr||obr||System Integration/Accessibility Hacker||Sun Microsystems
|-
| Andreas Bregas|| X || ab||||StarBasic||Sun Microsystems
|-
| Jörg Brunsmann|| || jbrunsmann||||UDK||
|-
| Jörg Budischewski|| || jbu||PyUNO hacker||||
|-
| Peter Burow|| X || pb||plumbumm||UI||Sun Microsystems
|-
| Aidan Butler|| || aidan||||XML filters||
|-
| [[User:ScottCarr|Scott Carr]] || X || kcarr||kcarr||PL Documentation||Progbits
|-
| Giuseppe Castagno || X || beppec56 || beppec56_ or beppe_c || PDF output||
|-
| Colin Charles|| || drbyte||bytee||Malaysian native-lang project||bytebot.net
|-
|Jian Hong Cheng || X || chengjh || || Writer || IBM Corp.
|-
| Xiuzhi Cheng|| X || xzcheng || xiuzhi|| ESC,Xml,ODF|| OOo community
|-
| [[User:jza|Alexandro Colorado]]|| X || jza || jza|| CL [[OOoES|ES]] ||
|-
| Behrend Cornelius|| X || bc||||Wizards||Sun Microsystems
|-
| [[User:ccornell|Clayton Cornell]] || X || ccornell || ccornell || Documentation Project co-lead ||Sun Microsystems
|-
| Michael Cziebalski|| || mci||||||
|-
| [[User:pdefilippis|Pierre de Filippis]]|| X || pdefilippis||aliscafo||Mac OSX native porting||
|-
| Yuri Dario || || ydario || Paperino || OS/2 Port || Serenity Systems intl
|-
| Andrew Dent|| X ||ace_dent||ace_dent||ui/custom_images||
|-
| Naren Devaiah|| || ||ndev||Performance||Intel Corporation
|-
| Nitin Dongre|| || ||nitin_BITS||||Novell, Inc.(intern)
|-
| Radek Doulik|| || radekdoulik||rodo_||Canvas hacker||Novell, Inc.
|-
| Carsten Driesner|| X || cd|| cd_oo ||PL Framework||Sun Microsystems
|-
| Herbert Duerr|| X || hdu||hdu_hh||GSL||Sun Microsystems
|-
| [[User:bei|Bernd Eilers]]|| X || bei||rfc821||[[EIS]]||Sun Microsystems
|-
| René Engelhard|| X || rene||_rene_||config_office, Debian packager||Debian
|-
| [[User:Pereriksson|Per Eriksson]] || || pereriksson || || CL, MarCon Sweden ||
|-
|[[User:Jbfaure|Jean-Baptiste Faure]]||X||jbfaure||jbfaure ||PL FR native-lang project||
|-
| Hubert Figuière|| X || hub || hub || PPTX || Novell, Inc.
|-
| Claudio F Filho|| || filhocf||filhocf||Brazilian portuguese Localization||BrOffice.org
|-
| Andre Fischer|| X || af||||Impress||Sun Microsystems
|-
| Uwe Fischer || X || ufi || ufiooo || Application Help || Sun Microsystems
|-
| Ken Foskey|| || waratah||waratah||config_office/dmake man||slug.org.au
|-
| Duncan Foster|| || dfoster||||||
|-
| David Fraser|| || davidfraser||davidfraser||South African translations, multilingual builds||translate.org.za
|-
| [[User:Nf|Nils Fuhrmann]]|| || nf||SunNF||||Sun Microsystems
|-
| Martin Gallwey|| X || mtg||marty_||XML/Writer/packaging||
|-
| Pierre-Andre Galmes || || pagalmes || pagalmes || Chart2 ||StarXpert
|-
| Tony Galmiche|| X || tonygalmiche||||FR native-lang project||
|-
| Sunil Gandhi|| || ||tyro||||NOSIP
|-
|Zemin Gao || || gaozemin|| gaozm || Calc || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| Sophie Gautier|| X || sgauti|| sophi || ||.
|-
| Vladimir Glazounov|| X || vg||||RE||Sun Microsystems
|-
| Laurent Godard || X || laurentgodard || lgodard || CC, PL Extensions, Fr Native-lang Project || inDesko/Nuxeo
|-
| Jody Goldberg|| X || jodygoldberg||jody||[[Calc]] spreadsheet-ness||
|-
| Dirk Grobler|| X || dg|||| ||Sun Microsystems
|-
| [[User:Sg|Steffen Grund]]|| X || sg|| || NetBeans Integration ||Sun Microsystems
|-
| Bettina Haberer|| || bh||||RFEOwner||Sun Microsystems
|-
| Bo Han || X || hanbo || hanbo || VBA Interop || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| Ingrid Halama|| X || iha||||Chart||Sun Microsystems
|-
| Chris Halls|| X || haggai||haggai||Debian packager&misc. hacker||Credativ Ltd., Debian
|-
| Gregor Hartmann|| X || gh|| Lachs ||Testtool, gsicheck, buildbot||Sun Microsystems
|-
| Bustamam Harun|| || bustamam||||Malaysian stuff||
|-
| Kevin Hendricks|| X || khendricks||||PL Lingucomponent, PowerPC||
|-
| Con Hennessy|| || cphennessy||cph2 or cph_||hacker & former council person||OpenApp
|-
| Ivo Hinkelmann|| X || ihi||ivo||l10n tooling/general/RE||Sun Microsystems
|-
| Eric Hoch|| X || maveric||mav_eric||Mac Porting||
|-
| [[User:Lutz_Hoeger|Lutz Hoeger]]|| X || lh ||lutzh||||Sun Microsystems
|-
| Michael Hönnig|| X || mi||||PL API||
|-
| Ilko Höpping|| X || ih||||||Sun Microsystems
|-
| Jan Holešovský|| X || kendy||kendy||KDE integration||Novell, Inc.
|-
| Martin Hollmichel|| X || mh||Ratte/Nesshof||PL External, Tools, Porting, CC||Sun Microsystems
|-
| Karl Hong|| X || khong||||i18n, CJK expert||
|-
| [[User:icobgr|Hristo Hristov]] || || icobgr || icobgr || PL Bulgarian native-lang project ||
|-
| Matthias Huetsch|| X || mhu||||Performance/strategy, PL UCB, CC, ESC||Sun Microsystems
|-
| Sven Jacobi|| X || sj||||Escherwizard||Sun Microsystems
|-
| Jörg Jahnke|| || jj||||tooling||Sun Microsystems
|-
| Pavel Janík|| X || pjanik||paveljanik||PL Czech native-lang project, CL l10n, CC, ESC, l10n builds||
|-
| Sunil Amitkumar Janki || || sjanki || sjanki || GNU Linux mipsel porter ||
|-
| Christian Jansen|| || cj ||||Menu and Toolbar?||Sun Microsystems
|-
| Ocke Janssen|| X || oj||Base||||Sun Microsystems
|-
| Berry Jia|| X || berryjia||||||
|-
| Mingfei Jia || X || jiamingfei || || Lotus Smart Suite filter,MS Word encryption || IBM Corp.
|-
| Chuang Jiang || || jiangc || || || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| Pascal Junck|| || pjunck||||||
|-
| [[User:pj@openoffice.org|Peter Junge]]|| X || pj|| peter13j|| OOo community contact ||
|-
| Christian Junker|| || Cyb||christianju||API||Trees For Life
|-
| Etsushi Kato || X || ekato || || Mac OS X Port || Independent
|-
| Hirano Kazunari|| || khirano||||Japanese||
|-
| Mihaela Kedikova|| X || misheto||||grid control||Sun Microsystems
|-
| Dhananjay Keskar|| X || dkeskar ||dkeskar||Performance,Buildbot,cat-herder||Intel Corporation
|-
| Volodymyr Khrystynych|| || volody||||XML Filter||
|-
| Robert Kinsella|| || rkinsella||||||Sun Microsystems
|-
| Matthias Klose|| || doko||doko||Ubuntu, gcc, python packager||Canonical, Inc.
|-
| Laszlo Kovacs|| || lkovacs||||Documentation||
|-
| Tobias Krause|| X || tkr||||ucb||Sun Microsystems
|-
| Martin Kretzschmar|| X || mkretzschmar||martink||Gnome / Debian||Student
|-
| Will Lachance|| || wlach||wlach_||Word Perfect File Filters||Net Integration Technologies, Inc.
|-
| Marcus Lange|| X || mla||mla||[http://download.openoffice.org download websites], uploading/releasing developer snapshots and releases||Sun Microsystems
|-
| Thomas Lange|| X || tl||tl13||||Sun Microsystems
|-
| Lars Langhans|| X || lla||||||Sun Microsystems
|-
| Hans-Joachim Lankenau|| X || hjs||ause||dmake makefile expert, RE||Sun Microsystems
|-
| Németh László|| X || nemeth||||PL lingucomponent||
|-
| Jakob Lechner|| X || jakob_lechner||||Writer||Fabalabs
|-
| Michael Leibowitz|| X || mikeleib ||mikeleib||performance||Intel Corporation
|-
| Hui Li|| || lihuiibm || Hui_Li ||VBA Interop||IBM Corp.
|-
|Jian Li|| || lijian || lijian|| Writer|| CS2C
|-
| Wind Li|| X || windly||||Address books||
|-
| Xing Li || X || lixxing || || Accessibility || IBM Corp.
|-
|Weike Liang || || liangweike || liangweike || Graphics || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| Ping Liao|| || pliao||||||
|-
| Tor Lillqvist|| X || tml||tml_||||Novell, Inc.
|-
| Fong Lin || X || pflin || Fong || VBA Interop, Scripting, CJK Enhancement || Novell, Inc.
|-
| Joachim Lingner|| X || jl||||Java, CLI||Sun Microsystems
|-
| Christian Lippka|| X || cl || cl ||Graphic Applications||Sun Microsystems
|-
| Chen Liu|| || liuchenn|| liuchen ||VBA Interop||IBM Corp.
|-
|Jianli Liu || || liujl|| liujianli || Graphics|| [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| Mindy Liu|| || mindyliu||||||
|-
|[[User:liutao |Tao Liu]] || X || liutao || liutao ||PL modularization ,PyUNO, Async dialogs,||
|-
| YiSong Liu|| || Liu YiSong || Liu YiSong|| PYUNO || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
|Yu Liu || X || ch2000liuy || LiuYU || Swriter || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
|Yuhua Liu || || liuyuhua|| yuhua|| ||[[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| [[User:fl|Frank Loehmann]]|| X || fl ||frankl||PL [http://ux.openoffice.org User Experience]||Sun Microsystems
|-
| [[User:Dl|Dieter Loeschky]]|| X || dl ||||PL: ODF Toolkit||Sun Microsystems
|-
| Philipp Lohmann|| X || pl||PhilippL||VCL/X11 (GSL) hacker||Sun Microsystems
|-
| Michel Loiseleur|| || mloiseleur|| coren`|| Bugfixes ||Linagora
|-
| Jackson Low|| X || xxjack12xx||||Porting||
|-
| Patrick Luby|| || pluby||||Mac||
|-
|Jingrong Luo || || Luo Jingrong|| Luo Jingrong|| ||[[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
|Yue Lv || || lvyue || lvyue || Calc ||[[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
|[[User:majun|Jun Ma]]|| ||majun51 || || writer || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| Prasad Madhav || X || pmadhav || pmadhav || Buildbot || Intern@Intel
|-
| Babak Mahbod|| || bmahbod||||||
|-
| Martin Maher|| || mmaher||||Writer & Filter chap||
|-
| Nakata Maho|| X || maho||_maho_||PL QA, PL JA, FreeBSD guy||Independent
|-
|Yonggang Mao || X || maoyonggang|| maoyg|| Calc || CS2C
|-
| John Marmion|| X || jmarmion||||||
|-
| Andreas Martens|| X || ama||||PL Writer||Sun Microsystems
|-
| Shane M Mathews|| X || smmathews|| smmathews ||[[Impress:_OpenGL_rendered_transitions]]||student
|-
| Frank Mau|| X || fma||||tooling||Sun Microsystems
|-
| [[User:smsm1|Shaun McDonald]] || X || smsm1 || shaunmcdonald || Mac Port, buildbot MacPort1 || Graduate
|-
| Caolán McNamara|| X || cmc||caolan||CL Writer & Filter man|| [http://www.redhat.com Red Hat Inc.]
|-
| Michael Meeks|| X || mmeeks||michael_||ugly hack-er, ESC||Novell, Inc.
|-
| Frank Meies|| X || fme||||Writer||Sun Microsystems
|-
| Federico Mena-Quintero|| || federicomena||federico||perfectionist||Novell, Inc.
|-
| Ismael Merzaq|| X || isma87||ismael_||Mac OSX native porting||Student
|-
| Michael Mi|| || mmi||||||
|-
| Björn Michaelsen|| X || b_michaelsen ||b_michaelsen|| Writer, Bookmarks, Performance, User Feedback Program ||Sun Microsystems
|-
| Björn Milcke|| X || bm||bm_||Chart||Sun Microsystems
|-
| Petr Mladek|| || pmladek||pmladek||SUSE RPMs, ooo-build releases||Novell, Inc.
|-
| Cyrille Moureaux|| X || cyrillem||Cyrille||||
|-
| [[User:Mmp|Matthias Müller-Prove]]|| X || mmp|| mprove|| [[User Experience]] || Sun Microsystems
|-
| [[User:Bluedwarf|Takashi Nakamoto]]|| || bluedwarf|| || Japanese || Student
|-
| Jan Navrátil || X || jnavrati || jnavrati || || [http://www.redhat.com Red Hat Inc.]
|-
| Niklas Nebel|| X || nn||niklasn||PL [[Calc]]||Sun Microsystems
|-
| Christoph Neumann|| X || cn||||[[UnoApiTest]]||Sun Microsystems
|-
| Frank Neumann|| X || fne||||MacPort||
|-
| NicelKM|| X || mnicel||nicel||||Novell, Inc.
|-
| Jan Nieuwenhuizen|| X || jcn||janneke||Layout code, hacker ||Novell, Inc.
|-
| [[User:ChristophNoack|Christoph Noack]]|| X || christophnoack ||christoph_n||CL [http://ux.openoffice.org User Experience]||
|-
| Bertram Nolte|| || bnolte||||||
|-
| Tomas O'Connor|| || toconnor||||Scripting Framework||
|-
| Maximilian Odendahl|| X || mod||mod||[[Notes2]] [[SQL_Syntax_Highlighting]]|| Student / SEPT-Solutions
|-
| Takashi Ono || X || tono || || MinGW port || Independent
|-
| Lars Oppermann|| X || lo||||||
|-
| Rakesh Pandit || X || rakeshpandit|| chacha_chaudhry|| Education Project - Starmath/fix module warnings|| Education Project
|-
| Rodrigo Parra Novo|| X || rodarvus||rodarvus||Gnumeric/Abiword OpenDocument Format support and port to Maemo||INdT (Instituto Nokia de Tecnologia)
|-
| Pierre Pasteau|| X || pastea_p || pierrep|| Education Project, SeaMonkey migration || Education Project
|-
| Edward Peterlin|| X || OPENSTEP||||Mac||
|-
| [[User:Fpe|Frank Peters]]|| X || fpe||||CL Documentation||Sun Microsystems
|-
| Christof Pintaske|| X || cp||||||Sun Microsystems
|-
| Ron Piterman|| || rpiterman||||||
|-
| Sebastien Plisson|| X || plipli||plipli||Developer on Aqua port||OO Aqua Port
|-
| Noel Power|| || npower||noelp||VBA Interop, Scripting||Novell, Inc.
|-
| Nikolai Pretzell|| X || np || ||Autodoc, code quality||Sun Microsystems
|-
| Jonathan Pryor|| || jpryor || jonp || || Novell, Inc.
|-
| Canghua Qu|| || quch || Canghua || AutoTest, Graphics || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| Volker Quetschke|| X || vq||vq||W32-tcsh/bash build environment and dmake Hacker, ESC||Gravity Waves
|-
| Tino Rachui|| X || tra||tinor||GSL/Unix Hacker||Sun Microsystems
|-
| Goran Rakić || X ||goranrakic || || Serbian Native-Lang PL ||
|-
| [[User:Kr|Kay Ramme]]|| X || kr||||PL UDK||Sun Microsystems
|-
| [[User:ErAck|Eike Rathke]]|| X || er||erAck||CL [[Calc]], engine; CL i18n; stricken with number formatter||Sun Microsystems
|-
| Michael Rauch|| X || mrauch||||NetBSD||
|-
| Jens-Heiner Rechtien|| X || hr||blauwal||RE; OOo SCM (CVS, CWS tooling); Porting; Compilers||Sun Microsystems
|-
| Daniel Rentz|| X || dr|| drr ||[[Calc]] Excel filter, UI||Sun Microsystems
|-
| Florian Reuter|| X || flr||||Writer filters||Novell, Inc.
|-
| Georg Richter|| X || grichter||georg||Base, native MySQL driver||MySQL AB
|-
| G. Roderick Singleton|| || grsingleton||grsingleton||Documentation||pathtech.org
|-
| Hennes Rohling|| X || hro||||GSL & Util||Sun Microsystems
|-
| Bibek Sahu|| || Bibek||bibek||Impress pieces||Trees For Life
|-
| Andreas Schlüns|| X || as||||Framework||Sun Microsystems
|-
| Ingo Schmidt|| X || is||||(Native) Installation||Sun Microsystems
|-
| [[User:Jsc|Jürgen Schmidt]]|| X || jsc||jsc||PL API, PL Extensions, UNO, SDK||Sun Microsystems
|-
| [[User:Schmidtm|Matthias Schmidt]] || || schmidtm || schmidtm || Mac OSX Aqua Port || Sun Microsystems
|-
| Stephan Schäfer|| X || ssa||ssa||VCL||Sun Microsystems
|-
| Frank Schönheit|| X || fs||FrankS||Database Access, Forms||Sun Microsystems
|-
| [[User:Sus|Svante Schubert]]|| X || sus||Svante||XML & ODFTOOLKIT co-lead, ODFDOM project chair, Member of OASIS ODF TC, OASIS OIC TC, OASIS ODF SC Metadata||Sun Microsystems
|-
| [[User:Sts|Stella Schulze]]|| X || sts||||[http://ui.openoffice.org/nonav/VisualDesign/ Visual Design]||Sun Microsystems
|-
| Julian Seward || || sewardj || || valgrind ||
|-
| Darragh Sherwin|| || dsherwin||darragh||E-Legislation / E-GovSystems||Propylon
|-
| Wei Guo Shi || X || shiwg || || Accessibility and Smart Suite filter || IBM Corp.
|-
|[[User:Robertzhou | RobertZhou]]|| || robertzhou|| shizhoubo|| [[Framework]] || CS2C
|-
| Raul Siddhartha|| || rsiddhartha||raul||GTK File Selector||Novell, Inc.
|-
| Sarah Smith|| || ssmith||||||
|-
| [[User:mox|Mox Soini]] || X || mox || Moxed || Mac Porting ||
|-
| Rajesh Sola|| || rajeshsola||sola||misc.||NOSIP
|-
| Kai Sommerfeld|| X || kso||||manager & hacker||Sun Microsystems
|-
| Oliver Specht|| X || os||||PL UI||Sun Microsystems
|-
| Jörg Spindler|| || jspindler||||||
|-
| [[User:Rescue|Joey Stanford]] || || Rescue/k0fcc || Rinchen || CL [http://eo.openoffice.org/ Esperanto native-lang project] || [http://canonical.com Canonical]
|-
| Fridrich Štrba|| X || fridrich_strba||Fridrich||Word Perfect Hacker||Novell, Inc.
|-
| Keith Stribley|| X || kstribley||||Graphite fonts, Myanmar l10n||
|-
| [[User:Muthusuba|Muthu Subramanian]]|| X || muthusuba||muthusuba||misc.||
|-
| Louis Suárez-Potts|| || louis||louis||Community Manager||Collab.net
|-
|Quanfa Tang || || tqfa|| tangquanfa|| Calc || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| David Tardon || X || dtardon || dtardon || || [http://www.redhat.com Red Hat Inc.]
|-
| Stefan Taxhet|| X || st||stx12||CC, interpersonal problem fixer||Sun Microsystems
|-
| Armin Theissen|| || armin||||||
|-
| Caio Tiago Oliveira|| X || asrail||asrail||CL QA, release testing pt-BR builds||BrOffice.org
|-
| Jan Tietjens|| || tietjens||||||
|-
| Rüdiger Timm|| X || rt|| rtimm ||RE||Sun Microsystems
|-
| [[User:mt|Malte Timmermann]]|| X || mt|| Malte || Accessibility, Security, Performance||Sun Microsystems
|-
| Gerhard Tonn|| || tonn||||s390||
|-
| Willem van Dorp|| || willem.vandorp||||||
|-
| Tom Verbeek|| X || tv|||| ||
|-
| Sander Vesik|| || svesik||||||
|-
| Daniel Vogelheim|| X || dvo||||XML||
|-
| Mikhail Voitenko|| X || mav||mav||Framework||Sun Microsystems
|-
| Robert Vojta|| X || rvojta||rvojta||Mac OS X related issue||
|-
| Dirk Völzke|| X || dv||||Installation||Sun Microsystems
|-
|Xu Ming Wang || X || flyccloud or Wangxum || || Calc || IBM Corp.
|-
| [[User:Sparcmoz|Jim Watson]]|| X || sparcmoz|| sparcmoz||GNU Linux sparc porter||clug.org.au
|-
| [[User:Weiz |Zhao Wei ]] || || weiz || weiz || Chart2 || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| Armin Weiss|| X || aw||||||Sun Microsystems
|-
| Gerd Weiss|| X || gm||||RE||Sun Microsystems
|-
| Dan Williams|| X || fa||dcbw||Mac et. al. hacker|| [http://www.redhat.com Red Hat Inc.]
|-
| Oliver Wittmann|| X || od||Writer||||Sun Microsystems
|-
|[[User:wuy|Yan Wu]] || X || wuy || ||Framework ||CS2C
|-
| Stephan Wunderlich|| X || sw||||||
|-
| Antonio Xu|| X || antoxu || antoxu || Async dialogs, PRC improvements || Intel Corporation
|-
|Dehua Xu || || xudehua || xudh ||||
|-
| Steve Yin || X || steve_yin || steve_yin || Microsoft Office file format, PDF, Accessibility, ODF || IBM Corp.
|-
| Kohei Yoshida|| X || kohei||kohei_||[[Calc]] hacker, Calc optimization solver developer||Novell, Inc.
|-
| Guoqiang Yu|| X || yugq || yugq|| Performance || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| Xiaoyang Yu|| || || ||Disk block reordering||Intel Corporation
|-
| George Zahopoulos|| X || georgez||||||
|-
| Kurt Zenker|| X || kz||smoketester||RE||Sun Microsystems
|-
|[[User:Zhangxiaofei|Xiaofei Zhang]]|| || Zhangxiaofei || zhangxiaofei/FelixZ || [[Framework]] ||CS2C
|-
|Jianwei Zhao || || zhaojianwei || zhaojianwei || Swriter || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|-
| Jeremy Zheng|| X || zhiming || Jeremy || Async dialogs, PRC improvements || Intel Corporation
|-
| Zengliangjun || X || Zengliangjun || liangjun || [[Performance]] ||[[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000]]
|}

=== QA Engineers ===

{| border="2" cellpadding="4" cellspacing="0" style="margin: 1em 1em 1em 0; background: #f9f9f9; border: 1px #aaa solid; border-collapse: collapse;"
|-
! Name ||CVS||@openoffice.org || [[IRC Communication]] || Interested modules || Notes || Affiliation
|-
| Stefan Baltzer||||sba||||writer||||Sun Microsystems
|-
| Thorsten Bosbach||X||tbo||||framework, testautomation||framework test automation||Sun Microsystems
|-
| Oliver Craemer||X||oc||||[[Calc]], testautomation||calc test automation||Sun Microsystems
|-
| Helge Delfs||X||hde||||testautomation, writer||Test automation||Sun Microsystems
|-
| Fredrik Haegg||X||fha||||||||
|-
| Hasan Ilter||||hi||||writer, printing, pdf export||||Sun Microsystems
|-
| Michael Rüß||||mru||||writer, word im/export||||Sun Microsystems
|-
| Éric Savary||||es||||writer, accessibility||||Sun Microsystems
|-
| [[User:jsi|Joerg Sievers]]||X||jsi||jogi||porting||Mac- and Solaris SPARC port testing||
|-
| Joerg Skottke||X||jsk||skotti||framework, qa/qatesttool||Framework test automation||Sun Microsystems
|-
| Marc Neumann||X||msc||||database, testautomation||Database access test automation||Sun Microsystems
|-
| Chris Lukasiak||||clu||||database||||Sun Microsystems
|-
| Frank Stecher||||fst||||[[Calc]]||||Sun Microsystems
|-
| Jack Warchold|||| jw||||writer, import/export filters||||
|-
| Uwe Luebbers||||ul||||framework||||Sun Microsystems
|-
| Thorsten Martens||||tm||||framework||||Sun Microsystems
|-
| Olaf Felka|||| of||of_sun||framework, installation||||Sun Microsystems
|-
| Thomas Klarhoefer||||kla||||chart||||Sun Microsystems
|-
| Wolfram Garten||X|| wg||||draw, impress||draw, impress test automation||Sun Microsystems
|-
| Christian Guenther||||cgu||||draw, impress||||Sun Microsystems
|-
| Ulf Stroehler|||| us||||||||Sun Microsystems
|-
| [[User:Thorsten_Ziehm|Thorsten Ziehm]]||||| thorstenziehm||||||QA lead||Sun Microsystems
|}

We are tracking pending JCAs in the document [[Pending JCAs]].

== Related Pages ==
* [[Commit Rights]]
* [[Contributing Patches]]
* [[User_Experience/Community|User Experience Team]]
* A map of OOo developers around the world is available at http://www.frappr.com/ooodev, please add yourself to the map if you're involved in OOo development. It's just fun to see who's where :-)

[[Category:Development]]

OpenOffice.org Internship/ProjectProposals

2010-05-17T10:02:58Z

Nn: Calc proposals

start with some C&P from
http://wiki.services.openoffice.org/wiki/Community_Innovation_Program/proposals and
http://wiki.services.openoffice.org/wiki/Summer_of_Code_2008/proposals#Proposals

 '''This is a draft, and the proposed subjects below can be removed if not conform to the Internship needs

== Integration/porting ==

=== Maxima Integration ===

Integrate the Maxima symbolic computer algebra system into OOo, to solve calc problems in Writer.

The idea : create a Maxima session inside an OOo Writer document, in an embeded frame, or equivalent.

IMPORTANT :

* Weekly IRC meetings.
* Wiki use mandatory.
* Specifications and documentation MUST be written in parallel, in same time the code is written.
* Every diff of code will be documented on the wiki.
* the code must be written in C++ (prefered). A proof of concept using Python would be appreciated.
* Iterations

* Step 1
** Discover and learn UNO API
** be able to create a Writer document (and play with it)
** be able to launch an external application using UNO
** In parallel : learn how a Writer document is structured and how to use it programmaticaly (structure, foundations)

* Step 2
** Learn Maxima session requirements
** implement a way to launch a Maxima session from OOo
** implement a way to exchange datas with the open Maxima session
** propose a follow up for the devs who will continue the implementation

*Estimated Timeline
** 3 weeks of work = step 1
** 5 weeks of work = step 2

* Required skills/knowledge
** lisp (basics), c++, UNO API knowledge
** Difficulty: medium
** Contact
ericb at openoffice.org

=== Improve OOo usability on small-screen devices ===

With devices like netbooks, the OLPC or (gasp!) smartphones becoming powerful enough to run OOo (or the stripped-down OOo4Kids), it's becoming critically important to adapt the UI to smaller screen sizes and/or vastly different aspect ratios. This task is about improving OOo4Kids usability on the XO - from better Sugar integration to smaller UI footprint.

* Required skills/knowledge
** c++, Sugar/OLPC a bonus
** Difficulty
** medium
** Contact
*** ericb at openoffice dot org

=== Make OOo UI complexity configurable ===

The OOo4Kids project has pioneered a way of "dumbing down" the OOo UI, by selectively hiding functionality depending on user proficiency (controlled via three central user levels, beginner, intermediate & expert). This task is to expand on that, cover all five applications, and create a consistent, seamless level of complexity, adapted to the user skill level.

* Required skills/knowledge
** c++, UX design
** Difficulty
** medium
** Contact
*** ericb at openoffice dot org

===Improve (Python) scriptability ===

OOo has a language-agnostic bridge, that permits a host of programming languages (Java, Python, C#, JScript etc etc) to access certain parts of the OOo core. That's nice, but many of the more interesting intestines of the code are not, not easily, or not elegantly usable like that.

This project is about '''extend''' OOo with Python :

* providing a SWIG, or boost::python-based wrapper around un-UNOized OOo core classes.
* provide organized code samples, and clear examples

Required skills/knowledge
c++, python, boost/swig
Difficulty
medium
Contact
ericb at openoffice dot org

===Improve the Impress slideshow annotation mode ===

OOo has recently gotten a live annotation mode in the slideshow component, via a sequence of semester projects at Ecole Centrale Nantes. This project is far from done, has been worked on by students previously, and is highly useful in a classroom/education setting.

Tasks :

* improve the eraser mode
* fix various bugs around
* improve the annotation mode

Required skills/knowledge
c++
Difficulty
medium
Contact
ericb at openoffice dot org

=== Improve Scanner integration inside OOo ===

Scanner support inside OOo is existing, but neglected functionality. In our increasingly visual oriented world, getting that up to par (across all platforms - though especially lacking on Mac) would make you many friends.

* analyze the current situation
* improve (the view, the way the scanner is used .. and so on)
* propose a proof of concept on Mac OS X (Baseline : Tiger)

Required skills/knowledge
c++, Cocoa
Difficulty
hard
Contact
ericb at openoffice dot org

==Calc/Chart==

===Component to check spreadsheet documents for potential errors===

Write an extension that checks a spreadsheet document for potential errors in formulas, presents a list of the findings to the user, and allows to correct them.

Things to look for could include
* Cells that contain numbers stored as text and are used in formulas,
* Number cells that are not used in any formulas,
* Empty cells that are used in single-cell formula references.
The list is not meant to be exhaustive.

* Required skills/knowledge: Java or C++, spreadsheet usage

; Contact
: dev@sc.openoffice.org
: Niklas.Nebel at sun.com

===Statistical Data Analysis Tool===

Write an extension that allows statistical data analysis (like Anova, t-test, z-test, see [[Statistical Data Analysis Tool]]).

* Required skills/knowledge: Java or C++, statistics

; Contact
: dev@sc.openoffice.org
: Niklas.Nebel at sun.com

=== Improve numerical stability of spreadsheet functions ===

Some statistical and financial analysis spreadsheet functions need improvement in numerical stability, for example for very large and/or small values, see [http://qa.openoffice.org/issues/show_bug.cgi?id=18704 issue 18704] and dependencies.

* Required skills/knowledge: C++, knowledge of numerical analysis and algorithms, mathematical background

; Contact
: dev@sc.openoffice.org
: Eike.Rathke at sun dot com

=== Add new spreadsheet functions and parameters according to ODFF ===

The [http://www.oasis-open.org/committees/documents.php?wg_abbrev=office OpenDocument Format Formula specification] (ODFF aka OpenFormula) defines several new spreadsheet functions and new optional parameters to already existing functions that have to be implemented.

* Required skills/knowledge: C++; for some statistical functions knowledge of numerical algorithms and mathematical background

; Contact
: dev@sc.openoffice.org
: Eike.Rathke at sun dot com

[[Category:Marketing]][[Category:Development]][[Category:Education]]

Calc/Performance/Saving Sheets Separately

2009-09-29T14:33:54Z

Nn: mark as done

{{DISPLAYTITLE:Saving Sheets Separately}}
(Note: This is a technical description, not a specification. To a normal user, all of this is meant to be transparent. Except for the needed time, a user should not notice a difference between normal and partial saving.)

When an ODF spreadsheet is loaded and later saved ("save", "save as" or automatic saving for AutoRecovery), only the modified sheets are saved normally. For unmodified sheets, a part of the old XML stream is copied instead (see exceptions below). "Modified" means modified since loading, not the last saving.

This is similar to the experiment with [[Calc/Performance/Incremental Saving|Incremental Saving]], but based on sheets instead of cells.

If any sheets are copied this way, the names of automatic styles in these sheets have to be preserved, so they are not always named consecutively (ce1, ce2, ...) anymore. The formatted output for numbers that is written in <text:p> elements can depend on the system locale, so if the file was last saved with a different locale, the text for old and new sheets may be different.

If any of the following conditions is met, the whole file is saved normally:
* The file is loaded or saved with a different filter than "ODF Spreadsheet".
* The "content.xml" stream is not in UTF-8 encoding.
* The "content.xml" stream uses different namespace prefixes from those used by OOo.
* The loaded file is password protected.
* The file is in shared mode.
* The file is loaded from a remote URL (http, ftp, etc).

If any of the following conditions is met, the affected sheets are saved normally (as if they were modified):
* A sheet contains shapes other than cell notes. This includes charts (but the chart content is separate anyway).
* A sheet contains validity definitions.

After any of the following actions, all sheets are considered modified:
* "Recalculate Hard" (shift-ctrl-F9).
* If any shapes are manipulated in the document.
* If sheets are inserted or deleted.

Sheets with formula results that depend on changes are also considered modified.

Implementation is in {{CWS|calcsheetdata|DEV300}}, {{bug|102616}}, integrated for OOo 3.2 in DEV300m58.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:Done]]

Calc/Performance/Saving Sheets Separately

2009-08-13T13:05:33Z

Nn: text content for number cells

{{DISPLAYTITLE:Saving Sheets Separately}}
(Note: This is a technical description, not a specification. To a normal user, all of this is meant to be transparent. Except for the needed time, a user should not notice a difference between normal and partial saving.)

When an ODF spreadsheet is loaded and later saved ("save", "save as" or automatic saving for AutoRecovery), only the modified sheets are saved normally. For unmodified sheets, a part of the old XML stream is copied instead (see exceptions below). "Modified" means modified since loading, not the last saving.

This is similar to the experiment with [[Calc/Performance/Incremental Saving|Incremental Saving]], but based on sheets instead of cells.

If any sheets are copied this way, the names of automatic styles in these sheets have to be preserved, so they are not always named consecutively (ce1, ce2, ...) anymore. The formatted output for numbers that is written in <text:p> elements can depend on the system locale, so if the file was last saved with a different locale, the text for old and new sheets may be different.

If any of the following conditions is met, the whole file is saved normally:
* The file is loaded or saved with a different filter than "ODF Spreadsheet".
* The "content.xml" stream is not in UTF-8 encoding.
* The "content.xml" stream uses different namespace prefixes from those used by OOo.
* The loaded file is password protected.
* The file is in shared mode.
* The file is loaded from a remote URL (http, ftp, etc).

If any of the following conditions is met, the affected sheets are saved normally (as if they were modified):
* A sheet contains shapes other than cell notes. This includes charts (but the chart content is separate anyway).
* A sheet contains validity definitions.

After any of the following actions, all sheets are considered modified:
* "Recalculate Hard" (shift-ctrl-F9).
* If any shapes are manipulated in the document.
* If sheets are inserted or deleted.

Sheets with formula results that depend on changes are also considered modified.

Implementation is in {{CWS|calcsheetdata|DEV300}}, {{bug|102616}}.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:InProgress]]

Calc/Performance/Saving Sheets Separately

2009-08-12T16:18:13Z

Nn:

{{DISPLAYTITLE:Saving Sheets Separately}}
(Note: This is a technical description, not a specification. To a normal user, all of this is meant to be transparent. Except for the needed time, a user should not notice a difference between normal and partial saving.)

When an ODF spreadsheet is loaded and later saved ("save", "save as" or automatic saving for AutoRecovery), only the modified sheets are saved normally. For unmodified sheets, a part of the old XML stream is copied instead (see exceptions below). "Modified" means modified since loading, not the last saving.

This is similar to the experiment with [[Calc/Performance/Incremental Saving|Incremental Saving]], but based on sheets instead of cells.

If any sheets are copied this way, the names of automatic styles in these sheets have to be preserved, so they are not always named consecutively (ce1, ce2, ...) anymore.

If any of the following conditions is met, the whole file is saved normally:
* The file is loaded or saved with a different filter than "ODF Spreadsheet".
* The "content.xml" stream is not in UTF-8 encoding.
* The "content.xml" stream uses different namespace prefixes from those used by OOo.
* The loaded file is password protected.
* The file is in shared mode.
* The file is loaded from a remote URL (http, ftp, etc).

If any of the following conditions is met, the affected sheets are saved normally (as if they were modified):
* A sheet contains shapes other than cell notes. This includes charts (but the chart content is separate anyway).
* A sheet contains validity definitions.

After any of the following actions, all sheets are considered modified:
* "Recalculate Hard" (shift-ctrl-F9).
* If any shapes are manipulated in the document.
* If sheets are inserted or deleted.

Sheets with formula results that depend on changes are also considered modified.

Implementation is in {{CWS|calcsheetdata|DEV300}}, {{bug|102616}}.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:InProgress]]

Calc/Performance/Saving Sheets Separately

2009-08-12T09:27:23Z

Nn:

{{DISPLAYTITLE:Saving Sheets Separately}}
(Note: This is a technical description, not a specification. To a normal user, all of this is meant to be transparent. Except for the needed time, a user should not notice a difference between normal and partial saving.)

When an ODF spreadsheet is loaded and later saved ("save", "save as" or automatic saving for AutoRecovery), only the modified sheets are saved normally. For unmodified sheets, a part of the old XML stream is copied instead (see exceptions below). "Modified" means modified since loading, not the last saving.

This is similar to the experiment with [[Calc/Performance/Incremental Saving|Incremental Saving]], but based on sheets instead of cells.

If any sheets are copied this way, the names of automatic styles in these sheets have to be preserved, so they are not always named consecutively (ce1, ce2, ...) anymore.

If any of the following conditions is met, the whole file is saved normally:
* The file is loaded or saved with a different filter than "ODF Spreadsheet".
* The "content.xml" stream is not in UTF-8 encoding.
* The "content.xml" stream uses different namespace prefixes from those used by OOo.
* The loaded file is password protected.

If any of the following conditions is met, the affected sheets are saved normally (as if they were modified):
* A sheet contains shapes other than cell notes. This includes charts (but the chart content is separate anyway).
* A sheet contains validity definitions.

After any of the following actions, all sheets are considered modified:
* "Recalculate Hard" (shift-ctrl-F9).
* If any shapes are manipulated in the document.
* If sheets are inserted or deleted.

Sheets with formula results that depend on changes are also considered modified.

Implementation is in {{CWS|calcsheetdata|DEV300}}, {{bug|102616}}.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:InProgress]]

Calc/Performance/Saving Sheets Separately

2009-08-12T09:14:19Z

Nn: description

{{DISPLAYTITLE:Saving Sheets Separately}}

(Note: This is a technical description, not a specification. To a normal user, all of this is meant to be transparent. Except for the needed time, a user should not notice a difference between normal and partial saving.)

When an ODF spreadsheet is loaded and later saved ("save", "save as" or automatic saving for AutoRecovery), only the modified sheets are saved normally. For unmodified sheets, a part of the old XML stream is copied instead (see exceptions below). "Modified" means modified since loading, not the last saving.

This is similar to the experiment with [[Calc/Performance/Incremental Saving|Incremental Saving]], but based on sheets instead of cells.

If any sheets are copied this way, the names of automatic styles in these sheets have to be preserved, so they are not always named consecutively (ce1, ce2, ...) anymore.

If any of the following conditions is met, the whole file is saved normally:
* The file is loaded or saved with a different filter than "ODF Spreadsheet".
* The "content.xml" stream is not in UTF-8 encoding.
* The "content.xml" stream uses different namespace prefixes from those used by OOo.
* The loaded file is password protected.

If any of the following conditions is met, the affected sheets are saved normally (as if they were modified):
* A sheet contains shapes other than cell notes. This includes charts (but the chart content is separate anyway).
* A sheet contains validity definitions.

After any of the following actions, all sheets are considered modified:
* "Recalculate Hard" (shift-ctrl-F9).
* If any shapes are manipulated in the document.
* If sheets are inserted or deleted.

Sheets with formula results that depend on changes are also considered modified.

Implementation is in {{CWS|calcsheetdata|DEV300}}, {{bug|102616}}.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:InProgress]]

Calc/Performance/Saving Sheets Separately

2009-07-21T14:38:55Z

Nn: New page: {{DISPLAYTITLE:Saving Sheets Separately}} Similar to Incremental Saving, but based on sheets instead of cells. Implementation is in {{CWS|calcsheet...

{{DISPLAYTITLE:Saving Sheets Separately}}

Similar to [[Calc/Performance/Incremental Saving|Incremental Saving]], but based on sheets instead of cells. Implementation is in {{CWS|calcsheetdata|DEV300}}, {{bug|102616}}.

Still open:
* Handle all style families
* Detect shape modifications
* Verify valid namespaces, encoding, etc.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:InProgress]]

Calc/Features/Conditional Formatting

2009-04-29T16:54:06Z

Nn: implemented

= Improvements to conditional formatting =

== Buttons to create a new style ==

{{bug|27253}} suggests to add "New Style..." (or "New Cell Style...") buttons next to each cell style list box in the "Conditional Formatting" dialog. Pressing one of the buttons would open the "Cell Style" dialog for a new style, and if OK is pressed there, select the new style in the list box.

That way, if the user notices there is no suitable style yet, he wouldn't have to close the dialog, create a style, open the dialog again (and if he cancelled the dialog, make the settings again).

The modified dialog could look like this:

[[Image:Conditional Formatting New Style.png]]

This is implemented in {{CWS|calc49|DEV300}}.

[[Category:Calc|Features/{{SUBPAGENAME}}]]
[[Category:Feature|{{SUBPAGENAME}}]]

Calc/Performance/Updating Row Heights

2009-04-29T16:07:22Z

Nn: New page: {{Performance}} {{DISPLAYTITLE:Updating Row Heights}} After loading a spreadsheet file, automatic row heights are updated. This can take a significant part of the total loading time. To s...

{{Performance}}
{{DISPLAYTITLE:Updating Row Heights}}

After loading a spreadsheet file, automatic row heights are updated. This can take a significant part of the total loading time. To save some of this time, we want to update the heights only for those sheets for which the height information is needed. The implementation in {{CWS|dr70|DEV300}} currently does the following:

* The stored row heights from the file are loaded even if they are automatic. Previously they were ignored because they would be recalculated anyway. Loading them doesn't add significant overhead.

* If a sheet doesn't have any shapes or notes, and isn't the visible sheet as defined in the view settings, the row heights for that sheet aren't updated after loading. Instead the sheet gets a "pending" flag for later updating. The updates for the visible sheet and the sheets with shapes together use the existing "Adapt row height" progress bar.

* When switching to a different sheet that needs updating, the heights are updated with a progress bar, before switching, so there is some feedback why this takes longer. Similar for printing or page preview. The text for the progress bar is the same "Adapt row height" as after loading.

When shapes are involved, updating the row heights can take much longer, so there we keep the old sequence of updating row heights before positioning the shapes. To remove this limitation at a later time, we can either try to accelerate row height updates with shapes, or keep the shape positions from the file in memory (cell and relative position), and apply them only after updating the row heights.

Currently open: If simple notes can be loaded without using shapes, they will no longer require immediate row height updates.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:InProgress]]

Calc/Performance/Collect Formatted Cell Ranges Without ScRangeList::Join

2009-04-16T09:26:31Z

Nn: New page: {{DISPLAYTITLE:Collect Formatted Cell Ranges Without ScRangeList::Join}} The API method getUniqueCellFormatRanges is used to collect ranges with equal cell formats, in order to generate a...

{{DISPLAYTITLE:Collect Formatted Cell Ranges Without ScRangeList::Join}}

The API method getUniqueCellFormatRanges is used to collect ranges with equal cell formats, in order to generate automatic styles only once for each set of formats. The implementation uses ScAttrRectIterator to iterate over cell attributes, and ScRangeList::Join to update the list of ranges for each format. ScAttrRectIterator returns ranges column-wise. It that is taken into account, they can be joined more efficiently than with the general-case ScRangeList::Join method. In cases where a set of attributes is used in many non-adjacent cells or ranges, ScRangeList::Join can use a large part of the total saving time, so in these cases saving will be much faster.

This is {{bug|101126}}, fixed in {{CWS|calcperf04|DEV300}}.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:Done]]

Calc/Features/Conditional Formatting

2009-03-16T11:18:43Z

Nn: New page: = Improvements to conditional formatting = == Buttons to create a new style == {{bug|27253}} suggests to add "New Style..." (or "New Cell Style...") buttons next to each cell style list ...

= Improvements to conditional formatting =

== Buttons to create a new style ==

{{bug|27253}} suggests to add "New Style..." (or "New Cell Style...") buttons next to each cell style list box in the "Conditional Formatting" dialog. Pressing one of the buttons would open the "Cell Style" dialog for a new style, and if OK is pressed there, select the new style in the list box.

That way, if the user notices there is no suitable style yet, he wouldn't have to close the dialog, create a style, open the dialog again (and if he cancelled the dialog, make the settings again).

The modified dialog could look like this:

[[Image:Conditional Formatting New Style.png]]

[[Category:Calc|Features/{{SUBPAGENAME}}]]
[[Category:Feature|{{SUBPAGENAME}}]]

File:Conditional Formatting New Style.png

2009-03-16T11:17:48Z

Nn: Possible dialog modification

Possible dialog modification

Calc/Performance/Repeated Querying of the Document Null Date

2009-03-09T13:04:17Z

Nn: DISPLAYTITLE

{{DISPLAYTITLE:Repeated Querying of the Document Null Date}}

Date values are stored internally as the number of days since the null date. The null date can be configured per document. In the file format, date values are stored as XML Schema dates (basically ISO 8601). To convert between the two representations, the class SvXMLUnitConverter is used, and it needs the null date setting to do so. Currently the null date is queried from the document for each date value that is written, but because the setting applies to the whole document, it needs to be queried only once. This avoids a number of UNO calls when saving files with many date cells.

This is {{bug|99960}}, fixed in {{CWS|calcperf04|DEV300}}.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:Done]]

Calc/Performance/Use of GetInputString When Saving Text Cells

2009-03-09T13:03:49Z

Nn: DISPLAYTITLE

{{DISPLAYTITLE:Use of GetInputString When Saving Text Cells}}

To get the content of text cells for saving, the implementation of the UNO API getFormula method is re-used (ScCellObj::GetInputString_Impl). For the API, a single quote character is added if the string value can be parsed as a number (this is needed so a setFormula call with the result string will create a text cell again). For the file format, this quote character isn't needed and is removed. But determining whether to add the quote involves parsing the string, so leaving that step out will improve the performance of saving files with many text cells.

This is {{bug|99959}}, fixed in {{CWS|calcperf04|DEV300}}.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:Done]]

Calc/Performance/Repeated Querying of the Document Null Date

2009-03-09T13:01:24Z

Nn: New page: Date values are stored internally as the number of days since the null date. The null date can be configured per document. In the file format, date values are stored as XML Schema dates (b...

Date values are stored internally as the number of days since the null date. The null date can be configured per document. In the file format, date values are stored as XML Schema dates (basically ISO 8601). To convert between the two representations, the class SvXMLUnitConverter is used, and it needs the null date setting to do so. Currently the null date is queried from the document for each date value that is written, but because the setting applies to the whole document, it needs to be queried only once. This avoids a number of UNO calls when saving files with many date cells.

This is {{bug|99960}}, fixed in {{CWS|calcperf04|DEV300}}.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:Done]]

Calc/Performance/Use of GetInputString When Saving Text Cells

2009-03-09T13:01:20Z

Nn: New page: To get the content of text cells for saving, the implementation of the UNO API getFormula method is re-used (ScCellObj::GetInputString_Impl). For the API, a single quote character is added...

To get the content of text cells for saving, the implementation of the UNO API getFormula method is re-used (ScCellObj::GetInputString_Impl). For the API, a single quote character is added if the string value can be parsed as a number (this is needed so a setFormula call with the result string will create a text cell again). For the file format, this quote character isn't needed and is removed. But determining whether to add the quote involves parsing the string, so leaving that step out will improve the performance of saving files with many text cells.

This is {{bug|99959}}, fixed in {{CWS|calcperf04|DEV300}}.

[[Category:Calc|Performance/{{SUBPAGENAME}}]]
[[Category:Performance]]
[[Category:Done]]

Calc/Performance/Incremental Saving

2009-02-27T10:45:42Z

Nn: New page: == An experiment with incremental saving in Calc == For a while, there has been the idea to speed up the saving of small changes to large spreadsheet documents by generating only the XML ...

== An experiment with incremental saving in Calc ==

For a while, there has been the idea to speed up the saving of small changes to large spreadsheet documents by generating only the XML elements for the changed cells.

I did a little experiment to find out how much time this can really save. It's not a complete implementation, just a test to see what's possible. This is what I changed:
* Loading of the file is unchanged. No additional information is kept in memory after the file is loaded.
* What I keep in memory is the list of changes, as long as only supported changes were made. For this test, only input of numbers into cells that weren't empty before is supported. If any other changes are made, the list is discarded and the normal save code is used. For simplicity, it is assumed that the input doesn't change the cell's format. Changed formula results are ignored (in a real implementation, they have to be tracked, too).
* When the file is saved, and the content.xml stream is generated, first the old content.xml is opened and parsed for the positions of the affected cell elements (see below for details). Then, the output is generated by copying the non-affected parts and inserting a new simple cell element instead of each affected cell.
* The styles.xml stream is copied in unchanged form.

To find the affected cell elements in the XML stream quickly, expat's C interface is used, searching for qualified element names table:table, table:table-row, table:table-cell and table:covered-table-cell. Because this is just an optimization, I can assume that our own namespace prefixes are used. Parsing is stopped when the last affected cell was found.

For testing, I used a large, simple file with 500000 cells, only text and numbers.

In CPU time (measured with callgrind), normal saving takes 20.1 billion cycles. Incremental saving with three values changed at the top of the file takes 6.3 billion, and with three values changed at the bottom it takes 11.4 billion cycles. Note that a real implementation would probably need some additional checks that might increase the time again.

In exchange for these saved CPU cycles, there is a bit of additional file access to read the old streams again. This isn't much, because they can be read from the compressed file. Reliably measuring the total time isn't easy, but quick tests with a larger file show the time for incremental saving to be around 50% of normal for changes at the top, and 70% for changes at the bottom. On other machines, this might be totally different.

== What next? ==

As mentioned above, the immediate goal of this was only to get the numbers of what is possible. Before making a real implementation of this, we should see where we can get by improving the normal saving, because that would benefit all usages, not only specific, limited modifications.

For reference, the code of this experiment is in the CWS "calcincsave".

[[Category:Calc]]
[[Category:Performance]]
[[Category:InProgress]]

2008 Q2 Review of Spreadsheet Project

2008-05-14T16:16:04Z

Nn: /* which defect needs to go into the next release */ flexible for any incoming new issues

= Review of the OpenOffice.org Spreadsheet project (April/May 2008) =

== Review schedule ==

* start of review: April 28th
* review of collected issues: May 5th, 3pm UTC, #ooocalc on freenode
* start of sorting priorities and assignments May 5th
* review of final list: May 13th, 3pm UTC, #ooocalc on freenode

== Status of the project ==

=== what are the most severe issues in the current release ===
High voted issues April 2008 (all types - defects, features, enhancements):
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8302 8302]: (111 Votes) Want to be able to insert into the middle of merged cells
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5560 5560]: (75) Spreadsheet Sheet Labels (change Color and Font)
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5930 5930]: (71) Engineering Notation
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=12666 12666]: (61) Autofilter works just on one sheet (only one auto-range per
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=30215 30215]: (57) Further thoughts on row limits
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=20857 20857]: (55) R1C1 notation for the spreadsheet
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=21280 21280]: (50) Automatic Insert (shift down or shift right) of cells, colum
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=2131 2131]: (47) Ability to merge cells already merged
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=15773 15773]: (45) Currency symbol left justified, while amount right justified
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=59745 59745]: (44) Cell notes do not move when cells are sorted in Calc
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=35579 35579]: (42) Standard filter requires more options..
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=6087 6087]: (40) ODF: Allow all characters in sheet names
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=25855 25855]: (38) Copy multiple seperated rows
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=22762 22762]: (33) Page preview for Selection
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=33723 33723]: (31) Ability to turn off Number Recognition in Calc
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5658 5658]: (24) Spreadsheet thinks a number is a string (text)
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=87970 87970]: (22) Hebrew Characters in Spreadsheet Names Became Misdisplayed
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=38494 38494]: (21) Copy/Paste numbers from Writer to Calc: decimal separator in
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5759 5759]: (19) DataPilot: allow more than 8 data fields
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=3687 3687]: (18) Make CSV import/export filter settings persistent (e.g. the

=== which are the most requested (or needed) features (in the press, user forums, issues, other feedback) ===

The following ux-ctest issues have been recorded during usability sessions.
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60408 60408]: Sum Icon in Calc not Found: [http://specs.openoffice.org/calc/ease-of-use/sum_button_enhancements.odt Specification]
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60403 60403]: Edit menu: Expected menu command to duplicate sheets
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60402 60402]: German terminology in context menu for sheet controls could be misunderstood
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60401 60401]: Calc does not support all users' strategies regarding sorting data
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60400 60400]: Spreadsheet handling wording table vs. spreadsheet
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60399 60399]: Delete Columns/Rows in the context menu is missing if the cursor is not positioned on Column/Row Header

The following issues have been recorded during expert talks with customers.
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=969 969]: Auto-Correct on leaving cells does not work
# Issue no.: ??????: Add Color Picker and Link to Color Dialog to Color Float
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=66484 66484]: Missing Range Chooser Issue
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5432 5432]: F4 should repeat last command
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=10864 10864]: Color chooser do not show latest color
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=88521 88521]: [http://specs.openoffice.org/calc/features/Print_Output_Scaling_Factor.odt]: Print Output Scaling Factor

Usability problems
# {{Bug|87999}}: (11 votes) In "standard" data type csv import should never convert items with one dot to dates
::User struggle very often about this problem. I've collect some issues from the issue tracker:{{ Bug|6315}} {{ Bug|7606}} {{ Bug|13156}} {{ Bug|18458}} {{ Bug|20804}} {{ Bug|23024}} {{ Bug|25201}} {{ Bug|31326}} {{ Bug|59339}} {{ Bug|65142}} {{ Bug|67813}} {{ Bug|69097}} {{ Bug|72449}} {{ Bug|82196}} {{ Bug|88243}}. They are all closed as worksforme or invalid or duplicate, but they show, that the import of csv files needs an improvement here. The issue is related to no 33723 but not the same.

== short term planning ==
=== which defect needs to go into the next release ===

None at the moment, but we agreed to be flexible for any incoming new issues if any, especially those with patches.

=== which features will be worked on for the half year ===
# ODFF formula changes
# Excel 2007 import
# Calc collaboration (extend change tracking for formatting and attributes)
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=14893 14893]: (3) Excel displays Grid lines on a per sheet basis, Calc on a per document basis
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=85305 85305]: (1) Dynamically grow a filtered range for autofilter, standard filter, and advanced filter
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=86856 86856]:Show Formula Syntax in tip help.
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=88521 88521]:Adding scaling factor on page preview in calc.

=== which issues needs an assignment ===

== mid/long term planning ==
=== which features/bugfixes needs to be addressed in the next two/three years ===
=== unassigned feature/bugfixes ===

=== long-term suggestions ===
#; separate functional units:
#* split Calc into 2 functional units / separate applications
#* one broad '''table/canvas''' application for general users, similar to [http://www.apple.com/iwork/numbers/ Apple's Numbers]
#* one application focused on '''professional spreadsheet''' users
#*;
# '''general use:'''
#* modalities for easier and more productive table input: a lot of brainstorming needed
#*; professional users would benefit as well
#** create input templates, e.g. see [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_usingcheckboxesandsliders_20070807_640x360.mov Apple's iWork tutorial] and any decent statistical application (e.g. [http://www.cdc.gov/epiinfo/ Epi Info])
#** data validation
#* ease table formatting:
#** [http://www.openoffice.org/issues/show_bug.cgi?id=78181 issue 78181] and Apple's iWorks Tutorial [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_customizingtables_20070807_640x360.mov movie 1] and [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_usingtablesheadersfooters_20070807_640x360.mov movie 2]: table styles, striped tables, highlight current row, headers and footer rows (results row)
#** advanced canvas formatting:
#*** add various elements/objects to spreadsheets, see [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_addingtextandshapes_20070807_640x360.mov iWorks tutorial] and [http://www.openoffice.org/issues/show_bug.cgi?id=83767 issue 83767: Company Logos]
#*** merge Draw-features into the spreadsheet application (see previous iWorks tutorial)
#* ease and implement automatic analysis features (very basic ones - like correct descriptive statistics)
#** '''SUMMARY()''' function: compute automatically all needed results for descriptive statistics purposes and export results adapted as for publication needs (for academia)
#*;
# '''professional use:'''
#* catch numerous errors by implementing strong typing: see [http://www.openoffice.org/issues/show_bug.cgi?id=79924 issue 79924]
#* prepare for multidimensional spreadsheets / OLAP functionality:
#** split table into functional layers
#** separate data layer from formula layer (see next section: multidimensional spreadsheets)
#** separate general definitions of constants, variables, and names into a separate spreadsheet header: see [http://www.openoffice.org/issues/show_bug.cgi?id=67499 issue 67499] and [http://www.openoffice.org/issues/show_bug.cgi?id=66886 issue 66886]
#** separate spreadsheet and table headings from data layer: see [http://www.openoffice.org/issues/show_bug.cgi?id=83767 Company Logo] and [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_addingtextandshapes_20070807_640x360.mov Apple's iWorks tutorial] on adding various elements to the canvas
#** separate results from Data Layer: issue not yet filed
#* implement multidimensional spreadsheets: see [http://www.openoffice.org/issues/show_bug.cgi?id=85825 issue 85825]

[[Category:Calc]]
[[Category:To-Do]]

2008 Q2 Review of Spreadsheet Project

2008-05-05T16:42:02Z

Nn: clean up, preliminary "half year" list

= Review of the OpenOffice.org Spreadsheet project (April/May 2008) =

== Review schedule ==

* start of review: April 28th
* review of collected issues: May 5th, 3pm UTC, #ooocalc on freenode
* start of sorting priorities and assignments May 5th
* review of final list: May 13th, 3pm UTC, #ooocalc on freenode

== Status of the project ==

=== what are the most severe issues in the current release ===
High voted issues April 2008 (all types - defects, features, enhancements):
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8302 8302]: (111 Votes) Want to be able to insert into the middle of merged cells
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5560 5560]: (75) Spreadsheet Sheet Labels (change Color and Font)
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5930 5930]: (71) Engineering Notation
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=12666 12666]: (61) Autofilter works just on one sheet (only one auto-range per
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=30215 30215]: (57) Further thoughts on row limits
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=20857 20857]: (55) R1C1 notation for the spreadsheet
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=21280 21280]: (50) Automatic Insert (shift down or shift right) of cells, colum
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=2131 2131]: (47) Ability to merge cells already merged
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=15773 15773]: (45) Currency symbol left justified, while amount right justified
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=59745 59745]: (44) Cell notes do not move when cells are sorted in Calc
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=35579 35579]: (42) Standard filter requires more options..
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=6087 6087]: (40) ODF: Allow all characters in sheet names
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=25855 25855]: (38) Copy multiple seperated rows
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=22762 22762]: (33) Page preview for Selection
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=33723 33723]: (31) Ability to turn off Number Recognition in Calc
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5658 5658]: (24) Spreadsheet thinks a number is a string (text)
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=87970 87970]: (22) Hebrew Characters in Spreadsheet Names Became Misdisplayed
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=38494 38494]: (21) Copy/Paste numbers from Writer to Calc: decimal separator in
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5759 5759]: (19) DataPilot: allow more than 8 data fields
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=3687 3687]: (18) Make CSV import/export filter settings persistent (e.g. the

=== which are the most requested (or needed) features (in the press, user forums, issues, other feedback) ===

The following ux-ctest issues have been recorded during usability sessions.
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60408 60408]: Sum Icon in Calc not Found: [http://specs.openoffice.org/calc/ease-of-use/sum_button_enhancements.odt Specification]
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60403 60403]: Edit menu: Expected menu command to duplicate sheets
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60402 60402]: German terminology in context menu for sheet controls could be misunderstood
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60401 60401]: Calc does not support all users' strategies regarding sorting data
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60400 60400]: Spreadsheet handling wording table vs. spreadsheet
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60399 60399]: Delete Columns/Rows in the context menu is missing if the cursor is not positioned on Column/Row Header

The following issues have been recorded during expert talks with customers.
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=969 969]: Auto-Correct on leaving cells does not work
# Issue no.: ??????: Add Color Picker and Link to Color Dialog to Color Float
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=66484 66484]: Missing Range Chooser Issue
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5432 5432]: F4 should repeat last command
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=10864 10864]: Color chooser do not show latest color
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=88521 88521]: [http://specs.openoffice.org/calc/features/Print_Output_Scaling_Factor.odt]: Print Output Scaling Factor

Usability problems
# {{Bug|87999}}: (11 votes) In "standard" data type csv import should never convert items with one dot to dates
::User struggle very often about this problem. I've collect some issues from the issue tracker:{{ Bug|6315}} {{ Bug|7606}} {{ Bug|13156}} {{ Bug|18458}} {{ Bug|20804}} {{ Bug|23024}} {{ Bug|25201}} {{ Bug|31326}} {{ Bug|59339}} {{ Bug|65142}} {{ Bug|67813}} {{ Bug|69097}} {{ Bug|72449}} {{ Bug|82196}} {{ Bug|88243}}. They are all closed as worksforme or invalid or duplicate, but they show, that the import of csv files needs an improvement here. The issue is related to no 33723 but not the same.

== short term planning ==
=== which defect needs to go into the next release ===
=== which features will be worked on for the half year ===
# ODFF formula changes
# Excel 2007 import
# Calc collaboration (extend change tracking for formatting and attributes)
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=14893 14893]: (3) Excel displays Grid lines on a per sheet basis, Calc on a per document basis
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=85305 85305]: (1) Dynamically grow a filtered range for autofilter, standard filter, and advanced filter
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=86856 86856]:Show Formula Syntax in tip help.
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=88521 88521]:Adding scaling factor on page preview in calc.

=== which issues needs an assignment ===

== mid/long term planning ==
=== which features/bugfixes needs to be addressed in the next two/three years ===
=== unassigned feature/bugfixes ===

=== long-term suggestions ===
#; separate functional units:
#* split Calc into 2 functional units / separate applications
#* one broad '''table/canvas''' application for general users, similar to [http://www.apple.com/iwork/numbers/ Apple's Numbers]
#* one application focused on '''professional spreadsheet''' users
#*;
# '''general use:'''
#* modalities for easier and more productive table input: a lot of brainstorming needed
#*; professional users would benefit as well
#** create input templates, e.g. see [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_usingcheckboxesandsliders_20070807_640x360.mov Apple's iWork tutorial] and any decent statistical application (e.g. [http://www.cdc.gov/epiinfo/ Epi Info])
#** data validation
#* ease table formatting:
#** [http://www.openoffice.org/issues/show_bug.cgi?id=78181 issue 78181] and Apple's iWorks Tutorial [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_customizingtables_20070807_640x360.mov movie 1] and [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_usingtablesheadersfooters_20070807_640x360.mov movie 2]: table styles, striped tables, highlight current row, headers and footer rows (results row)
#** advanced canvas formatting:
#*** add various elements/objects to spreadsheets, see [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_addingtextandshapes_20070807_640x360.mov iWorks tutorial] and [http://www.openoffice.org/issues/show_bug.cgi?id=83767 issue 83767: Company Logos]
#*** merge Draw-features into the spreadsheet application (see previous iWorks tutorial)
#* ease and implement automatic analysis features (very basic ones - like correct descriptive statistics)
#** '''SUMMARY()''' function: compute automatically all needed results for descriptive statistics purposes and export results adapted as for publication needs (for academia)
#*;
# '''professional use:'''
#* catch numerous errors by implementing strong typing: see [http://www.openoffice.org/issues/show_bug.cgi?id=79924 issue 79924]
#* prepare for multidimensional spreadsheets / OLAP functionality:
#** split table into functional layers
#** separate data layer from formula layer (see next section: multidimensional spreadsheets)
#** separate general definitions of constants, variables, and names into a separate spreadsheet header: see [http://www.openoffice.org/issues/show_bug.cgi?id=67499 issue 67499] and [http://www.openoffice.org/issues/show_bug.cgi?id=66886 issue 66886]
#** separate spreadsheet and table headings from data layer: see [http://www.openoffice.org/issues/show_bug.cgi?id=83767 Company Logo] and [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_addingtextandshapes_20070807_640x360.mov Apple's iWorks tutorial] on adding various elements to the canvas
#** separate results from Data Layer: issue not yet filed
#* implement multidimensional spreadsheets: see [http://www.openoffice.org/issues/show_bug.cgi?id=85825 issue 85825]

2008 Q2 Review of Spreadsheet Project

2008-04-29T12:25:14Z

Nn: /* Review schedule */ May 12 -> May 13

Community Innovation Program/proposals

2008-04-24T16:20:13Z

Nn: /* Calc/Chart */

=Proposals=
==Writer==
==Calc/Chart==

===Component to check spreadsheet documents for potential errors===

Write an extension that checks a spreadsheet document for potential errors in formulas, presents a list of the findings to the user, and allows to correct them.

Things to look for could include
* Cells that contain numbers stored as text and are used in formulas,
* Number cells that are not used in any formulas,
* Empty cells that are used in single-cell formula references.
The list is not meant to be exhaustive.

* Required skills/knowledge: Java or C++, spreadsheet usage

; Contact
: dev@sc.openoffice.org
: Niklas.Nebel at sun.com

===Watch Window===

A Watch Window is a separate, small window that remains "on top" and enables users to monitor a selected set of cells, see [http://www.openoffice.org/issues/show_bug.cgi?id=28386 issue 28386].

This could be implemented as an add-on component with a modeless dialog containing the list of watched cells as well as the UI to add or remove cells.

* Required skills/knowledge: Java or C++

; Contact
: dev@sc.openoffice.org
: Niklas.Nebel at sun.com

==Impress/Draw==
==Base==
=New Tasks=

If you have a task that is challenging enough, and there is an OpenOffice.org Project Member willing to mentor the task, feel free to coordinate with the appropriate project lead. If the appropriate project has been found and it supports the task, add it below and make sure the mentor applies with the web app.

Each entry should contain the task description, required skills, project mailing list for discussion and personal contact. Links to the [[To-Dos]] are appreciated provided that the task is well described there ;-)

===Example entry===

This is just an example - the real entry must not start with a space at the beginning
of the line.
A full description of the task should be here; one that will help to see that this task
is important, and interesting to hack on. Alternatively it could be an exact link to
the description that is already in [[To-Dos]].

* Required skills/knowledge: Language, technology1, technology2, ...

; Contact
: dev@project.openoffice.org
: The.Mentor at organization com

2008 Q2 Review of Spreadsheet Project

2008-04-24T16:00:41Z

Nn: New page: = Review of the OpenOffice.org Spreadsheet project (April/May 2008) = == Review schedule == * start of review: April 28th * review of collected issues: May 5th, 3pm UTC, #ooocalc on free...

Summer of Code 2008/proposals

2008-03-10T12:52:42Z

Nn: /* Calc/Chart */ potential errors, watch window

=Proposals=

== Writer ==

=== Improve Equation Editor Math ===

'''DRAFT'''

==== Intro ====

Concerns: OpenOffice.org 3.x all versions

Objective: currently, the equations editor has some issues (including very old one) and they need to be fixed, because all those issues are a '''strong brake''' for OpenOffice.org acceptance in Education.

Main issues are:

- misalignment

- missing symbols ( |-> , <-| , angle A^B .. etc)

- other issues to be fixed in starmath

FIXME : add the list of concerned issues

==== Skills====

Skills with languages C/C++ (tokenization, debugging ) maths symbols and good math knowledge (for equations writing ) is a plus.

Good communication skills are expected too (because several modules are concerned )

====Tasks ====

Familiarize with the starmath editor code

Familiarize with links in writer (writer is concerned in some issues)

Expected:

For issue 972 ( see links [[Education_Project/Effort#Implement_Math_Baseline_Alignement_.28click_me.29| Education Project effort for starmath]] and [[Education_Project/Effort/Math_baseline_alignment| Math_baseline_alignment]] )

- code to Implement a new parameter for baseline computation without edit equations

- write specs for add a the info in the .odt format

- design a proof of concept

- implement it

Complete : other little math issues ( e.g. missing |-> and <-| symbols .. etc )

; Contact
: dev@education.openoffice.org
: ericb at openoffice dot org

;Proposed by: Eric Bachard, Thomas Lange (to be confirmed)

;Mentor: Eric Bachard (to be confirmed)

===Page preview for Writer===

Similar to OOo Impress' slide sorter pane, provide similar
functionality for Writer. Initially, it should be possible to see page
thumbnails there, and navigate the document with it.

* Reguired skills/knowledge: C++, familiarity with Writer and UNO a big plus

; Contact
: dev@sw.openoffice.org
: freuter at novell dot com, fstrba at novell dot com

===Style optimizer for Writer===

Often, people format their text document in weird ways, using
whitespace for formatting, putting in section numbers literally
instead of using the numbering feature etc.
This proposal is about detecting such suboptimal content and
converting it into a properly formatted document (using styles
wherever possible).

* Reguired skills/knowledge: fluent in one of the languages OOo has an UNO bridge for, familiarity with Writer and Writer API a big plus

; Contact
: dev@sw.openoffice.org
: kendy at novell dot com, fstrba at novell dot com

===Word macro compatibility===

Recently Sun and Novell announced to pool resources to provide VBA
macro compatability see
[http://blogs.sun.com/GullFOSS/entry/sun_and_novell_work_together
here].

Currently work in the project is concentrated on providing Excel support by
* providing the framework for the compatibiltiy api via a plugable component
* modifying the basic engine to support more compatibility features
* porting the [[Helperapi]] code (for excel) to c++ (see. [[VBA]] & [[Porting_notes]])

Tasks

* extend the base framework by developing helper objects and implementations to be used by both the excel and writer compatibility object implementations
* port the existing (word) helper api objects from Java to C++

Required skills/knowledge: C++, Java. Knowledge of UNO, OOo's writer
API and some experience with VBA macros and Word VBA api a big plus

; Contact
: dev@sw.openoffice.org
: noel.power at novell dot com

===RTF Tokenizer===

The new OOXML import filter for Word documents (.dotx) will soon have a better import quality than the existing RTF import filter. The concept of this new filter allows to plug in doc and rtf tokenizers so that these formats can be handled by the same filter. A doc tokenizer is already in the works, an RTF tokenizer would be a very welcomed addition.

Tasks

* understand how the tokenizer is embedded into the filter
* tokenize RTF

Required skills/knowledge: C++. Knowledge about Word's document model and/or the RTF format would be advantageous.

; Contact
: dev@sw.openoffice.org
: Henning.Brinkmann at sun dot com

===Enhanced usability of working with page attributes and properties===

Currently changing page attributes or adding page properties like headers and footers is hard to understand. Users that don't know about hard page breaks, page styles and follow styles will have a hard time to format pages to their likings. A nice UI that hides the technical details and uses terms of the user space would help a lot.

Tasks
* learn about Writer's page styles and their (UNO) API
* design and code the new user interface based on this API

Required skills/knowledge: C++; UI design
; Contact
: dev@sw.openoffice.org
: Oliver.Specht at sun dot com

===HTML export: export formulas as MathML===

Exporting to HTML should turn Formulae into MathML (not GIFs). See [http://qa.openoffice.org/issues/show_bug.cgi?id=24256|Issue 24256]

Math already supports MathML export. The HTML export filter needs to be extended to use it instead of treating Math as an OLE object that is exported as a pixel graphic.

Required skills/knowledge: C++. Knowledge about MathML and HTML.

; Contact
: dev@sw.openoffice.org
: Mathias.Bauer at sun dot com

===Enhance Word Count===

The Word Count feature of Writer does not match the requirements of professional writers. Some enhancements and bug fixes are still needed.

Tasks:

* get familiar with the Break Iterator implementation
* compile a list of necessary enhancements
* implement and test with documents provided by the community

Required skills/knowledge: C++.

; Contact
: dev@sw.openoffice.org
: Frank.Meies at sun dot com

==Calc/Chart==

===Templates for Charts===

Into OpenOffice.org integrate the possibility to create and use templates for charts, see [http://www.openoffice.org/issues/show_bug.cgi?id=33793 issue 33793].
It will help users to speed up their workflow and ease the creation of stylish charts.
There should be an easy way to create a template from an existing chart. When creating a chart the user should be able to choose between different templates.
Some useful default templates should be offered, for example line charts with different dashes or bar charts with different hatchings.

* Required skills/knowledge: C++, ability to understand and manipulate complex systems, general knowledge about charts
* Useful skills: ability to build and debug OpenOffice.org, basic UNO API knowledge, ODF or general XML knowledge, knowledge about OpenOffice.org modules chart2 and xmloff

; Contact
: dev@graphics.openoffice.org
: Ingrid.Halama at sun.com

===Stacked label support for bar charts===

With OOo's new chart implementation, adding new features is
relatively easy. This proposal is about adding support for stacked
labels to chart2.

* Reguired skills/knowledge: C++, familiarity with UNO a big plus

; Contact
: dev@sc.openoffice.org
: kyoshida at novell dot com

===Boxplot and histogram chart support===

With OOo's new chart implementation, adding new chart types is a
breeze. This proposal is about adding support for boxplot and
histogram charts to OOo, which Excel does not have, but Gnumeric
has. Both of them are essential for presenting statistical data.

* Reguired skills/knowledge: C++, familiarity with UNO a big plus

; Contact
: dev@sc.openoffice.org
: kyoshida at novell dot com

===Improve Calc autofilter===

In comparison to Calc, Excel 2007 has a much improved cell autofilter
implementation. This proposal is about improving the existing filter
inside Calc, according to this
[http://kohei.us/2007/06/13/making-autofilter-more-user-friendly/ blog].

* Reguired skills/knowledge: C++, some familiarity with Calc a big plus

; Contact
: dev@sc.openoffice.org
: kyoshida at novell dot com

=== Improve numerical stability of spreadsheet functions ===

Some statistical and financial analysis spreadsheet functions need improvement in numerical stability, for example for very large and/or small values, see [http://qa.openoffice.org/issues/show_bug.cgi?id=18704 issue 18704] and dependencies.

* Reguired skills/knowledge: C++, knowledge of numerical analysis and algorithms, mathematical background

; Contact
: dev@sc.openoffice.org
: erack at sun dot com

=== Add new spreadsheet functions and parameters according to ODFF ===

The [http://www.oasis-open.org/committees/documents.php?wg_abbrev=office OpenDocument Format Formula specification] (ODFF aka OpenFormula) defines several new spreadsheet functions and new optional parameters to already existing functions that have to be implemented.

* Reguired skills/knowledge: C++; for some statistical functions knowledge of numerical algorithms and mathematical background

; Contact
: dev@sc.openoffice.org
: erack at sun dot com

===Component to check spreadsheet documents for potential errors===

Write an extension that checks a spreadsheet document for potential errors in formulas, presents a list of the findings to the user, and allows to correct them.

Things to look for could include
* Cells that contain numbers stored as text and are used in formulas,
* Number cells that are not used in any formulas,
* Empty cells that are used in single-cell formula references.
The list is not meant to be exhaustive.

* Required skills/knowledge: Java or C++, spreadsheet usage

; Contact
: dev@sc.openoffice.org
: Niklas.Nebel at sun.com

===Watch Window===

A Watch Window is a separate, small window that remains "on top" and enables users to monitor a selected set of cells, see [http://www.openoffice.org/issues/show_bug.cgi?id=28386 issue 28386].

This could be implemented as an add-on component with a modeless dialog containing the list of watched cells as well as the UI to add or remove cells.

* Required skills/knowledge: Java or C++

; Contact
: dev@sc.openoffice.org
: Niklas.Nebel at sun.com

== Impress/Draw ==

===Implement additional 3D slideshow transitions===

Building on top of a successful
[http://wiki.services.openoffice.org/wiki/Summer_of_Code_2007/proposals#Impress:_OpenGL_rendered_transitions] from last year, the goal is to add more 3D transitions
to the Impress application. A transition is an animation where one page
is visible in the beginning and another in the end. It is used during
presentation slideshow to switch pages.

The already existing OpenGL transition engine gets the previous and
next page as a prerendered image, and then gets the stage (i.e. the
screen) exclusively, for the duration of the transition.

* Reguired skills/knowledge: C++, OpenGL. familiarity with UNO is welcomed

; Contact
: dev@graphics.openoffice.org
: rodo at novell dot com, tbehrens at novell dot com

===Port Impress 3D slideshow transition framework to Windows===

Building on top of a successful
[http://wiki.services.openoffice.org/wiki/Summer_of_Code_2007/proposals#Impress:_OpenGL_rendered_transitions] from last year, the goal is to port the underlying
OpenGL framework to Windows.

The already existing OpenGL transition engine gets the previous and
next page as a prerendered image, and then gets the stage (i.e. the
screen) exclusively, for the duration of the transition.

* Reguired skills/knowledge: C++, OpenGL, WGL. familiarity with UNO is welcomed

; Contact
: dev@graphics.openoffice.org
: rodo at novell dot com, tbehrens at novell dot com

===Standalone presentation viewer===

In comparison to PowerPoint, OOo Impress does not have a standalone
presentation viewer, although this greatly simplifies handling for
inexperienced users. Furthermore, it offers a chance to pursue
different routes in terms of UI and functionality, that might not
(easily) fit in the main Impress application.

* Reguired skills/knowledge: some familiarity with UNO a big plus, preferred implementation language is C#

; Contact
: dev@graphics.openoffice.org
: rodo at novell dot com

===OpenGL canvas backend===

With a DirectX-based [[Canvas]]
implementation already available for Windows, a natural move
is to provide an OpenGL-based on for the unixoid platforms OOo runs
on. This proposal is about providing an initial XCanvas-implementation
that solely uses OpenGL for rendering.

* Reguired skills/knowledge: C++, OpenGL, some familiarity with UNO a big plus

; Contact
: dev@gsl.openoffice.org
: rodo at novell dot com

===Create a native CoreGraphics canvas for Mac OSX===

The current Aqua port for OOo uses vcl as the
[[Canvas]] rendering
backend. This proposal is about writing a native Core Graphics
implementation, bringing anti-aliasing and lightning-fast alpha
blending to the components that already use the canvas. Although a
100% feature-complete implementation seems to be unrealistic given the
short timeframe, simple Impress documents should already render
correctly.

* Reguired skills/knowledge: C++, familiarity with OSX, and optimally Core Graphics, some UNO know-how a plus.

; Contact
: mac@porting.openoffice.org, dev@gsl.openoffice.org
: ericb at openoffice dot org, tbehrens at novell dot com

===Use PDF import's layout recognition for other vector formats===

OOo's newly implemented PDF import employs some sophisticated layout
recognition techniques, to generate a layout-compatible
document. Leveraging this framework for other vector formats will
make OOo an editor not only for PDF, but also for PostScript, EMF, XPS
- whatever the successful applicant for this task chooses to import.

* Reguired skills/knowledge: C++, some knowledge about the vector format to be imported. familiarity with UNO is welcomed

; Contact
: dev@graphics.openoffice.org
: tbehrens at novell dot com

===Implement an AutoCAD vector import for OOo===

To complete OOo's already impressive list of import filters, this
proposal is about adding an AutoCAD import for Draw.
There's a spec at
[http://opendwg.org/files/guestdownloads/DwgFormatSpec13-2007.rtf] to
start from.

* Reguired skills/knowledge: C++, some familiarity with AutoCAD and UNO is a plus.

; Contact
: dev@graphics.openoffice.org
: fstrba at novell dot com

===Add animation support to Impress Flash export===

Since OOo2.0, the Impress flash export lacks support for animation
effects. This task is about adding at least initial support for a
selected set of animations (5 common ones of the entry, emphasis, and
exit groups, plus a set of slide transitions) to the Flash export
filter.

* Reguired skills/knowledge: C++, familiarity with Flash and swf file format and Actionscript, UNO know-how is a plus.

; Contact
: dev@graphics.openoffice.org
: cl at openoffice dot org, tbehrens at novell dot com

===Create a Visio import filter for Draw===

OOo currently lacks support for a Visio import filter. This proposal
is about writing one, using the ODF format as input format to be
loaded by the OOo application. Although a full blown filter seems to
be unrealistic to be written within the short timeframe, large parts
of Visio documents should be able to be filtered correctly.

* Reguired skills/knowledge: C++, familiarity with Visio, and a fearless attitude towards poking into binary files.

; Contact
: dev@graphics.openoffice.org
: sj at openoffice dot org, fstrba at novell dot com

===Create a Freelance Graphics filter for OOo Draw===

OOo currently lacks support for a Lotus freelance import filter. This
proposal is about writing one, using the ODF format as input format to
be loaded by the OOo application. Although a full blown filter seems
to be unrealistic to be written within the short timeframe, large
parts of Freelance documents should be able to be filtered correctly.

* Reguired skills/knowledge: C++, familiarity with Freelance graphics, and a fearless attitude towards poking into binary files.

; Contact
: dev@graphics.openoffice.org
: sj at openoffice dot org, fstrba at novell dot com

==Base==
===Joins in dBase queries===

Queries to dBase files can currently contain one table only. Scope of the project is to enhance Base' built-in simple query engine to be capable of executing statements line <code>SELECT table1.field1, table2.field2 FROM table1, table2</code>. The dBase driver, the text/csv driver, and the Spreadsheet driver would all benefit from this extension.

Be prepared to dig around here before starting the project, the project touches low-level core implementations, including some heavy-to-read STL stuff, so be prepared to invest some time before writing the first line of code.

* required skills: C++, SQL knowledge
* useful skills: Lexx and Yacc
* Mentor: Ocke.Jansen at sun.com
* Contact: [mailto:dev@dba.openoffice.org dev@dba.openoffice.org]
* effort: 6 weeks for an experienced developer
* more information on [[Base_To-Do/Joins_in_dBase_queries|the project page]]

===SDBC driver for LDAP directories===

OpenOffice.org already features accessing LDAP data, by shipping Mozilla components which enable access to LDAP servers. However, this solution has some disadvantages, the most prominent being that the broad variety of LDAP schemes (i.e. which LDAP classes and attributes are actually used to reflect the data being of interest) is not captured currently - we use a fixed mapping from LDAP to an OOo table, which seriously limits the use of this feature for some people/organizations. Also, including Mozilla binaries is a constant source of hassles for builds done for the various Linux distributions, to the grade that they effectively disabled the complete functionality.

To enable everybody to access the LDAP data of her choice in OOo, we would need to write a dedicated SDBC driver, which "flattens" an LDAP directory to a database table (i.e. provides the data of an LDAP directory as set of rows), but would be fully customizable. This means the user can herself decide which LDAP attribute should be mapped to which "table column" in the "databases table" provided by the SDBC driver.

* required skills: C++, familarity with UNO
* useful skills: familarity with LDAP, familarity with OOo's database access API
* Mentor: Ocke.Jansen at sun.com
* Contact: [mailto:dev@dba.openoffice.org dev@dba.openoffice.org]
* effort: 4 weeks for the driver, 2 week for the customizability, 3 weeks for a possible user interface
* more information on [[Base_To-Do/SDBC_driver_for_LDAP_directories|the project page]]

===Dialogs with Form Functionality===

When creating a form, the user always needs to bother with a Writer document. Very often, this is much too oversized. It would be sufficient to have a simple dialog which contains all the data access controls.

The project is to (in different steps)
- extend the dialog runtime engine to (optionally) include data-aware form controls
- create a form designer for dialog-based forms (similar to the existing Basic Dialog IDE)
- implement persistence of dialog-based forms
- embed dialog-based forms into database documents (.odb)

Depending on more fine-grained planning, it might become apparent that not all of this can be done in the scope of a Google Summer of Code project, and reasonable milestones need to be defined.

* required skills C++, UNO
* useful skills: familiarity with OOo's database access and form API, as well as OOo's [http://api.openoffice.org/docs/common/ref/com/sun/star/awt/module-ix.html toolkit API]
* Mentor: Frank.Schoenheit at sun.com
* Contact: [mailto:dev@dba.openoffice.org dev@dba.openoffice.org]
* estimated effort: 3 months

* more information on [[Base_To-Do/Dialogs_with_Form_Functionality|the project page]]

== Misc ==

===Enhanced SVG export filter===

OOo has very limited SVG export functionality. This proposal is about
improving the SVG export substantially, e.g. creating SVG that
contains multiple slides and can be navigated trough with mouse or key
events. It's also conceivable to add animation support for Impress
documents, comparable to what the Flash export filter provided in OOo
1.x

* Reguired skills/knowledge: C++, familiarity with SVG, some UNO know-how.

; Contact
: dev@graphics.openoffice.org
: ka at openoffice dot org, kendy at novell dot com

===GUI builder for OOo===

Editing OOo's dialogs with a GUI is currently only possible with the
OOo Basic dialog editor, which is lacking in several ways. This
proposal is about providing support for OOo's new xml resource format
in a GUI editor, by e.g. providing a plugin for Glade.

* Reguired skills/knowledge: familiarity with the chosen dialog editor & its implementation language

; Contact
: dev@gsl.openoffice.org
: jcn at openoffice dot org, pl at openoffice dot org

===Crosscompile Win32 OOo on Linux using MSVC in Wine===

Compiling OOo for Windows is a major pain and comparatively slow, but often
required for the OOo hacker to have her CWS approved. Using the free
Microsoft compiler editions combined with fully FLOSS tooling would
permit virtually everybody to provide OOo Windows builds. This
proposal is about researching this issue, provide the necessary
changes to the build system (and maybe Wine) to make that
possible. There's been a proof of concept that "wine cl.exe" actually
works.

* Reguired skills/knowledge: familiarity with Wine, the command line and the OOo build system are a big plus

; Contact
: dev@tools.openoffice.org
: tlillqvist at novell dot com, kendy at novell dot com

===Template preview===

Currently, OOo's template dialogs has provide hard-coded previews,
that do not take the document at hand into consideration. This
proposal is about providing true preview functionality in the template
dialog, such that a user can judge appearance of individual templates
before actually applying it.

* Reguired skills/knowledge: C++, familiarity with UNO a big plus

; Contact
: dev@framework.openoffice.org
: kendy at novell dot com

===Performance Improvement===

There are several known performance in OpenOffice, and clearly more
that can be found with improved profiling. The exciting part of this
task is clearly, finding and understanding sillies in the code -
mis-uses of otherwise sensible APIs, problematic code structures and
so on; and then with the minimum of code tweaking them to make them
fly. As part of this, a small improvement to KCachegrind's visualisation
will also be required (basic C++). We will also look at reducing memory
use as an extensions. Not really a single task, but a collection of
incremental wins over some weeks.

* Required skills/knowledge: C/C++, familiarity with Linux, profiling

; Contact:
: dev@lists.go-oo.org (please CC me)
: michael meeks at novell dot com, kendy at novell dot com

=New Tasks=

If you have a task that is challenging enough, and there is an OpenOffice.org Project Member willing to mentor the task, feel free to coordinate with the appropriate project lead. If the appropriate project has been found and it supports the task, add it below and make sure the mentor applies with the web app.

Each entry should contain the task description, required skills, project mailing list for discussion and personal contact. Links to the [[To-Dos]] are appreciated provided that the task is well described there ;-)

===Example entry===

This is just an example - the real entry must not start with a space at the beginning
of the line.
A full description of the task should be here; one that will help to see that this task
is important, and interesting to hack on. Alternatively it could be an exact link to
the description that is already in [[To-Dos]].

* Required skills/knowledge: Language, technology1, technology2, ...

; Contact
: dev@project.openoffice.org
: The.Mentor at organization com

Calc/Drafts/Solver Infrastructure

2007-12-05T14:27:38Z

Nn: /* API */ changed operator order

This page is about the UNO API and the user interface which together serve as the basis for optimization solver components in Calc.

== Specification ==

The UI specification is at [http://specs.openoffice.org/calc/features/Solver.odt http://specs.openoffice.org/calc/features/Solver.odt].

== API ==

Here's a rough sketch of the planned API (service com.sun.star.sheet.Solver):
<pre>
enum SolverConstraintOperator
{
LESS_EQUAL,
EQUAL,
GREATER_EQUAL,
INTEGER,
BINARY
};

struct SolverConstraint
{
com::sun::star::table::CellAddress Left;
SolverConstraintOperator Operator;
any Right;
};

interface XSolver: com::sun::star::uno::XInterface
{
[attribute] XSpreadsheetDocument Document;
[attribute] com::sun::star::table::CellAddress Objective;
[attribute] sequence< com::sun::star::table::CellAddress > Variables;
[attribute] sequence< SolverConstraint > Constraints;
[attribute] boolean Maximize;
void solve();
[attribute, readonly] boolean Success;
[attribute, readonly] double ResultValue;
[attribute, readonly] sequence< double > Solution;
};

service Solver: XSolver;
</pre>
The dialog allows selection of cell ranges, and splits them into individual cells (for simplicity of the API). The order of values in the “Solution” sequence matches the order of cells in “Variables”.

[[Category:Calc|Solver Infrastructure]]
[[Category:To-Do]]
[[Category:Draft]]

Calc/Drafts/Solver Infrastructure

2007-11-16T11:20:23Z

Nn:

This page is about the UNO API and the user interface which together serve as the basis for optimization solver components in Calc.

== Specification ==

The UI specification is at [http://specs.openoffice.org/calc/features/Solver.odt http://specs.openoffice.org/calc/features/Solver.odt].

== API ==

Here's a rough sketch of the planned API (service com.sun.star.sheet.Solver):
<pre>
enum SolverConstraintOperator
{
LESS_EQUAL,
GREATER_EQUAL,
EQUAL,
INTEGER,
BINARY
};

struct SolverConstraint
{
com::sun::star::table::CellAddress Left;
SolverConstraintOperator Operator;
any Right;
};

interface XSolver: com::sun::star::uno::XInterface
{
[attribute] XSpreadsheetDocument Document;
[attribute] com::sun::star::table::CellAddress Objective;
[attribute] sequence< com::sun::star::table::CellAddress > Variables;
[attribute] sequence< SolverConstraint > Constraints;
[attribute] boolean Maximize;
void solve();
[attribute, readonly] boolean Success;
[attribute, readonly] double ResultValue;
[attribute, readonly] sequence< double > Solution;
};

service Solver: XSolver;
</pre>
The dialog allows selection of cell ranges, and splits them into individual cells (for simplicity of the API). The order of values in the “Solution” sequence matches the order of cells in “Variables”.

[[Category:Calc|Solver Infrastructure]]
[[Category:To-Do]]
[[Category:Draft]]

Calc/Features/DataPilot drill-down on data field

2007-11-02T13:45:45Z

Nn: menu, hidden items, API not for 2.4

== Description ==
When a cell within the data field is double-clicked, it inserts a new sheet containing a subset of rows from the original data source that constitutes the result data displayed in that cell. For instance, when the data field function is selected to be SUM, then the number that is shown in the data field cell must be identical to the sum of all the data field values in the constituent rows displayed in the inserted sheet.

The area that can provide a drill-down sheet spans from the top-left cell in the data field to the bottom-right corner of the data pilot output, including the '''Total Result''' row and column.

The same function is available using "Data / Group and Outline / Show Details" from the menu, with the cell cursor on the result cell.

Hidden items ("Hide items" or "Show automatically" in the field options dialog) are not evaluated, the rows for the hidden items are included.

The feature is available for DataPilot tables from cell ranges or database data, but not yet for external service implementations (see API Change below).

== API Change (not for 2.4) ==

This functionality introduces the following new API.

<code>[cpp,N]
module com { module sun { module star { module sheet {

interface XDataPilotTable2: com::sun::star::sheet::XDataPilotTable
{
sequence< sequence< any > > getDrillDownData( [in] com::sun::star::table::CellAddress aAddr );
};

}; }; }; };
</code>

<code>[cpp,N]
module com { module sun { module star { module sheet {

interface XDrillDownDataSupplier: com::sun::star::uno::XInterface
{
sequence< sequence< any > > getDrillDownData(
[in] sequence< com::sun::star::sheet::DataPilotFieldFilter > aFilters );
};

}; }; }; };
</code>

<code>[cpp,N]
module com { module sun { module star { module sheet {

struct DataPilotFieldFilter
{
/** Field name. */
string FieldName;

/** String value that needs to match against. */
string MatchValue;
};

}; }; }; };
</code>

The ''com.sun.star.sheet.DataPilotSource'' service will support the ''XDrillDownDataSupplier'' interface to provide a 2-dimensional array data consisting of a subset of the original data source table that satisfies a given set of filtering criteria. A sequence of ''DataPilotFieldFilter'' provides desired filtering criteria to ''getDrillDownData()'' method. This interface is intended for an external UNO package so that it can overwrite the interface to provide constituent rows when requested.

The interface ''com.sun.star.sheet.XDataPilotTable2'' extends the existing ''com.sun.star.sheet.XDataPilotTable'' interface to provide additional method ''getDrillDownData()'' so that the client code can obtain constituent rows from the data pilot table. The existing ''com.sun.star.sheet.DataPilotTable'' service will support this new interface.

[[Category:Calc|Features/DataPilot drill-down on data field]]
[[Category:Feature|DataPilot drill-down on data field]]

Developers FAQ

2007-07-13T16:43:36Z

Nn: /* Application, Calc */

The Developers FAQ is a collection from different questions asked by Developers who are new to OpenOffice.org:

This is work in progress, the developer mentioned behind the question will write the answer soon.

==Framework==
* Description of the SFX2 framework? (MBA)
* There are the roles of the different shells and views? See [[Framework/Article/Implementation_of_the_Dispatch_API_In_SFX2|Implementation of the Dispatch API In SFX2]]
* Explanation of the dispatch/interceptor mechanism / command handling? See [[Framework/Article/Implementation_of_the_Dispatch_API_In_SFX2|Implementation of the Dispatch API In SFX2]]
* How is the slot mechanism implemented, and how is the listener and broadcast mechanism implemented? See [[Framework/Article/Implementation_of_the_Dispatch_API_In_SFX2|Implementation of the Dispatch API In SFX2]]
* Generic user interface: How does the framework implement the interface management, how to load toolbar, and how to implement berth area? See [[Framework/Article/General_Architecture_Of_The_Framework_User_Interface_Implementation|General Architecture of the Framework User Interface]]
* Filter configuration
** [http://api.openoffice.org/docs/DevelopersGuide/OfficeDev/OfficeDev.xhtml#1_2_4_Integrating_Import_and_Export_Filters Developer's Guide 7.2.4 Integrating Import and Export Filters]
** Note: Description of the used configuration format in XML is outdated.
* API for accessing OOo package format
** http://api.openoffice.org/docs/common/ref/com/sun/star/embed/Storage.html
* Embedding (MAV)
* Templates (MAV)
* Add-ons / Extensions support
** [[Framework/WorkInProgress/Addon_Menu_Toolbar_Merging|Support merging into the Office menu bar/toolbars.]]
** [[Framework/Article/Generic_UNO_Interfaces_for_complex_toolbar_controls|Complex toolbar controls for add-ons.]]
** [http://api.openoffice.org/docs/DevelopersGuide/Components/Components.xhtml#1_7_3_Add-Ons Developer's Guide 4.7.3 Add-ons]
** Add-on examples with sources (http://framework.openoffice.org/servlets/ProjectDocumentList?folderID=226&expandFolder=226&folderID=72)
* The general part of the document storing/loading process (MAV)

==[http://udk.openoffice.org UDK]==
* Mechanisms of Multi-Platform support ([[KR]])
:I assume this means multiple language support, please see [[Uno/Article/Working_with_Environments%2C_Mappings_%26_Objects|Working with Environments, Mappings & Objects]] .
* How to communicate with other OOo components, and how to implement a bridge ([[KR]])
: There is a tutorial for implementing C++ bridges, please see http://udk.openoffice.org/cpp/man/cpp_bridges.html . Most [[Uno/Binary|Binary Uno]] bridges are implemented in the [[Uno/Binary/Module/bridges|bridges]] module.
* [[Uno/PyUno|Python Uno]] components may be run within the OOo process - how can they be called from [[Java]], [[C++]] or [[BASIC|StarBasic]]? ([[KR]])
: [[Uno/PyUno|Python Uno]] components may be accessed like any other component, e.g. by doing a "createInstance" with a service which is implemented in [[Uno/PyUno|Python Uno]].
* The relationship between [[Uno]], COM+, CORBA ([[KR]])
: For a comparison between [[Uno]] and CORBA please see http://udk.openoffice.org/common/man/comparison_uno_corba.html , though [[Uno]] nowadays does support multiple inheritance. Also there was an effort, which unfortunately did not complete, do implement a [[Uno]] CORBA bridge, please see http://udk.openoffice.org/common/man/concept/uno_corba.html .
: There is no document regarding [[Uno]] and (D)COM+. [[Uno]] has some similarities with COM+:
:* "queryInterface"
:* Language agnostic
:* "Apartments", please see the [[Uno/Spec/Threading-Model|Uno Threading-Model]] for details.
:* Components
:* Remote transparency

==Application, Writer==
* Structure of tables? [[Writer_Core_And_Layout]]
* Mechanism/Implementation of Undo? [[Writer_Core_And_Layout]]
* Mechanism/Implementation of Frames, relationship? [[Writer_Core_And_Layout]]
* Class structure of SwNode, SwNodes, SwNodeIndex, ..., relationship? [[Writer_Core_And_Layout]]
* The relationship between the class ViewShell and SwDoc (OS)

==Application, Draw/Impress==
* The mechanism of slide show and animation (what is the difference between before and after)?
** The slideshow itself, and all animation functionality are implemented in the [[Slideshow]] module. (What is the meeaing of "before" and "after" in the context of this question?)
* Copy&Paste: Memory structure of clipboard in SD, difference between coping objects inside slides and coping objects from or into other applications like SW, SC?
** Clipboard between the same application type is done by using core implementations. Clipboard between different application types is done by using xml.
* Mechanism of designing and implementation of master page and layout style in presentation (CL)
** Master pages and layout styles are already implemented in OOo.

* Flash Export: (CL)
** Difference between the export of the simple character and the complex character?
*** Simple characters are exported using the font tags of the flash format, complex characters are exported as polygons.
** The implementation of the Polygon in VCL. Such as the EM square，Body，Ascent and Descent to realize of the glyph?
*** This question needs more data as the implementation of the Polygon in VCl itself has nothing to do with glyphs. It is only used to represend glyphs.
** The custom animation will be lost after the slides being exported into the swf. What cause it? There is no support to export the animation, is there? Do you have any plan to consummate it? And what's your purpose in this area?
*** It is caused by the absence of an implementation that exports this particular feature. There is currently no assigned developer for the task to add this feature to the flash export. One developer from Redflag is activly contributing to the flash export.

==Application, Calc==
* How are the areas for charts recognized, and how does the update notification work? (NN)
** Note that much of this has changed for the new chart. Don't make any changes based on older versions (before SRC680m213).
** The chart implementation uses the UNO API (XDataProvider) to get data sequence objects for each data series, and registers itself as modify listener with these objects.
** For the time when a chart object hasn't been loaded yet, Calc has its own internal listener (ScChartListener) to load the chart if its data is changed.
* Relationship between cells, sheets and workbooks (class diagram) (NN)
** The core implementation of the document is class ScDocument. It has an array of pointers to ScTable (implementation of a sheet). Each sheet has a fixed-size array of ScColumn objects. Each ScColumn object holds the cells in one column.
** The cells are implemented by base class ScBaseCell and derived classes:
*** ScNoteCell (empty except for note and listeners)
*** ScValueCell (constant numeric value)
*** ScStringCell (simple text)
*** ScEditCell (formatted or multi-paragraph text)
*** ScFormulaCell (formula)
* Copy&Paste: What's happening on Copy directly, and later if someone pastes into same spreadsheet or other application (NN)
** Implementation of copy for cells is at ScViewFunc::CopyToClip. The cells are copied into an internal object (ScDocument), then a ScTransferObj is created as the interface to the clipboard.
** Pasting into Calc copies the cells directly from the internal ScDocument object. Clipboard data in other formats for external applications is created on demand by ScTransferObj (ScTransferObj::GetData).

==Application, Database==
* Why was the dbase driver engineered into file_based driver? And compared with the text/csv driver, what are the advantages of it in OOo's database, and how it was being designed in OOo's database?
** The "file" driver is not an own driver, it's a framework for, well, file-based databases, where a single file represents a table, and all such files in a given directory comprise the database. Both the text/csv driver and the dBase driver use this framework.
** The advantage of the dBase driver over the text/csv driver is that the former can read dBase files, while the latter can't.
** What do you mean with "was being designed"?
* What are the project's short-term plan or the direction of development now?
** There are two areas which we currently mainly focus on: The new report designer which will be part of OpenOffice.org 2.3, and improved programmability of Base, where the first step is to allow embedding macros in database document.
* In the project named "Native, cross-platform access to MS Access databases", what is the current solution? Is there anyone beginning to re-engineer the MDB format himself?
** The current solution is employing [http://mdbtools.sourceforge.net/ MDB-Tools], a third-party product which allows access to .mdb files. The driver based on MDB-Tools is in [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?logon=true&Id=2959&Path=SRC680%2Fmdbdriver02 alpha state], and still has serious shortcomings. The project itself is currently stalled, nobody is actively working on it. Also, nobody is working on doing a reverse-engineering of the MSA file format. If somebody wants to do this, we should seriously investigate whether it makes more sense to support and improve existing reverse engineering efforts, namely MDB-Tools.

==Application, Chart2==
* Description of the Chart2 module: [http://graphics.openoffice.org/chart/chart2codestructure.html Code Structure of chart2]

==General Questions==
* Which are the common threads started at start up time and used by all OOo applications at runtime, and what are their functions? ([[KR]])?
: A first over regarding the threads can be found here: [[Effort/Implement_Basic_Threading-Architecture#Threads]] More to come ...
* Structure of VCL? See [[Sort_of_documentation_about_VCL_around_Native_Mac_OS_X_port]]
** A general overview about VCL was created by Eric Bachard, please have a look [http://wiki.services.openoffice.org/wiki/User:Ericb#Sort_of_documentation_about_VCL_around_Native_Mac_OS_X_port here]
* [[TextRenderingProcess|Text rendering process]]
* Memory Management (MT/MHU)
* How to improve stability, and where to start? Beside doing thorough QA, you might use tools like [http://tools.www.openoffice.org/debugging/usingvalgrind.sxw Valgrind] or [http://tools.openoffice.org/files/documents/15/872/BoundsChecker.html BoundsChecker]
* How to improve performance, and where to start? Use a [http://en.wikipedia.org/wiki/Performance_analysis profiler] to analyze the runtime behavior of the code that you want to improve.
* Which code of OOo is responsible for the VBA Macro parse? How are they implemented?
** This is done by a hard coded parser in basic/source/comp
* How is the code implemented to fulfill the specification of Unicode and gb2312 (SB): Follow the source code links for “UTF7“ and “UTF8“ (Unicode) and “EUC_CN” (GB2312) in [http://porting.openoffice.org/source/browse/porting/sal/textenc/textenc.cxx?rev=1.6&view=markup sal/textenc/textenc.cxx:1.6].
* How/where is the Boost library used? See [[boost]] for an overview.
* The process of SVG protraction and SVG parse. The relationship between controller protraction and the resource of the controller. (SJ)
* Mozilla and ActiveX plugins (MAV)
* Which internet protocols are supported in OOo, and what can be improved to the network ability of OOo? (KSO)

==Feature Questions==
* Currently a document can only be processed by one of the OOo applications - what about having just one application processing all kind of documents?
* Are there any plans to integrate a desktop search engine? (Could be done as an extension)
* Any plans to introduce classes comparable to CObject and CWinApp in MFC? (???)

[[Category:FAQ]]
[[Category:Developer_Documentation]]

Summer of Code 2007

2007-03-05T16:25:16Z

Nn: Calc: Watch Window

Similarly to the [[SummerOfCode2006|last year]], OpenOffice.org would like to participate in the [http://code.google.com/soc/ Summer of Code] initiative sponsored by Google.

This page is here to collect the suitable suggestions. So - if you have a task that is challenging enough, and are willing to mentor the task, feel free to add it below. Each entry should contain the task description, required skills and personal contact. Links to the [[To-Dos]] are appreciated provided that the taks is well described there ;-)

We would be glad to support a few projects. Mentoring capacities are limited, so we depend on your dedication during the preparation of the detailed specification and description of the outcome.

For further general questions about the initiative Google prepared a [http://code.google.com/support/bin/topic.py?topic=10442 FAQ].

==The Tasks==

===Example entry===

This is just an example - the real entry must not start with a space at the beginning
of the line.
A full description of the task should be here; one that will help to see that this task
is important, and interesting to hack on. Alternatively it could be an exact link to
the description that is already in [[To-Dos]].

* Required skills/knowledge: Language, technology1, technology2, ...

; Contact
: dev@project.openoffice.org
: The.Mentor at organization com

===Draw/Impress: SVG Import Filter===

[http://www.w3.org/Graphics/SVG/ SVG (Scalable Vector Graphics)] is a vector graphics format that describes 2D graphics in XML.

There's no native SVG import filter for OOo. There exists an [http://www.ipd.uka.de/~hauma/svg-import/ external one], but unfortunately it has very strong dependencies - [http://java.sun.com/javase/downloads/index.jsp Java 5.0], and [http://xmlgraphics.apache.org/batik/ Batik]. The goal of this task is to create a new implementation that does not require any too big libraries.

A proof of concept implementation written in C++ using the UNO Draw API, and a lighweight [http://cairographics.org/libsvg libsvg library] exists (see [http://svn.gnome.org/viewcvs/ooo-build/trunk/patches/src680/svg-import.diff here]), but it needs a lot of work to be really usable. Also libsvg does not seem to be too actively maintained, so maybe it would be desirable to use something other library than libsvg; but similarly to it, the solution should be lighweight.

More information is available in [http://artax.karlin.mff.cuni.cz/~kendy/blog/archives/monthly/2006-10.html#2006-10-02T17_14_44.htm Kendy's blog].

* Required skills/knowledge: C++, XML knowledge is a plus

; Contact
: Jan Holesovsky - kendy at openoffice org
: Fridrich Strba - fridrich_strba at openoffice org

===Calc: Integration of R into Calc===

Create an add-on component that allows a Calc user to let the [http://www.r-project.org/ R environment] do calculations on data from Calc cells and put the results into the spreadsheet again.

This should include a dialog to select input parameters and options, and allow results to be values or graph images. Note that the incompatible licenses (R is under GPL) have to be taken care of, possibly by starting R as a separate process.

Some more thoughts on the subject have been collected at [[Statistical Data Analysis Tool#Third Party Library Integration]].

* Required skills/knowledge: Some familiarity with statistical methods

; Contact
: dev@sc.openoffice.org
: Niklas.Nebel at sun.com

===Calc: Watch Window===

A Watch Window is a separate, small window that remains "on top" and enables users to monitor a selected set of cells, see [http://www.openoffice.org/issues/show_bug.cgi?id=28386 issue 28386].

This could be implemented as an add-on component with a modeless dialog containing the list of watched cells as well as the UI to add or remove cells.

* Required skills/knowledge: Java or C++

; Contact
: dev@sc.openoffice.org
: Niklas.Nebel at sun.com

===Writer: RTF Generator===

The current RTF export of OpenOffice.org is not as good as the export to the Word (.doc) format. Parsing the generated Word format stream with a Word tokenizer and handing over the generated events to an RTF generator would lead to an RTF export filter with the same quality as the binary Word export filter. Remark: the tokenizer itself isn't complete today but in its current state covers enough parts of the Word format to make this a valuable project for the planned time span.

* Required skills/knowledge: C++, some knowledge about the Word file format would be a plus

; Contact
: dev@sw.openoffice.org
: Henning.Brinkmann at sun.com

===Writer: Lotus WordPro filter===

If you know something about the format of Lotus WordPro - here's the perfect task for you! Anything can be useful as a start, even a simple filter that just excerpts the pure text. A first patch is available but it doesn't work good enough until now.

* Required skills/knowledge: C++, some knowledge about the WordPro file format

; Contact
: dev@sw.openoffice.org
: Mathias.Bauer at sun.com

Summer of Code 2007

2007-03-02T12:43:32Z

Nn: Calc: Integration of R into Calc

Bios

2006-11-13T19:04:32Z

Nn:

This page is for the bios and pictures of the OpenOffice.org project leads.

=== Native Lang / L10N ===
* [[User:Rescue| Joey Stanford]] - [http://eo.openoffice.org Esperanto Team]
* [[User:southerncross|Charles-H.Schulz]] - [http://native-lang.openoffice.org NLC Lead]
* [[User:Jcorrius|Jesús Corrius]] - [http://ca.openoffice.org Catalan Native Language / Catalan L10N Lead]
* [[User:Jza|Alexandro Colorado]] - [http://es.openoffice.org Spanish Native Language Lead]
* [[User:markomlm|Marko Moeller]] - [http://de.openoffice.org German Native Language Co-Lead]
* [[User:laonux|Anousak Souphavanh]] - [http://lo.openoffice.org Lao Native Language Lead]
* [[User:ScottCarr|Scott Carr]] - [http://documentation.openoffice.org Documentation Co-Lead]
* [[User:Richard|Richard Holt]] - [http://es.openoffice.org Spanish Native Language Co-Lead]
* [[User:Richard|Richard Holt]] - [http://lingucomponent.openoffice.org Lingucomponent Project Co-Lead]
* [[User:Gorkem|Görkem Çetin]] - [http://www.openoffice.org.tr Turkish Native Language Lead]
* [[User:grsingleton|G. Roderick Singleton]] - [http://documentation.openoffice.org Documentation Co-Lead]
* [[User:jpmcc|John McCreesh]] - [http://marketing.openoffice.org Marketing Project Lead]
* [[User:Kevin Scannell|Kevin Scannell]] - [http://ga.openoffice.org Irish Native Language Lead]
* [[User:Hristo Hristov|Hristo Hristov]] - [http://bg.openoffice.org Bulgarian Native Language Lead]

=== Development ===

* [[User:mba|Mathias Bauer]] - [http://framework.openoffice.org Application Framework Project Lead]
* [[User:mh|Martin Hollmichel]] - [http://tools.openoffice.org Tools Project Lead], [http://porting.openoffice.org Porting Project Lead]
* [[User:nn|Niklas Nebel]] - [http://sc.openoffice.org Spreadsheet Project Lead]

=== Bibliographic ===

* [[dnw-bios|David Wilson]] - Co-Lead Bibliographic Project
* [[User:Bdarcus|Bruce D'Arcus]] - Co-Lead Bibliographic Project

User:Nn

2006-11-13T19:01:19Z

Nn:

* Name: Niklas Nebel
* OpenOffice.org account name: nn
* [http://sc.openoffice.org Spreadsheet Project Lead]
* Working at Sun in Hamburg
* StarOffice development since 1994