OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Issues relevant to Calc filed or supported by members
Goto page 1, 2  Next
 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Thu Jul 05, 2007 1:47 am    Post subject: Issues relevant to Calc filed or supported by members Reply with quote

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
Back to top
View user's profile Send private message
jwr
OOo Advocate
OOo Advocate


Joined: 06 Sep 2006
Posts: 367
Location: Germany

PostPosted: Thu Jul 05, 2007 3:46 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Thu Jul 05, 2007 6:05 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
jwr
OOo Advocate
OOo Advocate


Joined: 06 Sep 2006
Posts: 367
Location: Germany

PostPosted: Thu Jul 05, 2007 7:10 am    Post subject: Reply with quote

noranthon wrote:
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.


All 3 issues have been discussed in: http://www.oooforum.org/forum/viewtopic.phtml?t=53309
The thread starts with topic 1 (describing a spreadsheet with very complex formulas).

I will try to find out if issues have been filed already and report results in this thread.

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


Last edited by jwr on Wed Jul 25, 2007 3:51 am; edited 1 time in total
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Jul 11, 2007 11:33 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
jwr
OOo Advocate
OOo Advocate


Joined: 06 Sep 2006
Posts: 367
Location: Germany

PostPosted: Wed Jul 11, 2007 9:20 pm    Post subject: Features not supported in Open XML and features not supporte Reply with quote

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
Back to top
View user's profile Send private message
bksgs1
General User
General User


Joined: 28 Mar 2007
Posts: 5
Location: India

PostPosted: Tue Sep 18, 2007 5:04 am    Post subject: pending - Absolute (bogus) reference when Move/Copy a sheet Reply with quote

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
Back to top
View user's profile Send private message
donnast
Newbie
Newbie


Joined: 22 Oct 2007
Posts: 2

PostPosted: Mon Oct 29, 2007 5:58 pm    Post subject: I cant even find how to enable macros Reply with quote

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.
]
Back to top
View user's profile Send private message MSN Messenger
SharkD
General User
General User


Joined: 17 Sep 2008
Posts: 19

PostPosted: Wed Aug 05, 2009 8:39 am    Post subject: Reply with quote

jwr wrote:
We will need some performance to replace these tools.

You can only expect so much from a Java application... However, performance looks a lot better when compared with apps written in Silverlight or AIR or whatever Google uses.
Back to top
View user's profile Send private message
Hosting
Newbie
Newbie


Joined: 28 May 2010
Posts: 1

PostPosted: Fri May 28, 2010 4:44 am    Post subject: Reply with quote

SharkD wrote:
jwr wrote:
We will need some performance to replace these tools.

You can only expect so much from a Java application... However, performance looks a lot better when compared with apps written in Silverlight or AIR or whatever Google uses.


Regarding the performance, I have used Excel for some time before I switched to Open Office and I must say that I don't see any difference in the performance. Of course, if you will do some tests and exactly measure the results you will probably see some difference. However, as an user people will hardly recognize any difference.
_________________
Providing web hosting services for small business.
Back to top
View user's profile Send private message Visit poster's website
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Mon Aug 09, 2010 12:56 am    Post subject: Inconsistent N() function Reply with quote

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

Posted in the issue tracker as Issue 113739.
Back to top
View user's profile Send private message
rutgerhendriks
Newbie
Newbie


Joined: 11 Aug 2010
Posts: 2

PostPosted: Wed Aug 11, 2010 12:44 am    Post subject: Functions with INDIRECT are not recalculated automatically Reply with quote

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.
Back to top
View user's profile Send private message Visit poster's website
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Wed Aug 11, 2010 3:22 am    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
rutgerhendriks
Newbie
Newbie


Joined: 11 Aug 2010
Posts: 2

PostPosted: Fri Aug 13, 2010 12:24 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
Tommy27
OOo Advocate
OOo Advocate


Joined: 18 Nov 2006
Posts: 302

PostPosted: Wed Aug 25, 2010 11:45 pm    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group