The following formula appears in the formula bar, which is wonderful: =B7*1.25
But nothing appears in the target cell, not the calculation result, nor the formula.
I'd be very grateful if someone could solve this conundrum.
[Solved] Cell with formula displays nothing
-
- Posts: 3
- Joined: Fri May 07, 2021 1:41 am
[Solved] Cell with formula displays nothing
Last edited by robleyd on Sun May 09, 2021 6:21 am, edited 1 time in total.
Reason: Tagged [Solved]; add green tick
Reason: Tagged [Solved]; add green tick
OpenOffice 4.1.7 on Windows 10
- MrProgrammer
- Moderator
- Posts: 4895
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Cell Won't Populate
Hi, and welcome to the forum.
[Tutorial] Ten concepts that every Calc user should know
Attach a document demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).ApacheChopper wrote:The following formula appears in the formula bar, which is wonderful: =B7*1.25
But nothing appears in the target cell, not the calculation result, nor the formula.
[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
-
- Posts: 3
- Joined: Fri May 07, 2021 1:41 am
Re: Cell Won't Populate
Please see the attached sheet.
Cell H7 is the one that won't populate.
Thank you & have a nice weekend.
Cell H7 is the one that won't populate.
Thank you & have a nice weekend.
- Attachments
-
- BSD_Forum.ods
- Cell H7
- (15.41 KiB) Downloaded 107 times
OpenOffice 4.1.7 on Windows 10
Re: Cell Won't Populate
Right click on H7 and choose a cell format with decimal places.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
- MrProgrammer
- Moderator
- Posts: 4895
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Cell Won't Populate
The display in H7 was exactly what you had requested. The formula value was 0.3125. The numeric cell format (Format → Cells → Numbers → Format code) was # which says to display only the (rounded) integer part but don't display a zero value. Read about format codes in OpenOffice Help → Index → format codes;numbers. A good format code to specify in this situation (nothing shown) is Category → All → Format → General.ApacheChopper wrote:Cell H7 is the one that won't populate.
Your formula in G7 is =SUM(D7/A7). The SUM function is unnecessary. Calc divides D7 by A7 to get a quotient. No addition is needed in the formula so you don't need to use SUM. A shorter formula is =D7/A7. This topic is in section 9 of the tutorial in my first post.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
-
- Posts: 3
- Joined: Fri May 07, 2021 1:41 am