https://bugs.documentfoundation.org/show_bug.cgi?id=93973
Bug ID: 93973
Summary: problems importing csv file containing array formula
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rstil...@gmail.com
when importing a CSV file with an array formula, the array formula becomes
something between a formula and text.
discussed here: http://en.libreofficeforum.org/node/11459
(Thanks to Lupp for his help)
sample csv file:
"{=MATCH(1;ISERROR(A3:A8);0)}"
title
1
2
3
4
"=a3+a6"
"=1+a2"
now import into calc. On the import dialog screen, I am selecting:
separated by: coma,
Text delimiter: double quote,
from line: 1,
character set: unicode (UTF 8 ) this is default
language: Default- English (Canada) this is my default,
all other check boxes blank.
after import I see
{=MATCH(1;ISERROR(A3:A8);0)}
title
1
2
3
4
5
#VALUE
however if you click on cell A1 "The curly brackets vanished in the formula bar
and ... [t]he referenced range got emphasised with a coloured frame" (quoting
the above mentioned thread, because they put it better than me)
This suggests It is recognized as a formula, but the formula text is displayed
is displayed, not the expected number 6. if you click in the input line and
change the formula (for example, hit the space bar, then the backspace key)
then hit ctrl+shift+enter the equation disappears and is replaced by the number
6.
I am using LO 4.2.8.2 under Kubuntu 14.04 LTS
Lupp confirmed on 5.0.0.5 and 3.6.5.2 on Windows 8
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
