CalcEasyToolbar

Provider:
Sim IT Sdn Bhd
Maintainer:
kstan
Rating:
3.5
Average: 3.5 (6 votes)
Application:
Calc
Tags:
calc, , spreadsheets, , merged, , insert row, , remove row, , vertical, , horizontal,
Post date:
Wednesday, 24 December, 2008 - 04:23
Statistics
Week: 20 - Month: 107 - Year: 1,801 - Timeline
Download extension
System Independent version - All releases
Compatible with OpenOffice 4: Unknown
User feedback:
Compatible with OpenOffice 4.x?

This extention is strong recommended for all calc users, it allow remove/insert column easier eventhough selected range is merged.
It work on new openoffice.org calc. Tested version included 2.3.1 and 3.0.
Features:

1. Insert new toolbar which allow user add/remove columns or rows.
2. Allow user to perform mass vertical or horizontal merge easily for range of cell.

This extention is developed using basic, a new toolbar will be generated when user launch a calc after CalcEasyToolbar(CET) installed.
* Thanks for Villeroy technical support, you can view the support forum at http://www.oooforum.org/forum/viewtopic.phtml?p=30374

Plus: Please install this extention to make calc more user friendly. Don't let your users(or you) blame open source softwares sucks. :)
To review the source code, in calc you go to Tools->Macros->Organize Marco->Modules->CalcEasyToolbar->Module1->edit.

CalcEasyToolbar

Version Operating system Compatibility Release date
1.1.2 System Independent 3.4 25/02/2009 - 01:55 More information Download
1.1.1-stable System Independent 3.4 18/01/2009 - 03:22 More information Download
1.1.0-Stable System Independent 3.4 16/01/2009 - 12:45 More information Download
1.0.2-rc-2 System Independent 3.4 10/01/2009 - 04:39 More information Download
1.0.0-rc-1 System Independent 3.4 24/12/2008 - 12:50 More information Download

Comments

This is a very useful extension, though I would like to know if there was any way to move the text to the first cell when merging instead of deleting it?

When I tried to insert a column, I got BASIC error on: cSheet = oDoc.CurrentSelection.getRangeAddress().sheet

When you delete a row or a column the selection is lost. If you need to delete more than one item subsequentially you should each time select deleted item.

Hi all,

I'd release new version of CalcEasyToolbar, the problem exist on previous version (backward compatiblity and 1st row/column) issue is fixed.

This is a best new year present I give to openoffice users at this new year.

* I don't know this plugin whether work with staroffice or others kind of openoffice brother/sister. If working somebody please feedback to me?

Happy new year!

Ks Tan

tested on OOo 2.4.2 and Windows Vista.

the delete row, delete column and insert row now work

the insert column button doesn't work at all

Hi Tommy,

I wonder what is the defect for this bugs? The most stable part should be insert/delete column.

The only possible reason I can guess is OpenOffice API can't detect last modified cell position. Example:

You have 1 blank spreatsheet, you merge quite a lot of cell but didn't input any data. In openoffice API it will consider no any modification in
this page and any cell. In this case, my plugin can't locate all merged position.

To overcome this issue, I hard code my extension loop more 40 rows,20 columns extra from last cell position for safety purpose(Increase will
cause performance penalty, eventhough the performance right now is quite bad).

Sorry for my bad explaination.
As conclusion, user shall make sure there is some extra information insert into spreatsheet so that my system can locate last cell x1,y1,x2,y2 position.

This limitation can be solve if somebody can do help me in this way:
1. Ask openoffice to fix bugs at below
oCursor.RangeAddress.EndRow -> won't return exactly value if the last row is merge only
oCursor.RangeAddress.EndColumn -> won't return exactly value if the last column is merge only

2. Provide me the API to locate every merged range correctly in array.

the "insert column" button is still not working.

other "insert" and "merge" buttons work nice.

Hi Tommy,

Can you provide me the following information?

1. Last column name in calc 2.4.2(in openoffice 3.0 is 'AMJ')
2. Last row number in calc 2.4.2(in 3.0 is 65536)
3. Please give me the sample format which is doesn't work.

Regards,
Ks Tan

i tried your extension in a blank Calc file on OOo 2.4.2
i use a portable version called X-OpenOffice that u can download from here: http://www.winpenpack.com/main/download.php?view.113

1- the last column name is: AB
2- the last row number is: 68
3- what do u mean exactly?

when i hit the isert column button i got a runtime basic error and the "insertrangerights" line of the extension code is highlighted

Hi Tommy,

