Planet OpenOffice.org

Planning Template

OpenOfficeorg: OOo Extensions: OKDict . http://tinyurl.com/2cla44l

OpenOfficeorg: OOo Extensions: Copy only visible cells . http://tinyurl.com/27tflbl

OpenOfficeorg: OOo Repository For Templates: Family Tree . http://tinyurl.com/2e49k8p

OpenOfficeorg: OOo Repository For Templates: Full Face CD Label FFCD and GWFFCD . http://tinyurl.com/2ajwuuf

One year ago, talking about open source adoption in Italian Public Administrations, I reported some SourceForge traffic distribution numbers, showing that Italy was at the fourth place after Brasil.

Italy before was used to be at the third place, but the impact of open source in Brazil was and actually is, definitely stronger. Let’s have a look at the big picture, and how Europe and BRIC countries are today, as of the 29th of July 2010.

While you are looking at SourceForge traffic distribution by countries, read also the numbers.

US (blue) is at the first place, followed by Brazil (9.93%), Germany (6.46%), France (5.59%) and eventually Italy (4.28%). Globally Europe exceeds 40% of the global traffic (Western Europe ~ 16%, Southern and Eastern Europe both  ~ 9%, and Northern Europe ~ 7%), while Americas are around 35% and Asia slightly under 19%.

BRIC collectively holds over 18% of the world traffic, more than USA.

Disclosure. I am a member of SourceForge advisory board.

#i113539# - Database access: [dba_ReportBuilder.bas] Crash when opening Formula Wizard
#i113537# - Presentation: Doesn't display presentation on both screens
#i113545# - framework: Images Not Exported in PDF
#i113544# - framework: OpenOffice crashes while opening certain .doc and .xls files
#i113540# - framework: STL error in senddoc.exe
#i113546# - framework: crash when printing
#i113543# - framework: svtools: automatic icons in menu setting gets "stuck"
#i113548# - qa: [Automation] refactor g_spellcheck.bas
#i113549# - qa: [Automation] refactor id_tools_2.inc
#i113547# - sw: Cropped picture not correctly exported in PDF
#i113541# - sw: Unreadable DOCX in conjunction with different sections
#i113542# - sw: sw: math objects are not exported to .doc files
#i113538# - tools: make destination for localized help files configurable

#i113530# - Drawing: SVG Uselessly
#i113524# - framework: Bundled extension doesn't behave a specified
#i113535# - framework: Find & Replace attributes - Options list is non-localisable
#i113529# - l10n: [DE] text is truncated in tools>options> Calc>Calculate
#i113527# - sc: All text appears black, even when it's supposed to have a light colour.
#i113525# - sc: Custom View
#i113528# - sc: Empty cells wrongly printed as zeros
#i113534# - sc: Spreadsheet: no sheet editing
#i113536# - sw: Menu and window icons and text missing
#i113533# - sw: Pasting formatted content loses part of formatting
#i113532# - sw: RTF: Improve Writer export filter
#i113526# - sw: Writer 3.2.0 and 3.2.1 hangs attempting to open doc from 3.0
#i113531# - tools: solenv: Use recommended windows linker flags

Full Face CD Label FFCD and GWFFCD

Resources Combine GWOS Monitoring With Webmetrics Web Site Services - Join this webcast to learn how Webmetrics and GWOS are coming together to deliver monitoring for all of your assets on a single console.
August 4, 10 am PST

Subversion Conferences Live - a series of one day conferences for developers, administrators and IT managers to be held at four locations in the US and the UK in September featuring live sessions covering Subversion’s future.

• 9/14 - Silicon Valley - San Jose Hilton
• 9/16 - Boston - Crowne Plaza, Newton, MA
• 9/23 - Sheffield, UK - Electric Works
• 9/28 - London, UK - Heathrow Airport Hilton

Webinar: GWT Cloud Applications-Fast, Fun and Easier than Ever - Europe - Following on from the exciting announcements at Google I/O 2010, join engineers from Google and SpringSource to discover how the latest innovations in Spring Roo, STS and Google Web Toolkit allow you to quickly and easily deliver high-performance rich internet applications written in Java.
September 16,  4 pm CET

