Reappraisal of spontaneous R-parity violation