CarnetApp/CarnetNextcloud

Pasting Excel formulas

b4too opened this issue · 0 comments

b4too commented

Hello,

I can't find a way to save these formulas as a memo in a note :

=CONCATENER("insert into parameters values ('outlet_id_";D1;E1;"','IF_TAX','outlet_id_";D1;E1;"','";F1;";";H1;"','outlet_id_";D1;E1;"','string');";)
  
=CONCATENER("insert into parameters values ('service_id_";D1;E1;"','IF_TAX','service_id_";D1;E1;"','";G1;";";H1;"','service_id_";D1;E1;"','string');";)
 
=SI(C5="";SI(C4="";SI(C3="";SI(C2="";C1;C2);C3);C4);C5)

I tried to add a string ( 'Formula' ) in front of '=' in case the '=' was interpreted but I can't get it to save it.
I can paste it but not save it.

Steps to reproduce the behavior:

  1. Go to a newly created note
  2. Paste the formulas
  3. Quit
  4. See that it won't be saved

Done on image linuxserver/nextcloud:latest on Docker 20.10.7 on linux, amd64 with latest update of Carnet