Associate each colour with a number [as in VLOOKUP()]. So, in column B you might have 1,1,2,2,2,3. Then find the Mode(s) for that column.

David.

Perhaps it does so because it IS larger? With a character in A1, put =CODE(A1) in B1 and you'll see.

David.

Google [freeware convert wpd odt] brings up a few, some free online converters and some commercial.

David.

Dave, I'd love to hear constructive points in an adult manner, so I hope you'll continue with your jets cooled and your sarcasm valve closed. If not, I'll have to open mine wide up and say something like, "Now go away, Dave, or I'll call your parents and get you grounded for your first month o...

A database file can be saved as CSV or other formats. Try that and then open that CSV into the program on the other computer.

David.

The thing is, the RTF standard may be owned by Microsoft, but unlike DOC, it's an open specification. It shouldn't too hard to do. This thread is accomplishing exactly nothing, except allowing someone to vent their frustration. I want it! I want it now!! I want it free, and I want you to do it for ...

When I try to export the file to PDF I recieve an error message saying the file cannot be written. What am I doing wrong. I also created the logo in drawing and got the same result. There are 3rd party softwares to do this, such as PRIMO PDF Creator. Another advantage is that they will also create ...

If this wasn't a troll, it certainly looks like one now. A tempest in a teapot. Someone needs to get a life, and stop wasting time with such trivia. There are many FAR more important issues in this life to think about than a slight thickening of grid lines in selected cells. I see no difference in O...

I downloaded the Excel #2 file and ran it using MS Word for the Mac. It appeared with a white background, thin gridlines, and black lettering. Sorry, I can't do more from here as I don't see what you are seeing. I'll try later on the PC with OpenOffice.

David.

Alternatively, save as a CSV and use CSVed [Windows freeware.]

David.

Vortex wrote:BTW: Why every editor developer thinks I'm demented and need help with capitalization?

You don't really want an answer to that?

Seriously, I agree that those options should be ones you choose to toggle ON, not OFF.

David.

Look, I was unable to replicate the Grid problem via a screen shot and mentioned this in one of my replies. I was trying to END the thread with some pointers on politeness and other matters I'm 72, have helped people here for a long time now, and don't need your pointers. You were asked to send the...

jrkrideau wrote:

thomasjk wrote:Its too bad you didn't try to upload a sample file so we could actually help you. But its your choice to leave.

Why do I suspect a troll?

You or I would have simply uploaded the file and said, "Thanks." I hope he didn't slam the door on the way out.

David.

I can understand formatting time of day as 1:30, or 13:30, perhaps, but if doing calculations such as you indicate, is it not more feasible to have data as minutes only [plain numbers], even if calculated from times of day? Then subtotals might be simpler.

David.

I have a bank account spreadsheet and I'm trying to get it as userfriendly as possible so I can give it to my mom so she can use it as easily as possible. I'm probably the same age as your mom or older, but have used computers for a while longer perhaps. Do her a favour and give her a pen and paper...

I can't understand how a program this complex would have missed such a needed setting? Oh well, unless someone can set me straight?? As far as I know, you are the only person in the world with this particular problem, so it doesn't help to rant about the program functionality. This forum allows fil...

Why don't you just record the hours worked as you go along? There is, though, a way to recognise weekdays by number, I believe. You might look up the WEEKDAY() function in the Help file.

David.

Mine doesn't.

Can you be more specific? Which version of OpenOffice? What platform? What background colour? ...ANything else we shoudl know?

David.

I am using Open Office!! I know I am stupid but not that stupid. Perhaps not, but you really do need to calm down if you truly want help in this forum ...one of the best I've encountered in decades of using the internet. This forum, unlike many others, allows you to upload a file for examination. W...

OK, this effort is gross, but for what its worth... You might use a 24 hour clock [e.g. 17:00 instead of 5:00PM.] In D2 have =60*(HOUR(C1)-HOUR(B1))+(MINUTE(C2)-MINUTE(B2)) Copy down column D. You should find a listing of the minutes worked in column D. Deal with the sum when done to turn back into ...

A logo is usually a drawing. You should use then a drawing program, should you not?

David.

=CHAR(96+ROW()) in row 1 will produce an "a", and =CHAR(64+ROW()) in row 1 will produce an "A". Copy down the columns.

David.

You might need a lot of intelligence and wisdom, but perhaps you mean something like COUNTIF() ?

Or are you looking to reflect the last value for each? A more difficult problem.

David.

I need to be able to edit images because I am compiling a lot of album art for my music library. I use 500x500 images for the archive music and 200x200 so it displays on my portable media player. Windows freeware image/photo editors ... The Gimp, Photofiltre. Freeware dedicated resizer: Faststone s...

Windows? Save yourself some bother, and download and use MathType. Also, a "text "files usually refers to plain text. As Hagar points out, it would be useful if you could be more specific as to the type of document. However, I still suggest MathType for doing formulas [Let's face it, GUI i...

The file gets exported as an excel file. If I save as a text file, writer opens when I try to insert from file. If I try to insert the excel file, I get the same result. Save as .CSV not .TXT or change the extension accordingly. Then it will load into Calc as any other file ...watch the bouncing ba...

Copying my own LP music to MP3 format [an LP is awkward in the car], I found that one music piece would be playing, then it would be interrupted with an entirely different partial piece, then back to the original ...it happens. It's all 1s and 0s. Misplace only one digit and a data can become an ins...

Much easier [for me] if you would say what you are doing, rather than what you are not. That is, can you please either send a copy of the file [an example, not any personal information necessary] or be a bit more descriptive as to the cell contents, formula, conditional or not. When applying a formu...

I'd do it from scratch using the word processor, as a form, not the spreadsheet. The only thing that you'd need to copy/paste would be the logo. All you've done here is to copy an image to the spreadsheet, which accomplishes nothing really.

David.

I expected to have choice to use "reverse video" but cannot. Please, this needs to be changed.... acc. to me it damages much the comfort of using Writer. One thing about the computer is that it replaced the car [slightly] in that people love to compare and to own the latest and greatest. ...