Bug 56449 - edit formula, add quote to end before =" to beginning
Summary: edit formula, add quote to end before =" to beginning
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.1.2 release
Hardware: x86 (IA32) All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-27 03:29 UTC by S.Andreason
Modified: 2015-05-03 18:10 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description S.Andreason 2012-10-27 03:29:17 UTC
If I want to edit a formula, press [Enter] to enter the edit bar, or aka. input line box, and type the end of the formula before the beginning, it alters my double-quote into a slanting double-quote, which breaks the formula with a non-valid character.

To duplicate: enter into cell
A1= 10.91
Decide to edit the number, press [Enter] to begin editing.
Cursor at end, so type a word of text followed by a the double-quote [Shift]-'
"
Press [Home] to edit the beginning, adding two characters  
="
Press [Enter] to accept, error dialog pops up: 
LibreOffice Calc found an error in the formula, do I wish to accept it's changes?
If I press Yes, it becomes ="10.91 only”"
If I press No, it becomes #NAME? ="10.91 only”

Suggested fix, typing before the double-quote should not convert it to a slanted double-quote.
Looking in AutoCorrect, Localized options, I did have the double quote box checked.
It still shouldn't apply to editing in a formula bar.
Comment 1 tommy27 2014-10-30 06:27:24 UTC
still reproducible with LibO 4.3.2.2 under Win7x64

anyway next time do not set status NEW to your own bugs if they have not been reproduced by another user. an independent confirmation is always needed to obtain that status.
Comment 2 S.Andreason 2015-05-03 18:10:09 UTC
Updated my primary system with
LibreOffice_4.4.2_Linux_x86_deb.tar.gz
and checked this bug, I find it works now. 
Thank you.