Simon Murphy does reflect in a recent article on how most of his recent work in spreadsheet programming has been connected to server data.
It reminded me to check up on the announced support for OpenOffice.org Calc by the Palo Spreadsheet server. Unfortunately no product announcements have been made. But it appears Jedox still pursues the idea, as they put it on the list of projects the Palo Server team wanted to apply for Google’s Summer of Code funding.
User:conficio: Software documentation one screencast at a time
The developers of OpenOffice.org have implemented some major improvement of memory usage for OpenOffice.org Calc. In their sample spreadsheet it reduces the overall memory requirement by 28%. I have some users of OOo complain to me that Calc could not handle very large spreadsheet and it so it was very slow. This could be a major step to alleviate their pain.
Don’t hold your breath yet, because this improvement will only come to you with release 2.3 planned in September 2007.
User:conficio: Software documentation one screencast at a time
The developers of OpenOffice.org have implemented some major improvement of memory usage for OpenOffice.org Calc. In their sample spreadsheet it reduces the overall memory requirement by 28%. I have some users of OOo complain to me that Calc could not handle very large spreadsheet and it so it was very slow. This could be a major step to alleviate their pain.
Don’t hold your breath yet, because this improvement will only come to you with release 2.3 planned in September 2007.
User:conficio: Software documentation one screencast at a time
Software easter eggs are popular among programmers and geeks alike. No, you can’t eat them and they don’t count for you diet as calories. But like real easter eggs, they are hidden features found in some applications.
The OpenOffice.org easter egg is a space invader style game, hidden in OOo Calc. To find it:
Voila, you got a game that resembles “Space Invaders”.
User:conficio: Software documentation one screencast at a time
Jedox, the company behind the Palo Spreadsheet server has started to seek sponsors for supporting OpenOffice.org Calc. In an interesting marriage of open source and commercial project sponsorship, they have found pledges from an Australian Winery and some German engineering firms. However, at this point the tally stands at 6500 Euro, which is not much for a medium size software project.
The idea behind this effort is to store spread sheet data on a server and offer OLAP capability to create sophisticated reports, that can be aggregated among many dimensions, such as sales data by month, quarter, year, sales person, region, customer size, promotional costs, support costs or any combination of these. This kind of application gears towards enterprise customers who need analytical aggregation of data to support decision processes.
Palo server is an open source project and is currently only available for Microsoft Excel.
User:conficio: Software documentation one screencast at a time
Are you in need of Fuzzy math. I do not mean the political rhetoric, but rather the mathematical concept of fuzzy logic and fuzzy math.
Now you can calculate with fuzzy math in OpenOffice.org Calc spreadsheets, thanks to the new InrecoLAN FuzzyMath component.
The component allows to use uncertain or approximate values in OpenOffice.org Calc. It means you can perform ordinary arithmetic operations and use ordinary mathematical and financial functions with uncertain values as if they are standard, or crisp, numbers. The component allows you to create and edit fuzzy numbers, use fuzzy numbers in formulas. You can also display the graphs from the fuzzy numbers and results of calculations.
Fuzzy math has strong mathematical basis. This component enhances all mathematical and financial OpenOffice.org Calc functions for which fuzziness might be reasonable.
InrecoLAN FuzzyMath is distributed under GNU General Public Licese (GPL). Source code and the newest versions of the component are available at SourceForge.
Learn more about it at www.openfuzzymath.org.
User:conficio: Software documentation one screencast at a time