Ok, I mean, in Calc 2.4.2, what is the last column name? You can press ctrl->right->right to check the last column name
ctrl->down->down to check last row number.
About item 3, I mean can you give me the sample file which is doesn't work?

Regards,
Ks Tan

Ok, i did the Ctrl thongs you said in X-OpenOffice 2.4.2:

1- last column is IV
2- last row is 65536

i've got new information about the insert column runtime error.

the command doesn't work if there are no merged cells in your spreasheet.
however if you merge 2 cells anywhere in the sheet (vertically or orizonatally, it doesn't matter....) the function will then work like the other buttons.

it seems it can work only if merged cells are present in the sheet.
if you remove merged cells the function will not work again.

this behaviour is present in any .ods file on my PC.

Hi Tommy,
Thanks for your report, now I'd figure out where is the problem you mentioned before. Now you can get latest 1.1.1 stable extention.

Good luck!
Regards,
Ks Tan

now everything works fine on OOo 2.4.2 !!! thanks for fixing it!!!

He! He! Hope you enjoy. I saw your product, is it a portable openoffice? Why don't release version 3.0?

i'm not the creator of X-OpenOffice.
it has been created by italian website for portable software www.winpenpack.com

the X-OOo 3.0 release is already available here:
http://www.winpenpack.com/main/download.php?view.1035

i still use the 2.4.2 release but i will upgrade to the 3.x series once the OOo 3.0.1 will be released.

I use OpenOffice 3.0.0 (Build: 9358) on Windows XP.

Upon installing your extension and trying to use it, I receive the following error message:

"Error! You shall select column header and re-run this macro"

Please advise.

Yours respectfully,
fruitjam

i downloaded the extension.

however it seems there are some troubles on my OOo 2.4.2

the only working button is "remove column"

when i hit others i get this error message:
"Error! you shall select row/column and re-run the macro"

the strange thing is that i'm currently selecting row or column header.

am i doin' something wrong?

Great extension idea for those who are waiting for Issue 8302 to be solved , but as reported in the previous comment, it doesn't seem to work properly on some OOo versions ( In OOo 2.4.0 : The insert and remove column work ok, but insert and remove row throw the error "Error! you shall select row and re-run the macro")
Further more, in OOo 3.0, the four buttons are functionnal, but they will give you the standard error (Can't insert row/column when cells are merged) in many cases, for example, when you have two groups of merged cells.
I can provide testcases if it's usefull.

Hi camillem,

Thanks for your test,
It is good ideal if you can probide me all the test cases, when I free I can solve it all in 1 shoot.
My email address is : kstan@simit.com.my
Regards,
Ks Tan

In OOo 3.0 it doesn't work if the merged range includes the first row (1) or the first column (A).

Best regards
VITRIOL

Because merged cells are often used for the 1st row.

Nice work!

well i think this bugs should be fixed...

Hi Tommy,

I agree this is a major bugs, by the way recently too busy with existing project. Will update this extention within this few week (Cause currently my code is mess). Please come back ~ 2009-01-15. Happy new year.

Plus: The temporary solution may be hide 1st column and 1st row, eventhough I know this action is abit stupid.

Sorry for the bugs trouble.
Regards,

Ks

your extension has potential but as i said, is actually too buggy on OOo 2.4.2

i had to uninstall it. however i'll give it another try once you release a fixed version

Update 10/01/2008 : with the 1.0.2, the bug for the first rox/column has disappeared, thank you very much.
Suggestion for the next release : after deleting (it isn't the case when inserting) a row/column, a row/column should be selected and not only the first cell (currently if you have to repeat this action, you have to select again a row/column).

I think that this possibility to insert or delete a line or a column with merged cells should be a basic function in OOo. Thank you very much for repairing this lack. For me, it works under OOo 3 and Vista.
I confirm the bug on 1.0.0 for the first column if there are merged cells an the error message but in spite of that, this extension is useful.

where's the download button?

By default in my plugin it will process max 300 merge cell, if your document have more more you need to manually change the variable size.
You can change it via:
1. Tools->Macro->Organize Macro->Module->CalcEasyToolbar->Module1->Edit
2.Change as below:
From:
dim mergerangex(300) as long
dim mergerangey(300) as long
dim mergerangetox(300) as long
dim mergerangetoy(300) as long
dim mergehandling(300) as string

To:(Example, change to 3000)
dim mergerangex(3000) as long
dim mergerangey(3000) as long
dim mergerangetox(3000) as long
dim mergerangetoy(3000) as long
dim mergehandling(3000) as string

Done.