Adding columns

Discuss the spreadsheet application

Adding columns

Postby bartweber » Tue Jan 22, 2019 4:40 pm

since i updated to 4.1.6 my columns that i want a sum only return 0. never had a problem like this with the previous version. thank you
openoffice 4.1.6 on windows 8
bartweber
 
Posts: 4
Joined: Tue Jan 22, 2019 4:32 pm

Re: adding columns

Postby RoryOF » Tue Jan 22, 2019 5:14 pm

Check what data types are in the columns. Turn on /View /Value highlighting to see.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29266
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: adding columns

Postby bartweber » Tue Jan 22, 2019 7:32 pm

nope
openoffice 4.1.6 on windows 8
bartweber
 
Posts: 4
Joined: Tue Jan 22, 2019 4:32 pm

Re: adding columns

Postby RoryOF » Tue Jan 22, 2019 7:34 pm

Without hands-on of the actual sheet, we can only guess.

 Edit: I have just made a test - the Sum function is working correctly for me. 
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29266
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: adding columns

Postby bartweber » Tue Jan 22, 2019 7:47 pm

ok should i go back to4.1.5
openoffice 4.1.6 on windows 8
bartweber
 
Posts: 4
Joined: Tue Jan 22, 2019 4:32 pm

Re: adding columns

Postby RoryOF » Tue Jan 22, 2019 7:49 pm

Without hands-on of your file, how can anyone advise?

What do you see when you enable /View /Value highlighting?
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29266
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: adding columns

Postby bartweber » Tue Jan 22, 2019 7:56 pm

no problems
openoffice 4.1.6 on windows 8
bartweber
 
Posts: 4
Joined: Tue Jan 22, 2019 4:32 pm

Re: adding columns

Postby FJCC » Tue Jan 22, 2019 8:33 pm

Please upload a file so we can look at it. To do that, click Post Reply and then look for the Upload Attachment tab just below the box where you type a response. The size limit is 128 kB.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7224
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 25 guests