Created attachment 86887 [details] Spreadsheet with Macro I have made a macro that I've used for some time to convert QIF files from finance programs to spreadsheet format so that I can use the power of Calcs graphs and what not to analyze my finances. Since release of 4.1 something has changed in which numbers copied are being turned into text with a leading apostrophe (') so balances and analysis is impossible unless I use the third party extension to convert text to number. I have included the macro, to reproduce: Open attachment Enable macros (tools -> options -> security -> macro settings -> medium or low) Click on "Sheet 1" (sheet on attached spreadsheet) Click "Create Ledger" button Once it's done go to "Ledger" sheet Expected: Column C should be currency but it's not, worked in 3.6 and 4.0. Does not work in 4.1 or 4.2 LibreOffice version 4.1.1.2 release Bodhi Linux & Ubuntu 13.04 Last worked on: 4.0.3.3 release Noel - not sure if this is yours or not. Cc'ed you to see if this is some expected change or if this is a regression, if it's a regression I'll get a bibisect together.
It is a regression and more likely my fault.
Except if I understood wrongly, we can put this one as NEW
Markus, you want a bibisect of this?
Don't worry about a bibisect. I know when I broke stuff ;), the problem is more finding time to fix it.
Use standardized whiteboard tag: bibisectrequested -> bibisectrequest
Per Markus' comment - removing bibisectrequest
Apparently existed on 4.0.4.2
Changing Line 311 from pasteSheet.getCellByPosition(2,pasteRow).String = pasteValue to pasteSheet.getCellByPosition(2,pasteRow).Formula = pasteValue and values get set correctly. I'd rather think that this behavior is correct. When you set value to a cell via its String property, it forces the value to become text which in this case is achieved by prepending value with an apostrophe. Is this good enough answer, Joel?
Yup makes sense. Closing as NOTABUG. Thanks Kohei