[Solved] Bug found with double quote character

[alcohee]

I was using OpenOffice calc to manipulate inventory data into proper format for upload to an on-line store. In doing so, I used the concatenate function to enclose certain text fragments. In some cases, I inserted the quotes by typing them. When the data was uploaded, the quotes inserted by the concatenate function were recognized as quotes. However, the typed quotes were not recognized as quotes and had a 'slanted' font. The problem can be observed by typing any text into a cell surrounded by double quotes, then use the concatenate function to surround that in quotes. You will notice the two quotes are different. Apparently, they are different characters, because changing the font does not correct it.

Type "X" in cell A1. Then in cell B1 type CONCATENATE("""";A1;"""")

[Villeroy]

This is definitively not a bug. In all office component quotes in written human language are replaced with typographic quotes.
Option #1: You can set the cell's font language to "[None]".
Option #2: Tools>AutoCorrect, tab:Custom Quotes
Both options will not change your data.
Copy a leading quote into the clipboard, call the find&replace dialog and replace it with a normal one. Repeat the same with the ending quotes.

[acknak]

Maybe it's not a bug, but it sure seems like a huge mess to me.

Does anyone want/care about typographical quotes in a spreadsheet? Wouldn't it be better for Calc to have it's own separate option for the autocorrect quotes, or simply disable it altogether?

[alcohee]

Perhaps this was an intentional feature, but I agree with acknak that it should be an optional setting and not the default for a spreadsheet. IMHO topographic quotes are better suited to word processing applications than to spreadsheets. Having text functions output different characters than the keyboard is problematic.