#i113521# - Formula editor: Math symbols from OpenFormula inconsistent
#i113518# - Formula editor: mixing variables and text confuses cursor in command window
#i113512# - Presentation: Command name missing ".uno:TaskPaneInsertPage"
#i113513# - documentation: Writer Help: text alignment L2R and R2L
#i113516# - framework: OO will not open following update
#i113514# - framework: text does not autoresize when resizing a chart
#i113522# - qa: [Automation][c_updt1.bas]Solaris timingproblem in tFileOpenCSV
#i113520# - qa: [Automation][f_standard_toolbar.bas] Weblog extension adds items to toolbar
#i113523# - sc: Changing format from numbers to text rounds values
#i113511# - sc: Command name missing ".uno:ValidityReference"
#i113519# - sw: SwXTextFieldTypes.refresh() does not change format
#i113517# - sw: Text does not center properly on large pages
#i113510# - sw: not able to set "Always save as" to .doc
#i113515# - vba: Don't support to run macro having big module

#i113509# - Database access: Base file give errors when attempting to update data by ANY means, duplicates records, deletes records at random when opened with Oo 3.2.1
#i113508# - Database access: Controls render incorreclty when ControlModel.NativeWidgetLook = TRUE for Gnome 2.30
#i113506# - Database access: thisDatabaseDocument.FormDocuments.getbyName( XX ).open retuns NULL if form is aldready open
#i113507# - framework: Cannot call Python macro from Basic macro when running headless
#i113499# - gsl: [vcl] assertion salnativewidgets-gtk.cxx:2294
#i113504# - l10n: Add Sorbian, Lower [dsb-DE] locale data.
#i113503# - porting: system cppunit built against system stl + internal stlport
#i113505# - sc: can't add words to dictionary
#i113501# - sc: performance: first call of any task is slow
#i113502# - sw: Assignment to keys Alt+F6, Alt+Left, Alt+Right fails
#i113500# - sw: WordRightSel selects word right PLUS whitespace right
#i113498# - www: submition of ssh2key

Some street hockey played in Yaletown during the O(we)lympics, Vancouver, BC - February 17th, 2010

Family Tree pedigree chart and family group sheets

This extensions provides an alternative to the 'Select Visible Cells' command in Microsoft Excel. It´s useful to use with filters or subtotals. To use the 'Copy only visible cells' function, do the following steps:

1. install the extension;
2. restart OpenOffice.org;
3. open your sheet with hidden rows or columns;
4. select a range;
5. insted the simple copy button, click in 'Copy only visible cells' button;
6. paste in your target document, for example, another sheet or a RTF text table. The hidden rows or columns won´t paste.

Note: it´s not possible paste especial with the Link DDE option.

Developed by Gustavo B. Pacheco, BrOffice.org, Brasil.
Special thanks: Andrew Pitonyak, Stephan Wunderlich, Ryan Nelson, Christian Junker and Comune di Bologna.

Thousands of NHS staff stripped of Microsoft Office | Enterprise | News | PC Pro

The OKDict extension enables you to look up word definitions on the Internet. The protocol used to retrieve the definitions is the DICT protocol. You can use OKDict with the main applications of the OpenOffice.org software suite, such as Writer, Writer/Web, Calc, Draw and Impress.

With OKDict, you can very easily look up the definition of a word in a document. Just select the word (or right-click the word in a Writer document) and choose Define from the context menu. The definition is displayed in the dictionary browser.

The dictionary browser works like a web browser: it has an input field, where you can enter a word to define, and a definition area, where the definitions are displayed. If you select a word in the definition area, its definition will be automatically retrieved and displayed. You can go back and forward in the search history.

OKDict can be configured with the OpenOffice.org options dialog. The OKDict options dialog can be accessed from Tools - Options - Language Settings - OKDict.

The OKDict user manual is integrated in the OpenOffice.org user manual. It can be accessed from the Contents tab in the OpenOffice.org user manual.

Please bear in mind that the results you get depend on the server you use. There is a list of servers you can use if the default server doesn't suit your needs.

Warning: after installing OKDict, you have to stop the Quickstarter and to restart OpenOffice.org before you can use the extension.

