I found the help page for the add-on in the the Wayback Machine, as it seems to be offline, the page as https://plus.codes/spreadsheet-add-on redirects to a new homepage.
https://web.archive.org/web/20191222034619/https://plus.codes/spreadsheet-add-on Seems the PLUSCODE function accepts (or did!) optional Length param... - =PLUSCODE(location_range, [length]) - length is optional and sets the length of the code. If not specified, codes of length 10 will be returned. If it is specified it must be an even number less than 10, or any number between 10 and 16. ... so it seems should be able to do =PLUSCODE(myLat:mylng, 11) As you want 3 after the + which is after 8. On Mon, Jun 6, 2022 at 4:33 PM philippe titivi <philippe....@gmail.com> wrote: > Hi all, > I want 3 digits after the "+" in a google sheet cell but without using the > "add-on". > > with: =PLUSCODE(myLat:mylng) I only get 2 > > Thanks :-) > > -- > Public site: http://www.openlocationcode.com/ > Github project: https://github.com/google/open-location-code > Demo site: http://plus.codes/ > --- > You received this message because you are subscribed to the Google Groups > "Plus Codes Community Forum" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to open-location-code+unsubscr...@googlegroups.com. > To view this discussion on the web, visit > https://groups.google.com/d/msgid/open-location-code/de1934ea-e7e6-4223-90da-f2bf16fc936bn%40googlegroups.com > <https://groups.google.com/d/msgid/open-location-code/de1934ea-e7e6-4223-90da-f2bf16fc936bn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Public site: http://www.openlocationcode.com/ Github project: https://github.com/google/open-location-code Demo site: http://plus.codes/ --- You received this message because you are subscribed to the Google Groups "Plus Codes Community Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-location-code+unsubscr...@googlegroups.com. To view this discussion on the web, visit https://groups.google.com/d/msgid/open-location-code/CAJCAUuKGjVpdVoqDwU8W4J%2Bdg6bn-1Z2YvufDQAv6hFLoNa4GA%40mail.gmail.com.
