You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2017/01/11 22:12:01 UTC
[Issue 127283] New: does not recalculate after saveas
https://bz.apache.org/ooo/show_bug.cgi?id=127283
Issue ID: 127283
Issue Type: DEFECT
Summary: does not recalculate after saveas
Product: Calc
Version: 4.1.3
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: claytonh@netscape.net
Target Milestone: ---
Created attachment 85913
--> https://bz.apache.org/ooo/attachment.cgi?id=85913&action=edit
example of formula that does not recalculate after a saveas
I have invoices with file names that include the invoice number.
i.e. 17001-01 Invoice.ods
A formula in the invoice pulls the invoice number out of the filename.
=(MID(CELL("filename");79;FIND("/";CELL("filename"))+2))
When I need a new invoice, I open a previous one and do a saveas to the new
invoice number.
i.e. 17001-02 Invoice.ods
The formula does not recalculate; does not pull the new invoice number from the
file name.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127283] does not recalculate after saveas
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127283
--- Comment #3 from Clayton <cl...@netscape.net> ---
adding &0*RAND() does not help in my case.
=(MID(CELL("filename");79;FIND("/";CELL("filename")&0*RAND())+2))
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127283] does not recalculate after saveas
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127283
Oliver Brinzing <ol...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oliver.brinzing@gmx.de
--- Comment #2 from Oliver Brinzing <ol...@gmx.de> ---
adding &0*RAND() may help to change the value,
see https://bugs.documentfoundation.org/show_bug.cgi?id=94975 for example
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127283] does not recalculate after saveas
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127283
Clayton <cl...@netscape.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |claytonh@netscape.net
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127283] does not recalculate after saveas
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127283
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oooforum@free.fr
Resolution|--- |DUPLICATE
Status|UNCONFIRMED |RESOLVED
--- Comment #1 from oooforum (fr) <oo...@free.fr> ---
Already reported
CELL function works as MS-Excel behavior
*** This issue has been marked as a duplicate of issue 68188 ***
--
You are receiving this mail because:
You are the assignee for the issue.