OKDict requires OpenOffice.org version 3.2.1 (or later) on Windows (Windows 2000 or later).

#i113494# - Database access: postgresql-sdbc-076a driver cause OOo to not start
#i113493# - Drawing: Cursor position in text box is confused by character format
#i113497# - Formula editor: MathML Import Issue for Fractional Equations
#i113488# - framework: File.Wizards submenu shows no icons
#i113489# - gsl: toolkit/qa/unoapi toolkit.AccessibleMenu{,Bar,Separator} failures
#i113490# - gsl: vcl: a11y: crash in atk_wrapper_focus_idle_handler
#i113496# - l10n: UI Language switch based on glibc locale
#i113495# - qa: [Automation][ch2_]XML_format has warnings
#i113492# - qa: [automation] [i_updt_1.bas] [tiViewToolbar_1 tiInsertSlideExpandSummary] fix the errors
#i113491# - sc: No repaint if a style is moved in Stylist
#i113486# - sw: Document properties cannot be saved
#i113487# - vba: Can't redim an array like VBA

Packt is about to launch the 2010 Open Source award - now at its fifth edition, formerly known as Open Source CMS Awards - an award organized to encourage, support, recognize, and reward Open Source projects selected by a panel of judges and Packt website visitors. This year they have a prize fund of $247,000 spread across six categories.

From August 9, you are invited to submit a nomination for an Open Source Project to be put forward to the final voting stage in each category. The following categories make up the 2010 Open Source Awards.

• Open Source CMS

• Hall of Fame CMS

• Most Promising Open Source Project

• Open Source E-Commerce Applications

• Open Source JavaScript Libraries

Also, this year I have been invited again to join the judge panel, and I look forward to share my thoughts and comparative analysis of open source programs with other judges and learn about their views about Open Source e-commerce applications.

Follow Packt blog for further information about the 2010 Open Source Awards.

Peter Korn's Weblog

Developer Snapshot OOo-Dev OOO330m2 is available for download.

OOO330 is the development codeline for upcoming OOo 3.3.x releases.

If you find issues within this build please file them to OpenOffice.org's bug tracking system IssueTracker.

Download:
http://download.openoffice.org/next

Release Notes:
http://development.openoffice.org/releases/OOO330m2_snapshot.html

MD5 checksums:
http://download.openoffice.org/next/md5sums/OOO330m2_md5sums.txt

OpenOfficeorg: OpenOffice.org translations going smoothly . http://tinyurl.com/2dfhmyc

#i113475# - Database access: Sun remained in one of the error message
#i113481# - framework: Cannot call Python macro from the command line using URI syntax
#i113470# - framework: Find&Replace - "Continue at the beginning" dialog appears on the left side of the display (not in the middle)
#i113476# - framework: Printing multiple files at once crashes OOo
#i113472# - gsl: More consistent glyph fallback on non-fc platforms
#i113474# - gsl: vcl/os2/inc/xwphook.h has GPLv2 license
#i113468# - l10n: [De] ooo330l10n - string to long in Calc options "Limit decimals for general number format"
#i113478# - lingucomponent: Fixes to Serbian hyphenation patterns for integration in sr dictionary
#i113473# - qa: OpenOffice will only open if I reboot my pc
#i113469# - sc: ooo330l10n - enhanced data pilot popup to narrow
#i113480# - sw: .doc files not opened by IE
#i113479# - sw: 330m1 only prints 1
#i113483# - sw: A file option with Paste Special
#i113477# - sw: Cannot create template with specific "per chapter table of content"
#i113471# - sw: Corrupt Writer Files
#i113482# - sw: Not enough freedom in literature list (APA support)
#i113485# - ui: Uyghur language
#i113484# - www: Startup

A few days ago the new 3.3 localization cycle started and this time I wasn’t the lead of the project. Instead I had Santiago Bosio in charge of the localization for the Spanish project. This made the localization work more efficient since Santiago is already immerse in the project for testing and extra localization processes. The community had a great reaction for the call for action and the latest report came through with a great speed and quality cycle. It seems we will have a 100% string localization soon.

