While I think I understand what you're trying to do, my lack of knowledge regarding the UNIQUE function in Google may mean that my understanding is incorrect. Can you tell us where in the Google spreadsheet the UNIQUE function is placed? If it's A2 (as I suspect), then you might want to reconsider u...

I'm not an expert with pivot tables, but for future reference please include a copy of your actual spreadsheet (confidential information removed), rather than a picture. We can get a lot more information from the spreadsheet than what a picture gives us.

As this topic is marked as Solved, you should've started a new topic.
Additionally including a sample of your spreadsheet, sensitive information removed, helps a lot for us trying to replicate your specific circumstances.

Autosum, by default, will not include the results of a previous sum function.
Exactly how it finds the first cell to use for the sum range, I don't know, but I do know that if there is a cell with a SUM function in it, the cell below it will be the first cell that is included in the Autosum.

I second MrProgrammers recommendation of using a Vlookup table rather than going with multiple IFs

Are you sure you navigated to the 32 bit Java and not the 64 bit version? Years ago I made this same mistake.

As to the discrepancy between semi-colon and comma for the parameter separator, this has been the case for years. OpenOffice has, to my knowledge, always used the semi-colon as the parameter separator rather than the comma. As a side note, regarding your signature information about not wanting to up...

I didn't reverse anything.
You made a comment in the public forum, thus it can, and probably will be, taken to apply to all users.
You may have meant for it to be for specific users, but it was not posted as such.

We are end users, like you, that voluntarily attempt to provide help and/or solutions.
We do not need or deserve to be insulted as you did in your last post.

Killing a task forces the task to close no matter what processes are taking place. Using the proper close procedure will remove the lock file as that is part of the closure procedure. Why are you using a command line sequence to force close (kill) soffice when your profile indicates that you are usi...

Welcome to the Forums. I admit I don't know what's going on, but I do know that screenshots are, for the most part, useless to us. Please upload/attach a copy of your actual document using the same method that you used for the screenshots. That way we can check if there are any particular settings t...

Welcome to the Forums. As your sheet is currently configured, vlookup will not work, since you are wanting to search B/C and return A Vlookup will search A and return from B/C One option is to move (or copy) A to D, the you can use two Vlookups (one for B and one for C) to return from D, which is (n...

If it is your choice, then that's what it is. There's rarely a right or wrong way of doing something especially when there are multiple methods of obtaining the same results. One method might be better, faster, more secure, etc. than another, but that doesn't mean that the second method is wrong. To...

Does this only happen when the file is e-mailed?
Have you tried other methods of file transfer, like Google drive or Dropbox?
What is the size of the file being e-mailed?

I don''t know if this is the reason, but years ago (ie: 1980's) positive numbers and zero had a space in front of them to allow for the sign location, even though the sign + isn't seen. I suggest that this might be the reason, even though it's been around for quite a while. What happens if you try a...

Try Data -> Filter -> Standard Filter
There's an option to copy matches to a different location, which can be a different sheet.
Unfortunately I don't have access to my version of OpenOffice so I can't look at your sample or tell you exactly what I think your best option will be.

Then it sounds to me like you should stop using OpenOffice as it doesn't meet your requirements and switch to LibreOffice, which (apparently) does. For some time now we have recommended switching from OpenOffice to LibreOffice. Your simple example A1+B1+C1 given text in one of those locations does r...

In your very first sentence of your original post you state "In OO 1.1.5 and all versions of LibreOffice strings in cell are (or can be) handled as zero." Yet in your last post you state "as long as the old version works and, if not, I would switch to LO" The first quote would le...

MrProgrammer did provide you with a possible workaround.

The SUM function knows to treat text as a 0 value. Using straight addition does not have this ability. You stated tbat you have very long formulas that sum ranges, which made me think that you were using the SUM function, rather than an extended sequence of cell addresses separated by the + symbol. ...

I suggest updating your software to the most recent version.
For years functions like SUM ignore text/treat it like a 0 when the text is in a cell that is in the SUM range.
OpenOffice 1.1.5 was released Sept. 14, 2005. That was (about) 17 1/2 years ago.

As stated many times in many different topics, OpenOffice is (realistically) the walking dead. LibreOffice is, has been (for many years) and probably will be the best upgrade from OpenOffice. If you have trouble with LibreOffice, you can post in these forums and we, to the best of our ability, will ...

Changing the extension of a file doesn't change the format of the file. What format was the file originally saved in? If you want us to try to restore/fix the file you'll need to upload/attach the actual file or put it onto a file sharing site like Dropbox, Google Drive, or MediaFire. Without the ac...

Welcome to the Forums I have two suggestions. The first is to enter your dimensions in two different cells, rather than just one. Calc will NOT recognize any of your data, entered as shown, as numbers. If you enter the dimensions in two cells, you can sort the first column in Ascending order, and yo...

I have a Windows 8 system that has LibreOffice 7.5.0 on it and haven't had any problems.
I don't know about Windows 7, but just thought I'd put my 2 cents worth in regarding this.

Welcome to the Forums. Are your hyperlinks accessing websites or local documents? If they are accessing websites, it can be due to old coding processes where the # symbol was not allowed in website addresses. Even now, most websites won't allow a # symbol in the website address, thus the % symbol wa...

As stated previously, supply an example of your spreadsheet showing the problem.
Without that information we're just making best guesses based on our experience, but they are still guesses.

Since there is nothing wrong with the format of the formula, I suspect that the problem lies in the data. Please note that the = comparison is very specific and Calc might see something that doesn't match when, to your eyes it is a match. Example $1234.56 could be 1234.56 formatted in currency or a ...

While I don't have an answer for you, please note that using MS Office formats as default is not recommended.
Please read the tutorial located at viewtopic.php?t=83694&hilit=MS+Office+formats

This has come up previously.
https://answers.microsoft.com/en-us/win ... 91f?auth=1