Apache OpenOffice (AOO) Bugzilla – Issue 90476
Image cropping in Calc needs mouse tools
Last modified: 2014-01-28 17:51:35 UTC
I have long found that when I need to print something from the computer screen, the easiest way to do it was to hit PrintScreen, then paste it into an Excel spreadsheet, then crop and resize it till I have what I want. I just tried the same thing using OOo Calc 3.0Beta, and discovered that it is much more difficult. Calc brings up a window with measurements you can change, and its own snapshot of the graphic that shows where you are moving the borders to. It works, but it is hard to get it just right. You cannot see it well, and must often invoke the tool, change the measurements, and quit the tool several times to get it just where you want it. PLEASE add a mouse tool that can be used directly on the image in the spreadsheet. The cropping icon could still bring up the window, and then a button in that window could close the window and replace it with the mouse tool. Thanks, Tim (WinXP Home SP2, AMD Duron 950 processor) PS: Why does hitting the apostrophe while I_m typing (like just then! I put a line where I tried to put the apostrophe.) bring up a QuickFind tool instead. That_s very frustrating!
This issue exists. Mouse tools for editing images in Calc is necessary.
I'm changing this issue to Enhancement since it is not a Defect (a current function not working). timdeaton : Is your apostrophe input problem related to OpenOffice.org at all?"
The apostrophe problem had nothing to do with OpenOffice. That was a problem with this website at the time I was typing that message. Apparently it's not a problem tonite, so I don't know if it was a one-time glitch or if it's something that's been fixed since my original comments.
reassigning features and enhancements to user requirements@openoffice.org which will be the default owner for those tasks (was introduced some time ago)
Calc is a spreadsheet program, not a graphic editor.
I am very sorry to see the attitude expressed in Edwin's post. After all, I'm not asking for anything that hasn't been in Microsoft Excel for more than 17 years. (If Excel could do it in 1997, surely Calc should be able to do it by 2014.) I frequently want to crop & overlay two Google Maps screenshots so they fit together. Or save an entire year of cropped screenshots of payroll tax confirmation screens on the same spreadsheet page. Excel is not a graphic editor either. Yet it's far easier to use it for the purposes I described than Word or Paint. By contrast, doing the same thing in OpenOffice Calc 3.x is torture. (I haven't used 4.x, but the comments here lead me to believe it hasn't changed.) I'll leave the status for appropriate project managers to correct. I sincerely hope that you will take another look at this and decide to reopen it. Thanks, Tim
1. Calc is not an Excel clone. 2. This request was in unconfirmed status for five and a half years. 3. Bug author is not using AOO - see comment 6. I'm against this enhancement request. Let's see what others think.
Hi timdeton, we could add this, but as a workaround you could just do what you want to do in draw/impress directly. You may also copy/paste your graphic to draw/impress (image editors), crop there and copy back. Or do the same with Drag&Drop. I see no urgent need to add the cropping tools to calc, but also no arguments against it.