Problem in the drawing layer of Calc: Adding points to a line in Calc does not work. Clicking on the icon "Points" has no effect. Also the toolbar "edit points" does not show up. This bug is only in Calc. This feature works perfectly in Writer, Draw and Impress.
MenuItem : edit -> "Edit points" missing from menu
Steps to reproduce:
* Open Calc
* Make sure that the toolbar "Drawing" is activated (view->Toolbars->drawing)
* Draw a line in the empty spreadsheet
* Click on the icon "Points" in the toolbar "drawing"
* Nothing happens. In Writer,Draw, Impress, the toolbar "edit points" opens and makes it possible to add points and to bend the line.
As far as I know this used to work in Calc some years ago. During that date, the bug was entered in the OpenOffice issue tracker: http://openoffice.org/bugzilla/show_bug.cgi?id=55720 Nevertheless, I assume that it is an easy to solve bug. Apparently, no developer has ever looked into it since 2005.
[Reproducible] with "LibreOffice 3.4Beta3 – WIN7 Home Premium (64bit) German UI [DEV300m103 (Build:3)]"
Same with OOo 1.1.4, 3.1, dev 3.4
The corresponding OOo Issue is
"Toolbar and menu "edit - edit points" missing in CALC"
I doubt that that is intended, but because of the long history of the problem I do not see much importance.
Is there any definition for Whiteboard "SkillCpp"?
Created attachment 46440 [details]
Example for typical usage of bended lines
I doubt that the importance of the bug is low/minor. I very often receive
Excel-files that include bended lines/arrows in order to highlight important
relations between cells. Please see attached .xls-file as an example. To produce something similar in Calc is impossible due to this bug. I really wouldn't take the age of the OOo-bug as indicator for the importance of the bug ;-)
I believe that this is an easy to solve bug. Am I right?
@Rainer: I took the Whiteboard definition from
means C++ skills.
Small remark to original bug entry:
Before committing the bug, I wanted to have deleted the phrase "MenuItem : edit
-> "Edit points" missing from menu". Apparently, I didn't. This phrase is
unimportant for this bug entry.
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Created attachment 56093 [details]
screenshot of edit points toolbar
reproduced in LibO 3.6.0 master on Fedora 64 bit
to reproduce: draw line, select it and press button "Points" on Drawing toolbar
"Edit points" toolbar not appears
This request for enhancement is still valid for current versions of LibreOffice
*** Bug 45225 has been marked as a duplicate of this bug. ***
I have the same problem - but in Draw. No way to get toolbar to appear. Edit menu item is missing. If I add the icon to the Drawing toolbar, it is not functional.
Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80
Windows 7 64-bit
Already see that with OOo-Dev 3.2.2, so inherited from OOo.
May be one of the the roots of the problem is that you even can't create such a toolbar because the functions (add point, ...) are not available in Calc under 'Tools -> Customize -> Toolbars -> Add ... -> Category=Drawing- Commands'
In WRITER it's available.
May be it never was intended to have those functions in Calc? But I wonder why.
I believe your problem is something completely different.
@Rainer: As far as I know, this functionality was there in OpenOffice in pre-2.0 days. However I do not have the possibility to cross-check now (version 1.1.5 is in fact quite long time ago :-)
I still believe that this issue can be easily fixed, but I believe no one had a look at the issue since 2005.
The old link to the OpenOffice bug entry was broken. Here is the new one:
Side note: I just installed some old OpenOffice.org 1.1.5 in an Crossover Bottle and also there it does not work. Now, I am a bit confused, because I remember a discussion with OpenOffice developers seven years ago where it was mentioned that this bug came in with version 2.0.?!
Same problem with Calc in
LibreOffice 126.96.36.199 – Ubuntu 13.10 (64bit) Italian UI Build ID:410m0(Build:2)
I wish to work on this bug. Can someone tell me where to look for the code for the Drawing Toolbar in Writer as well as Calc?
Thanks for interesting in this bug
Please, try to ask here:
@Rachit: Thanks for looking into this bug, this is highly appreciated. Have you received the code pointers and information you were looking for? If not, have you already asked at the developers mailing list?
I confirm the problem in LibreOffice 4.2, 4.1.5 and 4.1.3, with Windows XP.
In my opinion the problem has a certain importance.
"Edit points" either was never implemented in Calc (only the icon is there, but no feature behind) or it is a very old bug. In a forum, there was a user who started his StarOffice 5.2 and could confirm this bug.
Original post (in German language):
"Punkte hinzfügen" gibt es nicht, weil die "Bezierobjektleiste" in
StarOffice Calc 5.2 nicht angezeigt wird. Die gibt es nur in Writer, Draw und
Es ist also keine Regression, sondern tatsächlich ein uralter Bug aus
den 90ern. :-)
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.3 or later)
If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results;
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for your help!
-- The LibreOffice QA Team This NEW Message was generated on: 2015-06-08
Bug/enhancement request still valid for Version: 188.8.131.52
Build-ID: 40m0(Build:2), Gebietsschema: de_DE
*** Bug 67341 has been marked as a duplicate of this bug. ***
*** Bug 95756 has been marked as a duplicate of this bug. ***
Migrating Whiteboard tags to Keywords: (needsDevEval)
@Gülşah: I felt free to add you to this bug. I have see that you worked on the drawing tools of Calc. This bug here is also related to the drawing features of Calc. It refers to a bug related to Bezier lines and particularly the "add points to line" feature.
@Gerry Added my list. Thanks let me know.
It seems that @Rachit is not working on this bug. Can I work on this one?
So the main issue is that the Calc doesnt have the Edit Points toolbar in View > Toolbars, so I assume all that is needed to be done is to
1. copy bezierobjectbar.xml from writer into calc
2. copy the toolbar entry from writer's window state file into calc's window state file
@Yousuf Thanks! That helps a lot.
I copied https://opengrok.libreoffice.org/xref/core/sw/uiconfig/swriter/toolbar/bezierobjectbar.xml to core/sc/uiconfig/scalc/toolbar/bezierobjectbar.xml and edited https://opengrok.libreoffice.org/xref/core/officecfg/registry/data/org/openoffice/Office/UI/CalcWind... Here is the diff of CalcWindowState.xcu https://pastebin.com/SZ796WZB However I still cannot see ‘Edit Points’ option in View >Toolbars
(In reply to Vikas Mahato from comment #28)
> Any suggestions?
You'd likely also need to add it into UIConfig_scalc.mk like UIConfig_swriter.mk.
Yes, the 'Edit Points' option and bezierobjectbar are now visible. I also saw that the code for the functionality of bezierobjectbar lives in beziersh.cxx. However a corresponding uibase folder does not exist in calc. How should I proceed?
(In reply to Vikas Mahato from comment #30)
> Yes, the 'Edit Points' option and bezierobjectbar are now visible.
Great. Submit the patch to gerrit for review.
> I also
> saw that the code for the functionality of bezierobjectbar lives in
> beziersh.cxx. However a corresponding uibase folder does not exist in
> calc. How should I proceed?
beziersh.cxx isnt available in impress and draw, so likely its also not needed for calc. If the toolbar functions fine, then likely there isnt anything else to be done. Beyond this a dev would have to give input on what else is needed.
Maxim, Gulsah: thoughts.
(In reply to Yousuf Philips (jay) from comment #32)
> Great. Submit the patch to gerrit for review.
I have submitted a patch
(In reply to Vikas Mahato from comment #33)
> I have submitted a patch
Guess more work is needed as clicking the button doesnt show/hide the contextual toolbar and the buttons on the toolbar dont get activated when on an appropriate drawing object.
(In reply to Yousuf Philips (jay) from comment #34)
> Guess more work is needed as clicking the button doesnt show/hide the
> contextual toolbar and the buttons on the toolbar dont get activated when on
> an appropriate drawing object.
Yes. I am unable to find the corresponding code in writer. Can you give me any pointers or docs which I can use to find how it works in writer?