The twist is that this cycle will be delegated to traditional po editing tools as opposed to our own pootle system due to outages that have proven the strings to not always be reliable.

On other OpenOffice.org news I have update my talk on BizDev and exposing the BoF on how to make this project become more efficient. The whole brief will be posted soon on the OpenOffice.org Conference (www.ooocon.org).

• Up early; off to the Advisory Board meeting, only to discover my clock was out of sync; an hour late. Lots of discussion and old friends much of the day.
• Out for dinner with Bradely, Lennart, Caillon, Dan, and a bunch of other interesting guys; back - for beers with Caillon. Bed late.

OpenOfficeorg: New Lab Files for GetOpenOffice.org . http://tinyurl.com/29vztqv

OpenOfficeorg: New build models and relability in the developer snapshots OpenOffice.org Canery . http://tinyurl.com/24nymm8

OpenOfficeorg: New OOo Templates: Money Management Template . http://tinyurl.com/2co6g7f

OpenOfficeorg: New OOo Templates: OpenOffice Accounting 2.0 . http://tinyurl.com/2baovfl

OpenOfficeorg: New OOo Templates: Blank CD Label Template 4.5 . http://tinyurl.com/26a6b87

OpenOfficeorg: Child Workspace Integrated: Automationemailchange, Dba33g, Emailmerge33fix Graphite03, Impress193, Tl81 . http://tinyurl.com/28e523g

OOO330_m2 has been built by Hamburg RE. No open build problems are known, and smoketest has been passed successfully.

Tasks and their ChildWorkspaces for Milestone OOO330m2

Child Workspaces integrated:

automationemailchange

change the email address in the file header of each testscript in the module testautomation from sun to oracle.
This CWS does not change any office code.

dba33g

fast track to MWS for the fix for issue 111205

emailmerge33fix

3.3 regression fixes for emailmerge

graphite03_OOO330

Improvements to Graphite, especially for performance

impress193_OOO330

Showstopper fixes for Impress

impress194

Impress showstopper fixes

kso45

native321

OOo 3.3 installation tasks

solaris10u8_OOO330

