By default, Bugzilla does not search the list of RESOLVED bugs.
You can force it to do so by putting the upper-case word ALL in front of your search query, e.g.: ALL tdelibs
We recommend searching for bugs this way, as you may discover that your bug has already been resolved and fixed in a later release.
Bug 1187 - KSpread doesn't recognize $ sign or equations entered from another program
Summary: KSpread doesn't recognize $ sign or equations entered from another program
Status: NEW
Alias: None
Product: TDE
Classification: Unclassified
Component: non-core programs (show other bugs)
Version: R14.0.x [Trinity]
Hardware: Other Linux
: P5 major
Assignee: Timothy Pearson
URL:
Depends on:
Blocks:
 
Reported: 2012-08-26 17:26 CDT by Kris
Modified: 2018-05-27 11:00 CDT (History)
1 user (show)

See Also:
Compiler Version:
TDE Version String:
Application Version:
Application Name:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Kris 2012-08-26 17:26:22 CDT 
I created a personal budget in LibreOffice's spreadsheet program recently and saved it in OpenDocument Format.

When opening it in KSpread from TDE, it will (initially) display all the numbers with a dollar sign ($), but due to a formatting issue (see bug 1185), I need to resize the cells. When I do, it changes "$" to "USD " (e.g. "$100" changes to "USD 100").

In addition, some of the cells are supposed to have an equation in them to set their values, but they do not have this equation. Instead, they are set to whatever value that they had when I last saved in LibreOffice. Changing the value of one of the other cells that the equation is based on does NOT change the value of the cell that should have the equation in it.