Public bug reported:
Binary package hint: openoffice.org-calc
Short :
When creating a new file from a template, then saving it, the CELL("filename")
function stills return the template file name. I need to edit the cell
containing the formula (=CELL("filename") ) to get the function to return the
new file name.
Longer:
I use a name scheme (invoice numbering & date) and use CELL("filename") to
retrieve the file name and extract the invoice number and date from the file
name.
I create a new file from a template (therefore temporarily named UntitledN). I
fill some data in it and save it to its final name. My invoice number and date
are still in error because the CELL("filename") is still returning the template
file name and not the new file name.
If I print, or export to PDF, the filename is not updated. If I save many
times, the filename is not updated. If I save to a new file name, the filename
is not updated, etc.
If I close my file and re-open, the correct file name is displayed.
Alternatively, if I edit the formula where I retrieve the filename (adding a
trailing space after the closing parenthesis, erasing it, hit return) the name
is updated (and I get my correct invoice number and date).
This behaviour is unchanged since many versions of OO, and consistent on
Linux (ubuntu) and Windows (XP).
Saving the file to a new name should update CELL("filename")
ProblemType: Bug
Architecture: i386
Date: Tue Oct 28 11:57:59 2008
DistroRelease: Ubuntu 8.04
Package: openoffice.org-core 1:2.4.1-1ubuntu2
PackageArchitecture: i386
ProcEnviron:
PATH=/usr/lib/openoffice/program:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
LANG=en_GB.UTF-8
SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.24-21-generic i686
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
** Tags: apport-bug
--
CELL("filename") not updated when file is saved
https://bugs.launchpad.net/bugs/290222
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
