Okay, thanks. However, to your Merge Cells comment, why isn't this Merge Cells option available in the Format Cells popup box from right-clicking and going to Format Cells? And why not in Right-Click options itself? It seems they only placed it in one area, and you have to go to it from the top bar, not through any other method, like Right-Clicking.
Also, I would've never guessed that something as useful as AutoComplete would be hidden in a little subsection of the Tools section, and not somewhere logical, like the Options section. Again, it seems like they are hiding major functionality where nobody can find it without knowing the program's ins and outs. Default Formatting, apparently it's only visible from one place, the Right-Click menu. It's not from the Format Cells popup box itself, and none of the options like Text allow you to remove it. I can't understand why they'd make only one right answer for the whole program to be able to do this instead of placing the solution in other places as well. I still stand by my point about a mass format change. Try changing multiple cells to different format types. Now highlight them all and try to change them to one type. Doesn't work. It can't change them all, in fact, it doesn't appear to change any of them. For optimal column/row settings, just highlight the row/column headers and right-click optimal column width. It has an automatic setting of Add 0.1 and makes columns much wider sometimes. For some reason it does do it the right size sometimes and other times does not. I am still trying to understand the discrepancy. It definitely is prone to setting them much wider than they should be, however. The double-clicking works for some cells, and not others. In one column, for example, I have only a single digit/letter in any given row, yet the column width gets set to .89-.91. I am using the latest version of OpenOffice, 3.2.1. I just downloaded it yesterday. I was also using a trial of MS Office 2010, and saved it as a regular file, which now can't open in OpenOffice. Well, I appreciate the response, and begin to better understand the intent to upgrade and update the OOo interface. Functionality is very difficult to get to, and whereas with Office would be accessible from multiple areas, is only available from one spot in OOo programs. What makes this bad is it's not even in the most logical places either, but in out of the way ones to my thinking at least. Joshua Zambrano On Wed, Nov 10, 2010 at 1:19 PM, Harold Fuchs <[email protected]>wrote: > On 10/11/2010 10:42, Joshua Zambrano wrote: > >> Hello, I just wanted to drop off some recommendations for OpenOffice, as a >> user of office suites. >> >> -CALC >> >> - Merge Cells. No capability to merge cells that I can see, a very >> valuable feature. >> > > Look in the Help under Merge; in particular at the entry "merging cells". > > - Turn Off Auto Complete. Keeps turning everything it can into date >> >> format, very annoying. Should be able to turn this off, but option not >> visible that I can see. >> > > Google quickly found Tools>Cell Contents>AutoInput. Uncheck the AutoInput > option. > > - Remove Hyperlinks. Hyperlinks shown can't be easily deleted. Going >> to >> >> the hyperlink window does not show an address there. Should be able to >> hit >> backspace to remove hyperlink like with MS Excel, but does not work. >> This >> forces you to delete hyperlinks and type in the whole link text over >> again, >> also time-consuming. >> > > See the Help under Hyperlinks; in particular the entry under "deleting" > and/or the one under "turning off automatic recognition". > > - Mass Format Change. Highlighting many cells and trying to change the >> >> format (number/date/text/currency) does not work, you must change each >> individually, a time-consuming issue. >> > > This is simply wrong. Highlight the cells and choose Format>Cells or right > click and choose Format Cells from the context menu. Also applies to whole > rows or columns. > > - Optimize Rows/Columns: Going to optimize row heights or column widths >> >> does not work. It does not set them to ideal settings, merely makes >> them >> even wider. >> > > Evidence please. Please give a detailed example. I have never had a problem > in this area. > > > Let alone the shortcut of clicking upper left cell and then a >> row/column boundary to instantly optimize size like in MS Excel. >> > > Don't know about this in Excel as I haven't used it for about 5 years (OOo > only). If you position the cursor precisely between the column headings (on > a column boundary) it changes to a line with arrows pointing right and left. > Double click now and the column will adjust itself to the width of the > widest entry. Is this what you meant? If not, please say clearly what you > did mean. > > > -WRITER >> >> - Can't Open MS Word 2010 .doc Files. Crashes just trying to open >> them. >> > > What version of OOo are you using? The most recent versions will happily > open most docx files which is what I assume you mean. I suggest you upgrade > to the latest 3.2.1 and try again. If you still have no luck come back here > with details. > > >> Joshua Zambrano, Jzyehoshua >> >> > > -- > Harold Fuchs > London, England > >
