https://bugs.freedesktop.org/show_bug.cgi?id=69988
Priority: medium
Bug ID: 69988
Assignee: [email protected]
Summary: Number Copied within Macro Changed to Text with
Leading '
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 86887
--> https://bugs.freedesktop.org/attachment.cgi?id=86887&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
