https://bugs.freedesktop.org/show_bug.cgi?id=75617
Priority: medium
Bug ID: 75617
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Libre Calc - improper conversion of filepaths to
lowercase in formula
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: b...@billhowell.ca
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.2.1 rc
Component: Spreadsheet
Product: LibreOffice
I have just updated to LibreOffice Version: 4.2.1.1 Build ID: 420m0(Build:1)
with Kubuntu KDE Platform Version 4.11.5. This update seems to have resolved
whole computer freeze-ups due to unintended cell moves and hopefully will
resolve wifi-sleep drive whole computer freeze-up that has been happening only
for ~1 month or so.
But now a new error has appeared: Some formulae are changing the case of quoted
text to lowercase - a fatal problem when dealing with file names and paths.
For example :
=IF($N5+D$2+1<Today,-99,COUNTIF('file:///home/bill/contacts/0_ToDo.ods'#$Dates,$N5+D$2))
is changed to:
=IF($N5+D$2+1<Today,-99,COUNTIF('file:///home/bill/contacts/0_todo.ods'#$dates,$N5+D$2))
This seems to depend on copying the cell, or perhaps the function used? (here
COUNTIF). A different formula, lso referring to a different workbook sheet, is
not changed (at least, not yet) :
='file:///home/bill/Contacts/0_ToDos.ods'#$TimeLog.E6205
I couldn't find any more "Writing" or formatting aids to turn off to prevent
the case change - perhaps I missed something. I suppose that if somehow text
could be used with an "eval" or "execute" type unction (execute a text string),
this could be avoided, but off-hand I can't remember such a function in Libre
Calc (indirect would just move the same problem elsewhere, I think). A fix
would be to write a script to do the recalcs - but that defeats a big part of
why a spreadseet is used for such a simple function.
Any suggestions?
--
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
