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: [email protected]
          Reporter: [email protected]
  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.

Reply via email to