Created attachment 162669 [details] Example LO Writer document MS Word support RnCn style references in table formulas. LibreOffice Writer doesn't. I have attached some example documents.
Created attachment 162670 [details] Example MS Word Document
I tried putting R1C1 in brackets, like this: <R1C1> But it still didn't work.
Version: 7.1.0.0.alpha0+ Build ID: 503c0d9427e5611a59f7904a3184a51198468266 CPU threads: 12; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: CL
Created attachment 163903 [details] Comparison MSO 2010 and LibreOffice 7.1 master
Reproduced in Version: 7.1.0.0.alpha0+ Build ID: 32090b018d9ff81659a4c9ed41c64109ebebe4fc CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
I've been looking into this issue by some degree. I did notice that <RnCn>, while absolute, doesn't work in LibreOffice, but RnCn does get a random number, as if it assumes A1 style. The formula does work with A1 or B2 and whatnot. Version: 7.1.0.0.alpha0+ Build ID: 52820b52b3bca45e2db527d1cc5f4488b2e0b9d0 CPU threads: 8; OS: Mac OS X 10.15.6; UI render: default; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Still reproducible in Version: 7.2.0.0.alpha0+ Build ID: 84af20ef3ea72190784e9e7be820684c2558ba8c CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded values are 0 now