make OOo run on Solaris 10 Update 8: build libxml2/libxslt with versioned symbols
(using system libxml2/libxslt doesn"t work)

sw33bf07

fixes in Writer for OOo 3.3

tl81_OOO330

Misc. bug fixes for OOO 3.3

unoawt2_OOO330

ooo330m2masterfix

CD Labels WL-1200 (Same size Avery® 5824™

#i113453# - Database access: After setting more columns as primary key, can't open and update data of the table
#i113452# - Presentation: Error in conversion arrows when save file as PowerPoint presentation
#i113455# - framework: 330m1 german testversion not installable
#i113465# - framework: sfx2: Search & Replace dialog on BASIC IDE truncates strings
#i113463# - framework: unopkg crashes when synchronizing bundled extensions
#i113462# - l10n: [De] ooo330l10n - Math: context menu for formatting partially translated
#i113457# - l10n: [De] ooo330l10n - wronmg wording in printer settings, custom page layout
#i113459# - l10n: [De] ooo330l10n -wrong index entry for DIA function
#i113456# - lingucomponent: Please add the latest german dictionaries (for de_DE, de_AT, de_CH)
#i113458# - qa: [Automation][f_security_macrosecurity.bas] Test has 36 warnings
#i113467# - qa: [automation] migrate several bugfixes that were done for 3.3 also for 3.4
#i113466# - sc: OpenOffice calc viewing (coloms heights and width) not equal to Excel
#i113454# - sw: 330m1 + 330m1 de duden 6 extension not installable
#i113460# - sw: Rich Text File (.rtf) shows custom style name from template.
#i113461# - sw: erasing non breakable space makes openoffice freeze when document language is French
#i113464# - udk: stoc_smgr::ORegistryServiceManager::dispose crash during shutdown

SOS Open Source last week evaluated LimeSurvey, the PHP open source survey web application to create on line surveys, translated in many languages and downloaded over 485.000 times. (read more at SOS Open Source.)

Double entry ledger with Balance Sheet, Profit/Loss, and Voucher printing

Resumes

#i113448# - Database access: Date Conversion
#i113436# - Database access: when executing prepared statement setDate() - object variable not set
#i113444# - Drawing: Remove Options button in Printer Settings if subpage is empty
#i113447# - Installation: wrong install location for cws ooo330l10n
#i113433# - framework: crash while executing unoapi tests in toolkit
#i113438# - l10n: [DE] ooo330l10n - fix duplicate accelerators in new print UI
#i113435# - l10n: [DE] ooo330l10n - missing accelerator for Open i startcenter
#i113445# - l10n: [JA] difficult to understand the function from Japanese translation of "Save URLs relative to file system"
#i113440# - l10n: ooo330l10n: remark in File - Properties - Security not localized
#i113432# - sc: OpenOffice.org crashes while open the sample file which have over 1024 columns
#i113442# - sc: [DE] ooo330l10n Import html dialog fields to small
#i113434# - sc: command "Show Draw Functions" only works in toolbar
#i113446# - sc: new print dialog - Page Layout tab to narrow
#i113451# - sw: Can not move indent-marker when cells extend between two pages.
#i113441# - sw: Find & Replace button name in new Find toolbar not localizable
#i113449# - sw: In hebrew, Word Count counts a punctuation mark as a word
#i113439# - sw: OpenOffice crash with storeToUrl for writer_pdf_Export
#i113437# - sw: docx: table not imported in header
#i113443# - sw: find and replace
#i113450# - sw: vertical senttings are disregards when text grid.

Dog beach in Kitsilano, Vancouver, BC - July 8th 2010

Financial Calculators

• Managed to get a row of seats on the plane, and to sleep for a chunk of the time; shouldn't have watched highly unpleasant film about dragon tattoo'd girl first.
• Got to St Pancras, who (generously) won't let you get into the free-WiFi / seating area until minutes before the train. Interested to see ibm dropping Solaris support, odd.
• Arrived eventually; out for dinner with a host of banshee guys, back to the hotel to talk with Owen & Dan Winship good, met caillon; to see JRB, Chris & meet caillon; got talking with Lefty.

Google now found a "new" distribution mode for their chromium development builds: parallel installation of frequent developer snapshot. Something OpenOffice.org now has some years: Developer snapshots. Can be installed in parallel side by side the regular OpenOffice.org release. So nothing to improve for OpenOffice.org ? I think there are some things to improve the Developer Snapshots we have now:

1. Improve the name: Find a more attractive name for OOo-Dev (OpenOffice.org Developer snapshots). OpenOffice.org Seagull distribution or so.
2. Improve the advertising: OOo-Dev build or not unstable just because they are Developer snapshot. I'm using those builds since years, they may have some new bugs, but I never lost any data by using OOo-Dev builds. We should be brave and promote our weekly builds more prominently.
3. Make quality a priority for OOo-Dev builds. Meaning not to wait or take some time to fix any reported regressions before the next release but already for the next (OOo-Dev) build.
   

See http://getopenoffice.org/labfiles/    The site is still in transition but the lab files are there and are updated.

Address Label WL-875 (Same size Avery 5160)

File Folder Labels

#i113419# - Chart: Chart 3D look lost if a new series is added
#i113431# - Drawing: "reset routing" vs "reset line skew"
#i113430# - Drawing: reset routing clears the connectors colour
#i113417# - Installation: No change in icons after uninstalling ms office 2010
#i113418# - Presentation: Text lost when importing metafile
#i113420# - de: %PERCENT% string literal
#i113428# - l10n: CWS ooo330l10n - Huge changeset due to mis-ordering on localize.sdf files
#i113427# - l10n: correct wrong strings in Pootle
#i113424# - l10n: localization from Pootle (update for OOO330)
#i113421# - sc: CSV import could ignore leading spaces if the field content without them is quoted.
#i113422# - sc: Calc not responding, unusable (mouse-related?)
#i113415# - sc: Data Pilot: name in filter buttons shown 2 times
#i113416# - sc: Mistakes in proposals calc in function wizard
#i113429# - sc: row break does is not moved down when inserting rows
#i113423# - sw: Spaces appear in document when exported to pdf
#i113426# - sw: Tracked Change in header becomes accepted when a footer is inserted
#i113425# - sw: docx: "Set variable" fields get lost on import

Resume Objectives

Job Descriptions

If you've been typing $^$ into the regular OpenOffice Writer search and replace dialog and coming up empty, try this plugin. It's awesome. It lets you look for a series of empty paragraph returns, or a carriage return at the end of a paragraph plus one empty return, and MUCH much more.

http://extensions.services.openoffice.org/project/AltSearch

Download then choose Tools > Extension Manager to install. Restart OOo and you'll see a new icon in the upper left corner on the main toolbar.

Here's the page.

 

Here's the icon you get when you restart OpenOffice.

 

Here's the window.

 
 Here's the list of regular expression options.

 

And here's an example of what the shown expression found.

 

Blank A10 Drawing Paper

Blank A9 Drawing Paper

Blank A8 Drawing Paper

Blank A7 Drawing Paper

US Trade Sized Dust Jacket Cover Template For Lulu.com

Watching value changing of a cell on the spreadsheet.

This extension works on OOo 3.3 or later, because this extension uses new feature of task pane can be provided by extensions.

After this extension is installed (after the calc component is reloaded), View - Task Pane entry is shown in the main menu of the Calc window, choose it to open the watching window.
Online help is provided, please read using help viewer of the office for usage. You can open the main page of the help through contents tree.

UI languages: en, ja, ru.

#i113410# - Presentation: fails to open .pptx file with correct plots and drawings
#i113413# - sc: 1048576 causes issues when copying and pasting with PTHPasteboard
#i113414# - sc: daysinmonth
#i113411# - sc: refresh data pilot formatting
#i113412# - sw: writer crashes when using xneat clipboard manager

• Up earlyish, T Porter Square to Park Street; fine sermon on the cross from a visiting preacher. T onwards to Fenway; visited Miguel, Laura and tiny, sweet baby Lucia - a wonderful blessing and privilege to be able to see the new family while I was here; caught up with Miguel a little.
• T back to Park St, Finagle a (circularly-sawed) Bagel with Thomas and Becky in the common, wandered the common; dancing with ducks. Rather a pleasant walk to MIT's museum - admired the various displays; particularly the variety of robotic actuators.
• Back to Thomas' via a nice Italian restaurant for pizza, listened to music, talked, packed. Drove to the airport, and the next round of travel madness begins: an intense plane, tube, eurostar, train series to The Hague.
• Highly amused by the Judas Phone art work. I guess there are some downsides to having lots of creative types using your products. Amused by the old phone version - although, reading the definition of smart-phone carefully on wikipedia; it seems clear that we need a new/improved market segmentation. If the Nokia Communicator of 2000 is a smart-phone, it makes me very suspicious of all but "sales in the last quarter" statisticis around phones; or am I just a paranoid.
• Caught up with Eric, and the great OO.o hacking that Jonas is doing, hopefully he'll blog about it soon.

#i113408# - Database access: record update database impossible
#i113409# - sc: Unable to use LN (natural logarithm) within Macro
#i113407# - sw: Change choice of Cross-Reference Display
#i113406# - sw: Convert text to table with AutoFormat: table data lost at reopen of the file

#i113405# - Database access: Table Grid (based on view) becoms unstable when records in base table are updated.
#i113403# - Database access: thisDatabaseDocument.close crashes office
#i113400# - Presentation: Maths brackets misformed in presentation mode
#i113397# - framework: 3.2.1 Upgrade - OpenOfficeOrg32.msi
#i113402# - kde: Any OOo app crashes on start or on menu click with KDE Polyester theme enabled
#i113399# - l10n: [JA] Writer's style name of paragraph "Preformatted Text" is Mistranslated
#i113401# - ru: мыло "Добавить новость" содержит ошибку в адресе
#i113404# - sw: Not responding when opening a file and slowing the windows program.
#i113398# - sw: print-by-chapter option

This extension supports Creating Direct Mail Templates, Uploading Templates to SugarCRM and also Performing Mail Merge, all using OpenOffice.org Office productivity suite. This version also supports Mail Merge for SugarCRM Target Lists.