Thanks everyone. When I tried applying the format to the cells before entering any data, it was overwritten once I entered data. ie. Set cells x1,x2,x3 ect to text -> enter numbers -> then it reverts to number round to two dp. But yeah, I will be changing the default table in styles, great idea 🙂
We all use this powerful program for different uses, and I am very grateful both for your help, and for AOO itself. 😉 Had a quick look through the various styles, not sure which particular style is used for formatting, when editing the styles I could not find the "desired cell formatting" context. Probably in their somewhere, just pressed atm, will have a look in future. Perhaps add into a future feature list somewhere? ie. if user inputs number string to 8 decimal places, then do nothing, unless set to something specific. IE. By default no rounding should occur when I insert a large numerical string, unless I specifically tell the cell I want it rounded to a specific value. It would be better 🙂 ________________________________ From: Jörg Schmidt <joe...@j-m-schmidt.de> Sent: Thursday, 10 June 2021 7:13 PM To: dev@openoffice.apache.org <dev@openoffice.apache.org> Subject: RE: Changing default rounding in Writer Tables > -----Original Message----- > From: Dean.Webber [mailto:2018001...@student.sit.ac.nz] > Sent: Thursday, June 10, 2021 2:07 AM > To: dev@openoffice.apache.org > Subject: Changing default rounding in Writer Tables > > Dear Devs, > > How hard would it be to change the default rounding in the > tables to the entered value or similar. Or perhaps, can I > change it to accept text as an entry by default (ie in settings)... You can change this as you wish by defining a standard document template for Calc and adjusting the settings there. (a) In the menu: Format-->Styles and Formatting, select the cell template "Default" in the appearing dialog and in the context menu of this template set the desired cell formatting in the tab "Numbers". (b) Then call up the menu: File-Templates-Save and save the document as a template. (c) Finally call: File-Template-Organize, search for the newly saved template, create the context menu and select the entry "Set as default Template". Done. From now on the cell format in all new documents will be as you just set it in (a). Jörg --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
