Issues relevant to Calc filed or supported by members

noranthon · Super User Joined: 07 Jul 2005 Posts: 3318

This is somewhat experimental. I've thought of doing something like this previously and a thread in General Discussion prompted me to act.

If you have filed or support an issue of any kind, you can file a post to this thread. The more details you provide, the more likely other members are to take a look.

For those unfamiliar with the procedure, see this thread in Setup & Troubleshooting: Sticky: [ Poll ] Rough step-by-step instructions reporting bugs.

As well as filing an issue, you can vote (2 votes per issue and 5 votes per component), add comments or provide a document demonstrating the issue. To participate in any of those ways, you need to register with OpenOffice.org.
_________________
search forum by month

jwr · Posted: Thu Jul 05, 2007 3:46 am Post subject:

Noranthon,

Thank you for opening the way. Calc's performance is a major topic.
Substituting Word by Writer is easy compared to replacing Excel by Calc.

Whoever wants to substitue Office by OOo will have to replace Excel.

In our company we use a lot of calculation sheets for equipment design.
The sheets do contain a lot of formulas and calculation links. We will need some performance to replace these tools.

I believe a number of requests may be solved if the macro engine would perform fast enough and maybe easier to use. Of course the tool should perform well with large data structures and above all: it is not allowed to crash the system or slow down. Memory leaks are to be avoided.

The main topics for improvement may be:

1. PlancksCnst: spreadsheet that has a very complex formula, -> Calc and Basic both are too slow.
2. TerryE, Calc: undo journalling is crap.
3. TerryE, Calc: the scalc engine within soffice is leaking memory
discussed in: http://www.oooforum.org/forum/viewtopic.phtml?t=53309

Thanks especially to TerryE and thread-members for this analysis.
I am not sure where to vote for improvements to these themes. It would be a big help for voters to find the link, where they can place votes. Voting is simple, but finding a location to vote is quite complex.

Regards -Hans-
_________________
Windows 2K, OOo-2.3.0, MS-IE-6.0, Firefox-1.0.4, MS Office 97,
Say NO to MS OpenXML: http://www.noooxml.org/petition

noranthon · Super User Joined: 07 Jul 2005 Posts: 3318

I'm fairly certain no issues have been filed on 2 and 3 of your list. I have read somewhere that memory leakage is dealt with to some degree in 2.3 but I have not been following the matter; indeed, it's beyond my ken. I am not familiar with your issue 1.

I don't know whether progress can be made on any of those issues without some work by members. I gather that Terry E has less time than he'd like to spend on them.
_________________
search forum by month

jwr · Posted: Thu Jul 05, 2007 7:10 am Post subject:

Villeroy · Posted: Wed Jul 11, 2007 11:33 am Post subject:

Some of my issues, Calc only, all confirmed, all defect, except the last one, which is marked as "enhancement" although the behaviour is just bad.
Rather old. Spreadsheet functions should simply work within specified limits. Oh, where did I mess the specifications?
Off-by-one calculation int() and floor() with large inputs
Same with MOD, but the wrong result has changed Shocked

Advanced filter unusable with case sensitive option
We are supporting an office suite that has no reliable pattern matching
Badly implemented database ranges. Persistantly hidden rows due to lost filter descriptors.

jwr

A documentation-site to the translators for translating Open XML-documents into ODF and vice versa
lists features not supported in Open XML and features not supported in ODF.
If Open XML and ODF are going to be used in parallel we will have to find solutions to cope with these differences.

Link to the MS-translator site: http://odf-converter.sourceforge.net/index.html

List of features not supported in Open XML
http://odf-converter.sourceforge.net/features.html#hUnsupportedDOCX

List of features not supported in Open Document Format
http://odf-converter.sourceforge.net/features.html#unsupportedODT
_________________
Windows 2K, OOo-2.3.0, MS-IE-6.0, Firefox-1.0.4, MS Office 97,
Say NO to MS OpenXML: http://www.noooxml.org/petition

bksgs1 · General User Joined: 28 Mar 2007 Posts: 5 Location: India

The issue of Absolute (bogus) reference when trying to Move/Copy a sheet into a new file is not yet resolved.
See - http://www.openoffice.org/issues/show_bug.cgi?id=62989

rgds
Gopal

donnast · Newbie Joined: 22 Oct 2007 Posts: 2

My spreadsheets are protected by a macro that runs as soon as it opens.... but I cant even get it to the to run the macro to ask the security question....
threfore, I am unable to use calc at all and will probably have to revert oto excel Sad

[quote="jwr"]Noranthon,

I believe a number of requests may be solved if the macro engine would perform fast enough and maybe easier to use. Of course the tool should perform well with large data structures and above all: it is not allowed to crash the system or slow down. Memory leaks are to be avoided.
]

SharkD · General User Joined: 17 Sep 2008 Posts: 19

Hosting · Newbie Joined: 28 May 2010 Posts: 1

keme · Posted: Mon Aug 09, 2010 12:56 am Post subject: Inconsistent N() function

The N() function works inconsistently across builds, and is also not consistent with the application help.

Posted in the issue tracker as Issue 113739.

rutgerhendriks · Newbie Joined: 11 Aug 2010 Posts: 2

I have just submitted a bug about the following issue:

In Cell B1 enter: =IF(A1="","A1 is empty","A1 is filled")
In Cell C1 enter: =IF(A1="","A1 is empty",INDIRECT("'Sheet1'.B1"))
In Cell A1 enter: 1
Check cells B1 and C1:
Cell B1 shows "A1 is filled"
Cell C1 shows "A1 is empty"

In other words, cell B1 is recalculated because A1 changed, but cell C1 is not
recalculated. This always happens when the cell has a formula with INDIRECT in
it. Pressing F9 to recalculate does not fix cell C1. Only pressing
Control+Shift+F9 (Force recalculation) or closing and reopening the document
recalculate cell C1.

keme · Posted: Wed Aug 11, 2010 3:22 am Post subject:

Can't reproduce the INDIRECT() bug with OOo.Calc 3.2.1 (OOo320m18). There the formulas work as expected.

Your use of commas to separate function parameters leads me to suspect that you are using a third party build of the suite (The official build of OOo always uses semicolons). If so, did you also submit an error report to that third party?

rutgerhendriks · Newbie Joined: 11 Aug 2010 Posts: 2

Yes, I use the openoffice from Ubuntu 10.04. In dutch setting I also always use semicolumns, but I switched language to english for this document because it makes more sense to write the formulas with function names that people actually understand Wink

Bug is reported here:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/617264

Tommy27 · OOo Advocate Joined: 18 Nov 2006 Posts: 300

this issue about Calc toolbar is really annoying

Border/Backgroundcolor button on toolbar is not 'sticky'

http://www.openoffice.org/issues/show_bug.cgi?id=10864

already 49 votes but still no precise target milestone (actually 3.x)